Link to home
Start Free TrialLog in
Avatar of Everlearner
Everlearner

asked on

PHP unexpected EOF

Hi I have been working on this for a while, it's not a complicated script, but I've been looking at it for ages and I'm sure I'm missing something really simple.

I think a pair of fresh eyes will greatly help.

Thank for your help.

<?php 
session_start();
//main.php
require_once('connection.php');
if(isset($_SESSION['user']))
{

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
$id = $_GET['ID'];
$sql="SELECT * FROM harvest WHERE ID='$ID'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);

$title=$row[title];
$fname = $row[f_name];
$sname = $row[s_name];
$dob = explode("/",$row[DOB]);
$dob_d = $dob[0];
$dob_m = $dob[1];
$dob_y = $dob[2];

$marital = $row[marital];

$add1 = $row[house];
$add2 = $row[street];
$add3 = $row[city];
$postcode = $row[postcode];

$tel1 = $row[m_tel];
$tel2 = $row[h_tel];

$email = $row[email];

$appt = explode("-",$row[ApptDate]);

$appt_d = $appt[2];
$appt_m = $appt[1]; 
$appt_y = $appt[0];

$apptT = explode(":",$row[ApptTime]);

$appt_h = $apptT[0];
$appt_m = $apptT[1];

$status = $row[Status];

$accepted = explode("-",$row['AcceptedDate']);
$acc_D = $accepted[2];
$acc_M = $accepted[1];
$acc_Y = $accepted[0]; 

$rejRea = $row[RejectionReason];

$solution = $row[Solution];

$solVal = $row[Value];

$firstVal = $row[FirstPaymentValue];

$addedCost = $row[AddedCost];

$compOwed = $row[CompaniesOwed];

$debtAmount = $row[DebtAmmount];

$partnerDebt = $row[PartnerDebt];

$partnerWork = $row[PartnerWork];

$partnerBenefits = $row[PartnerBenefits];

$firstPaymentDate = explode("-",$row[FirstPaymentDate]);

$fp_day = $firstPaymentDate[2];
$fp_month = $firstPaymentDate[1];
$fp_year = $firstPaymentDate[0];


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit page OBFTS</title>
</head>

<body>

<div id="edit_container">
 

<strong>Name</strong>
<br />
<form id="edit_customer" action="update.php">
<input name="title"/>


<input name="first_name"/>


<input name="last_name"/>

<br  class="clearfix"/>
<strong>Date of Birth </strong>
<br  />
<input name="day" value="<?php echo $dob_d; ?>" />
<input name="month" value="<?php echo $dob_m; ?>" />
<input name="year" value="<?php echo $dob_y; ?>" />

<br  class="clearfix"/>
<strong>Marital:</strong> <br  />
<select name="marital">
<option value="single" <?php if($marital=='single'){?> selected="selected"<?php } ?>>Single</option>
<option value="divorced" <?php if($marital=='divorced'){?> selected="selected"<?php } ?> >Divorced</option>
<option value="married" <?php if($marital=='married'){?> selected="selected"<?php } ?> >Married</option>
<option value="together" <?php if($marital=='together'){?> selected="selected"<?php } ?> >Living together</option>
<option value="Widowed" <?php if($marital=='widowed'){?> selected="selected"<?php } ?> >Widowed</option>
<option value="Separated" <?php if($marital=='Seperated'){?> selected="selected"<?php } ?> >Separated</option>
 </select>
 <br  class="clearfix"/>
 
<strong>Address:</strong> <br  />
<input  name="add1" value="<?php echo $add1; ?>"/><br  />
<input  name="add2" value="<?php echo $add2; ?>"/><br  />
<input  name="add3" value="<?php echo $add3; ?>"/> <br />
<input  name="postcode" value="<?php echo $postcode; ?>" />
<br class="clearfix" />

<strong>Telephone Numbers</strong> <br  />
<input name="tel1" value="<?php echo $tel1; ?>"/>
<input name="tel2" value="<?php echo $tel2; ?>"/>

<br  class="clearfix"/>
<strong>Email</strong><br />
<input name="email"  value="<?php echo $email; ?>"/> />
<br  />
<textarea name="notes" cols="50" rows="15" >Notes</textarea>

<br class="clearfix" />
<h2>Callback/Appointment Details</h2>
<strong>Appointment Date</strong><br />
<select name="appt_day">


<option value="">dd</option>
<?php
					$i =01;
					while ($i <= 31) {
						echo "<option  value=\" $i \"";  if($i == $appt_d) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 
					}

?>
 </select>
<select name="appt_month"><option  value=""></option>
<?php
					$i =01;
					while ($i <= 12) {
						echo "<option  value=\" $i \"";  if($i == $appt_m) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<select name="appt_year"><option value="" selected="selected"></option>

<?php
					$i =2011;
					while ($i <= 2014) {
						echo "<option  value=\" $i \"";  if($i == $appt_y) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<br class="clearfix" />


<strong>Appointment Time</strong><br />
<select name="appt_hours"><option value=""> </option>
<?php
					
					$i =00;
					while ($i <= 23) {
						echo "<option  value=\" $i \"";  if($i == $appt_h) { echo "selected=\"selected\""; }  echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<select name="appt_mins"><option value=""></option>


<?php
					
					$i =00;
					while ($i <= 59) {
						echo "<option  value=\" $i \"";  if($i == $appt_m) { echo "selected=\"selected\""; }  echo ">$i</option>";
						$i++; 

					}
?>

 </select>

<br class="clearfix">

<textarea name="appt_notes" cols="50" rows="15"> </textarea>

<br class="clearfix" />

<h2>Call Details</h2>
<strong>Call Status </strong> <br />
<select name="callStatus"> 
<option value=""></option>
<option <?php if($status == signed ) {?> selected="selected"<?php } ?>  value="signed">Signed</option>
<option value="cf" <?php if($status == 'cf' ) {?> selected="selected"<?php } ?> >CF</option>
<option value="pbo" <?php if($status == 'pbo' ) {?> selected="selected"<?php } ?> >PBO</option>
</select>
<br class="clearfix">

<strong>Accepted Date</strong> <br />
<input name="acc_day" value="<?php echo $acc_D; ?>" />
<input name="acc_month" value="<?php echo $acc_M; ?>" />
<input name="acc_year" value="<?php echo $acc_Y; ?>">

<br class="clearfix" />

<strong>Rejection reason</strong> <br />
<select name="rejReason"><option value=""></option>
<option value="1c" <?php if($rejRea == "1c" ) {?> selected="selected"<?php } ?>>Only one creditor</option>
<option value="ni" <?php if($rejRea == "ni" ) {?> selected="selected"<?php } ?>>Not interested</option>
<option value="ca" <?php if($rejRea == "ca" ) {?> selected="selected"<?php } ?>>Can't afford min</option>
<option value="fees" <?php if($rejRea == "fees" ) {?> selected="selected"<?php } ?>>fees</option>
<option value="wcb" <?php if($rejRea == "wcb" ) {?> selected="selected"<?php } ?>>Won't change bank</option>
<option value="nc" <?php if($rejRea == "nc" ) {?> selected="selected"<?php } ?>>No Contact</option>
<option value="bos" <?php if($rejRea == "bos" ) {?> selected="selected"<?php } ?>>bos</option>
</select>

<br class="clearfix" />

<strong>Solution</strong> <br />
<select name="solution">
<option value=""></option>
<option value="dmp" <?php if($Solution == "dmp" ) {?> selected="selected"<?php } ?> >DMP</option>
<option value="ppi" <?php if($Solution == "ppi" ) {?> selected="selected"<?php } ?> >PPI</option>
<option value="lf" <?php if($Solution == "lf" ) {?> selected="selected"<?php } ?> >Loan Referral</option>
</select>

<br class="clearfix" />

<strong>Solution Value</strong> <br />
<input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

<br class="clearfix"/>


<strong>First Payment Value</strong> <br />
<input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

<br class="clearfix"/>

<strong>Added Cost</strong> <br />
<input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

<br class="clearfix"/>


<strong>First Payment Date</strong> <br />  
<input type="text" name="fp_day"  <?php if ($fp_day != "")  {?> value="dd" <?php } else {?> value="<?php echo $fp_day; ?>"  />
<input type="text" name="fp_month" <?php if ($fp_month != "")  {?> value="mm" <?php } else {?> value="<?php echo $fp_month; ?>" />
<input type="text" name="fp_month" <?php if ($fp_year != "")  {?> value="yyyy" <?php } else {?> value="<?php echo $fp_year; ?>" />

<br class="clearfix"/>

<h2>Debts </h2>

<strong>Debt Amount </strong><br />
<select name="debtAmount">
<option value="">Not Set</option>
<option value="1" <?php if($debtAmount == "1" ) {?> selected="selected"<?php } ?>>under &pound;2,000</option>
<option value="2"<?php if($debtAmount == "2" ) {?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
<option value="3" <?php if($debtAmount == "3" ) {?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
<option value="4" <?php if($debtAmount == "4" ) {?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
<option value="5" <?php if($debtAmount == "5" ) {?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
<option value="6" <?php if($debtAmount == "6" ) {?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
<option value="7" <?php if($debtAmount == "7" ) {?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
<option value="8" <?php if($debtAmount == "8" ) {?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
<option value="9" <?php if($debtAmount == "9" ) {?> selected="selected"<?php } ?>>&pound;100,000+</option>
</select>

<strong>Companies Owed </strong><br />
<select name="companiesOwed">
<option value="">Not Set</option>
<?php
					
					$i =00;
					while ($i <= 20) {
						echo "<option  value=\" $i \"";  if($i == $compOwed) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 
					}

?>

</select>

<strong>Partner Debt</strong><br />
<select name="partnerDebt">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerDebt == "yes") { echo "selected=\"selected\""; } ?>>yes</option>
<option value="no" <?php if($partnerDebt == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<strong>Partner Work</strong><br />
<select name="partnerWork">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerWork == "yes") { echo "selected=\"selected\""; } ?>>Yes</option>
<option value="no" <?php if($partnerWork == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<strong>Partner Benefits</strong><br />
<select name="partnerBenefits">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerBenefits == "yes") { echo "selected=\"selected\""; } ?>>Yes</option>
<option value="no" <?php if($partnerBenefits == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<input type="submit" value="Update">

</form>
  
  
</div>

</body>
</html>

<?php }

else {
header("location:index.php");
}

?>

Open in new window

SOLUTION
Avatar of Marco Gasi
Marco Gasi
Flag of Spain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
One problem I see is that you reference your array values as:

$add1 = $row[house];

when it should be:

$add1 = $row['house'];


you need quotes around your array indicies when you use strings.
Sorry, the right file is this:
<?php
session_start();
//main.php
require_once('connection.php');
if (isset($_SESSION['user'])) {

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
    $id = $_GET['ID'];
    $sql = "SELECT * FROM harvest WHERE ID='$ID'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);

    $title = $row[title];
    $fname = $row[f_name];
    $sname = $row[s_name];
    $dob = explode("/", $row[DOB]);
    $dob_d = $dob[0];
    $dob_m = $dob[1];
    $dob_y = $dob[2];

    $marital = $row[marital];

    $add1 = $row[house];
    $add2 = $row[street];
    $add3 = $row[city];
    $postcode = $row[postcode];

    $tel1 = $row[m_tel];
    $tel2 = $row[h_tel];

    $email = $row[email];

    $appt = explode("-", $row[ApptDate]);

    $appt_d = $appt[2];
    $appt_m = $appt[1];
    $appt_y = $appt[0];

    $apptT = explode(":", $row[ApptTime]);

    $appt_h = $apptT[0];
    $appt_m = $apptT[1];

    $status = $row[Status];

    $accepted = explode("-", $row['AcceptedDate']);
    $acc_D = $accepted[2];
    $acc_M = $accepted[1];
    $acc_Y = $accepted[0];

    $rejRea = $row[RejectionReason];

    $solution = $row[Solution];

    $solVal = $row[Value];

    $firstVal = $row[FirstPaymentValue];

    $addedCost = $row[AddedCost];

    $compOwed = $row[CompaniesOwed];

    $debtAmount = $row[DebtAmmount];

    $partnerDebt = $row[PartnerDebt];

    $partnerWork = $row[PartnerWork];

    $partnerBenefits = $row[PartnerBenefits];

    $firstPaymentDate = explode("-", $row[FirstPaymentDate]);

    $fp_day = $firstPaymentDate[2];
    $fp_month = $firstPaymentDate[1];
    $fp_year = $firstPaymentDate[0];
    
print<<<_HTML_
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <title>Edit page OBFTS</title>
        </head>

        <body>

            <div id="edit_container">


                <strong>Name</strong>
                <br />
                <form id="edit_customer" action="update.php">
                    <input name="title"/>


                    <input name="first_name"/>


                    <input name="last_name"/>

                    <br  class="clearfix"/>
                    <strong>Date of Birth </strong>
                    <br  />
                    <input name="day" value="<?php echo $dob_d; ?>" />
                    <input name="month" value="<?php echo $dob_m; ?>" />
                    <input name="year" value="<?php echo $dob_y; ?>" />

                    <br  class="clearfix"/>
                    <strong>Marital:</strong> <br  />
                    <select name="marital">
                        <option value="single" <?php if ($marital == 'single') { ?> selected="selected"<?php } ?>>Single</option>
                        <option value="divorced" <?php if ($marital == 'divorced') { ?> selected="selected"<?php } ?> >Divorced</option>
                        <option value="married" <?php if ($marital == 'married') { ?> selected="selected"<?php } ?> >Married</option>
                        <option value="together" <?php if ($marital == 'together') { ?> selected="selected"<?php } ?> >Living together</option>
                        <option value="Widowed" <?php if ($marital == 'widowed') { ?> selected="selected"<?php } ?> >Widowed</option>
                        <option value="Separated" <?php if ($marital == 'Seperated') { ?> selected="selected"<?php } ?> >Separated</option>
                    </select>
                    <br  class="clearfix"/>

                    <strong>Address:</strong> <br  />
                    <input  name="add1" value="<?php echo $add1; ?>"/><br  />
                    <input  name="add2" value="<?php echo $add2; ?>"/><br  />
                    <input  name="add3" value="<?php echo $add3; ?>"/> <br />
                    <input  name="postcode" value="<?php echo $postcode; ?>" />
                    <br class="clearfix" />

                    <strong>Telephone Numbers</strong> <br  />
                    <input name="tel1" value="<?php echo $tel1; ?>"/>
                    <input name="tel2" value="<?php echo $tel2; ?>"/>

                    <br  class="clearfix"/>
                    <strong>Email</strong><br />
                    <input name="email"  value="<?php echo $email; ?>"/> />
                    <br  />
                    <textarea name="notes" cols="50" rows="15" >Notes</textarea>

                    <br class="clearfix" />
                    <h2>Callback/Appointment Details</h2>
                    <strong>Appointment Date</strong><br />
                    <select name="appt_day">


                        <option value="">dd</option>
    <?php
    $i = 01;
    while ($i <= 31) {
        echo "<option  value=\" $i \"";
        if ($i == $appt_d) {
            echo "selected=\"selected\"";
        } echo ">$i</option>";
        $i++;
    }
    ?>
                    </select>
                    <select name="appt_month"><option  value=""></option>
                        <?php
                        $i = 01;
                        while ($i <= 12) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_year"><option value="" selected="selected"></option>

                        <?php
                        $i = 2011;
                        while ($i <= 2014) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_y) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <br class="clearfix" />


                    <strong>Appointment Time</strong><br />
                    <select name="appt_hours"><option value=""> </option>
                        <?php
                        $i = 00;
                        while ($i <= 23) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_h) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_mins"><option value=""></option>


                        <?php
                        $i = 00;
                        while ($i <= 59) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>

                    <br class="clearfix">

                        <textarea name="appt_notes" cols="50" rows="15"> </textarea>

                        <br class="clearfix" />

                        <h2>Call Details</h2>
                        <strong>Call Status </strong> <br />
                        <select name="callStatus"> 
                            <option value=""></option>
                            <option <?php if ($status == signed) { ?> selected="selected"<?php } ?>  value="signed">Signed</option>
                            <option value="cf" <?php if ($status == 'cf') { ?> selected="selected"<?php } ?> >CF</option>
                            <option value="pbo" <?php if ($status == 'pbo') { ?> selected="selected"<?php } ?> >PBO</option>
                        </select>
                        <br class="clearfix">

                            <strong>Accepted Date</strong> <br />
                            <input name="acc_day" value="<?php echo $acc_D; ?>" />
                            <input name="acc_month" value="<?php echo $acc_M; ?>" />
                            <input name="acc_year" value="<?php echo $acc_Y; ?>">

                                <br class="clearfix" />

                                <strong>Rejection reason</strong> <br />
                                <select name="rejReason"><option value=""></option>
                                    <option value="1c" <?php if ($rejRea == "1c") { ?> selected="selected"<?php } ?>>Only one creditor</option>
                                    <option value="ni" <?php if ($rejRea == "ni") { ?> selected="selected"<?php } ?>>Not interested</option>
                                    <option value="ca" <?php if ($rejRea == "ca") { ?> selected="selected"<?php } ?>>Can't afford min</option>
                                    <option value="fees" <?php if ($rejRea == "fees") { ?> selected="selected"<?php } ?>>fees</option>
                                    <option value="wcb" <?php if ($rejRea == "wcb") { ?> selected="selected"<?php } ?>>Won't change bank</option>
                                    <option value="nc" <?php if ($rejRea == "nc") { ?> selected="selected"<?php } ?>>No Contact</option>
                                    <option value="bos" <?php if ($rejRea == "bos") { ?> selected="selected"<?php } ?>>bos</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution</strong> <br />
                                <select name="solution">
                                    <option value=""></option>
                                    <option value="dmp" <?php if ($Solution == "dmp") { ?> selected="selected"<?php } ?> >DMP</option>
                                    <option value="ppi" <?php if ($Solution == "ppi") { ?> selected="selected"<?php } ?> >PPI</option>
                                    <option value="lf" <?php if ($Solution == "lf") { ?> selected="selected"<?php } ?> >Loan Referral</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution Value</strong> <br />
                                <input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Value</strong> <br />
                                <input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

                                <br class="clearfix"/>

                                <strong>Added Cost</strong> <br />
                                <input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Date</strong> <br />  
                                <input type="text" name="fp_day"  <?php if ($fp_day != "") { ?> value="dd" <?php } else { ?> value="<?php echo $fp_day; ?>"  />
                                    <input type="text" name="fp_month" <?php if ($fp_month != "") { ?> value="mm" <?php } else { ?> value="<?php echo $fp_month; ?>" />
                                        <input type="text" name="fp_month" <?php if ($fp_year != "") { ?> value="yyyy" <?php } else { ?> value="<?php echo $fp_year; ?>" />

                                            <br class="clearfix"/>

                                            <h2>Debts </h2>

                                            <strong>Debt Amount </strong><br />
                                            <select name="debtAmount">
                                                <option value="">Not Set</option>
                                                <option value="1" <?php if ($debtAmount == "1") { ?> selected="selected"<?php } ?>>under &pound;2,000</option>
                                                <option value="2"<?php if ($debtAmount == "2") { ?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
                                                <option value="3" <?php if ($debtAmount == "3") { ?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
                                                <option value="4" <?php if ($debtAmount == "4") { ?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
                                                <option value="5" <?php if ($debtAmount == "5") { ?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
                                                <option value="6" <?php if ($debtAmount == "6") { ?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
                                                <option value="7" <?php if ($debtAmount == "7") { ?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
                                                <option value="8" <?php if ($debtAmount == "8") { ?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
                                                <option value="9" <?php if ($debtAmount == "9") { ?> selected="selected"<?php } ?>>&pound;100,000+</option>
                                            </select>

                                            <strong>Companies Owed </strong><br />
                                            <select name="companiesOwed">
                                                <option value="">Not Set</option>
                                                <?php
                                                $i = 00;
                                                while ($i <= 20) {
                                                    echo "<option  value=\" $i \"";
                                                    if ($i == $compOwed) {
                                                        echo "selected=\"selected\"";
                                                    } echo ">$i</option>";
                                                    $i++;
                                                }
                                                ?>

                                            </select>

                                            <strong>Partner Debt</strong><br />
                                            <select name="partnerDebt">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerDebt == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>yes</option>
                                                <option value="no" <?php if ($partnerDebt == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Work</strong><br />
                                            <select name="partnerWork">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerWork == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerWork == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Benefits</strong><br />
                                            <select name="partnerBenefits">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerBenefits == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerBenefits == "no") {
                                    echo "selected=\"selected\"";
                                } ?>>No</option> 
                                            </select>

                                            <input type="submit" value="Update">

                                                </form>


                                                </div>

                                                </body>
                                                </html>
_HTML_;
            } else {
                header("location:index.php");
            }
            ?>

Open in new window

My mistake...  PHP will tolerate bare strings as long as they are not also a defined constant in your script in which case the value of the constant would be substituted for the index.

Was there more of an error message or something that gave a line number?
Avatar of Everlearner
Everlearner

ASKER

just this as an error...

Parse error: parse error in C:\wamp\www\tracking\edit2.php on line 387


I tried your Heredoc solution and although I didn't get any errors some of the inline php wasn't being executed :s

Can you tell what code is not executed?

And let me understand: I have only 363 lines...
Sorry, yes I added a few conditionals at the top after the explodes in case they were blank so to stop them referencing array members that didn't exist that's why the extra lines of code.

The code not being executed is the stuff within the select elements and input elements, and the while loops that generate the options  
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try to use nowdoc instead: nowdoc notation should be good for embedding php code. Please copy and paste the code below and test it.
<?php
session_start();
//main.php
require_once('connection.php');
if (isset($_SESSION['user'])) {

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
    $id = $_GET['ID'];
    $sql = "SELECT * FROM harvest WHERE ID='$ID'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);

    $title = $row[title];
    $fname = $row[f_name];
    $sname = $row[s_name];
    $dob = explode("/", $row[DOB]);
    $dob_d = $dob[0];
    $dob_m = $dob[1];
    $dob_y = $dob[2];

    $marital = $row[marital];

    $add1 = $row[house];
    $add2 = $row[street];
    $add3 = $row[city];
    $postcode = $row[postcode];

    $tel1 = $row[m_tel];
    $tel2 = $row[h_tel];

    $email = $row[email];

    $appt = explode("-", $row[ApptDate]);

    $appt_d = $appt[2];
    $appt_m = $appt[1];
    $appt_y = $appt[0];

    $apptT = explode(":", $row[ApptTime]);

    $appt_h = $apptT[0];
    $appt_m = $apptT[1];

    $status = $row[Status];

    $accepted = explode("-", $row['AcceptedDate']);
    $acc_D = $accepted[2];
    $acc_M = $accepted[1];
    $acc_Y = $accepted[0];

    $rejRea = $row[RejectionReason];

    $solution = $row[Solution];

    $solVal = $row[Value];

    $firstVal = $row[FirstPaymentValue];

    $addedCost = $row[AddedCost];

    $compOwed = $row[CompaniesOwed];

    $debtAmount = $row[DebtAmmount];

    $partnerDebt = $row[PartnerDebt];

    $partnerWork = $row[PartnerWork];

    $partnerBenefits = $row[PartnerBenefits];

    $firstPaymentDate = explode("-", $row[FirstPaymentDate]);

    $fp_day = $firstPaymentDate[2];
    $fp_month = $firstPaymentDate[1];
    $fp_year = $firstPaymentDate[0];
    
print<<<'HTML'
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <title>Edit page OBFTS</title>
        </head>

        <body>

            <div id="edit_container">


                <strong>Name</strong>
                <br />
                <form id="edit_customer" action="update.php">
                    <input name="title"/>


                    <input name="first_name"/>


                    <input name="last_name"/>

                    <br  class="clearfix"/>
                    <strong>Date of Birth </strong>
                    <br  />
                    <input name="day" value="<?php echo $dob_d; ?>" />
                    <input name="month" value="<?php echo $dob_m; ?>" />
                    <input name="year" value="<?php echo $dob_y; ?>" />

                    <br  class="clearfix"/>
                    <strong>Marital:</strong> <br  />
                    <select name="marital">
                        <option value="single" <?php if ($marital == 'single') { ?> selected="selected"<?php } ?>>Single</option>
                        <option value="divorced" <?php if ($marital == 'divorced') { ?> selected="selected"<?php } ?> >Divorced</option>
                        <option value="married" <?php if ($marital == 'married') { ?> selected="selected"<?php } ?> >Married</option>
                        <option value="together" <?php if ($marital == 'together') { ?> selected="selected"<?php } ?> >Living together</option>
                        <option value="Widowed" <?php if ($marital == 'widowed') { ?> selected="selected"<?php } ?> >Widowed</option>
                        <option value="Separated" <?php if ($marital == 'Seperated') { ?> selected="selected"<?php } ?> >Separated</option>
                    </select>
                    <br  class="clearfix"/>

                    <strong>Address:</strong> <br  />
                    <input  name="add1" value="<?php echo $add1; ?>"/><br  />
                    <input  name="add2" value="<?php echo $add2; ?>"/><br  />
                    <input  name="add3" value="<?php echo $add3; ?>"/> <br />
                    <input  name="postcode" value="<?php echo $postcode; ?>" />
                    <br class="clearfix" />

                    <strong>Telephone Numbers</strong> <br  />
                    <input name="tel1" value="<?php echo $tel1; ?>"/>
                    <input name="tel2" value="<?php echo $tel2; ?>"/>

                    <br  class="clearfix"/>
                    <strong>Email</strong><br />
                    <input name="email"  value="<?php echo $email; ?>"/> />
                    <br  />
                    <textarea name="notes" cols="50" rows="15" >Notes</textarea>

                    <br class="clearfix" />
                    <h2>Callback/Appointment Details</h2>
                    <strong>Appointment Date</strong><br />
                    <select name="appt_day">


                        <option value="">dd</option>
    <?php
    $i = 01;
    while ($i <= 31) {
        echo "<option  value=\" $i \"";
        if ($i == $appt_d) {
            echo "selected=\"selected\"";
        } echo ">$i</option>";
        $i++;
    }
    ?>
                    </select>
                    <select name="appt_month"><option  value=""></option>
                        <?php
                        $i = 01;
                        while ($i <= 12) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_year"><option value="" selected="selected"></option>

                        <?php
                        $i = 2011;
                        while ($i <= 2014) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_y) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <br class="clearfix" />


                    <strong>Appointment Time</strong><br />
                    <select name="appt_hours"><option value=""> </option>
                        <?php
                        $i = 00;
                        while ($i <= 23) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_h) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_mins"><option value=""></option>


                        <?php
                        $i = 00;
                        while ($i <= 59) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>

                    <br class="clearfix">

                        <textarea name="appt_notes" cols="50" rows="15"> </textarea>

                        <br class="clearfix" />

                        <h2>Call Details</h2>
                        <strong>Call Status </strong> <br />
                        <select name="callStatus"> 
                            <option value=""></option>
                            <option <?php if ($status == signed) { ?> selected="selected"<?php } ?>  value="signed">Signed</option>
                            <option value="cf" <?php if ($status == 'cf') { ?> selected="selected"<?php } ?> >CF</option>
                            <option value="pbo" <?php if ($status == 'pbo') { ?> selected="selected"<?php } ?> >PBO</option>
                        </select>
                        <br class="clearfix">

                            <strong>Accepted Date</strong> <br />
                            <input name="acc_day" value="<?php echo $acc_D; ?>" />
                            <input name="acc_month" value="<?php echo $acc_M; ?>" />
                            <input name="acc_year" value="<?php echo $acc_Y; ?>">

                                <br class="clearfix" />

                                <strong>Rejection reason</strong> <br />
                                <select name="rejReason"><option value=""></option>
                                    <option value="1c" <?php if ($rejRea == "1c") { ?> selected="selected"<?php } ?>>Only one creditor</option>
                                    <option value="ni" <?php if ($rejRea == "ni") { ?> selected="selected"<?php } ?>>Not interested</option>
                                    <option value="ca" <?php if ($rejRea == "ca") { ?> selected="selected"<?php } ?>>Can't afford min</option>
                                    <option value="fees" <?php if ($rejRea == "fees") { ?> selected="selected"<?php } ?>>fees</option>
                                    <option value="wcb" <?php if ($rejRea == "wcb") { ?> selected="selected"<?php } ?>>Won't change bank</option>
                                    <option value="nc" <?php if ($rejRea == "nc") { ?> selected="selected"<?php } ?>>No Contact</option>
                                    <option value="bos" <?php if ($rejRea == "bos") { ?> selected="selected"<?php } ?>>bos</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution</strong> <br />
                                <select name="solution">
                                    <option value=""></option>
                                    <option value="dmp" <?php if ($Solution == "dmp") { ?> selected="selected"<?php } ?> >DMP</option>
                                    <option value="ppi" <?php if ($Solution == "ppi") { ?> selected="selected"<?php } ?> >PPI</option>
                                    <option value="lf" <?php if ($Solution == "lf") { ?> selected="selected"<?php } ?> >Loan Referral</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution Value</strong> <br />
                                <input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Value</strong> <br />
                                <input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

                                <br class="clearfix"/>

                                <strong>Added Cost</strong> <br />
                                <input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Date</strong> <br />  
                                <input type="text" name="fp_day"  <?php if ($fp_day != "") { ?> value="dd" <?php } else { ?> value="<?php echo $fp_day; ?>"  />
                                    <input type="text" name="fp_month" <?php if ($fp_month != "") { ?> value="mm" <?php } else { ?> value="<?php echo $fp_month; ?>" />
                                        <input type="text" name="fp_month" <?php if ($fp_year != "") { ?> value="yyyy" <?php } else { ?> value="<?php echo $fp_year; ?>" />

                                            <br class="clearfix"/>

                                            <h2>Debts </h2>

                                            <strong>Debt Amount </strong><br />
                                            <select name="debtAmount">
                                                <option value="">Not Set</option>
                                                <option value="1" <?php if ($debtAmount == "1") { ?> selected="selected"<?php } ?>>under &pound;2,000</option>
                                                <option value="2"<?php if ($debtAmount == "2") { ?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
                                                <option value="3" <?php if ($debtAmount == "3") { ?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
                                                <option value="4" <?php if ($debtAmount == "4") { ?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
                                                <option value="5" <?php if ($debtAmount == "5") { ?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
                                                <option value="6" <?php if ($debtAmount == "6") { ?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
                                                <option value="7" <?php if ($debtAmount == "7") { ?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
                                                <option value="8" <?php if ($debtAmount == "8") { ?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
                                                <option value="9" <?php if ($debtAmount == "9") { ?> selected="selected"<?php } ?>>&pound;100,000+</option>
                                            </select>

                                            <strong>Companies Owed </strong><br />
                                            <select name="companiesOwed">
                                                <option value="">Not Set</option>
                                                <?php
                                                $i = 00;
                                                while ($i <= 20) {
                                                    echo "<option  value=\" $i \"";
                                                    if ($i == $compOwed) {
                                                        echo "selected=\"selected\"";
                                                    } echo ">$i</option>";
                                                    $i++;
                                                }
                                                ?>

                                            </select>

                                            <strong>Partner Debt</strong><br />
                                            <select name="partnerDebt">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerDebt == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>yes</option>
                                                <option value="no" <?php if ($partnerDebt == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Work</strong><br />
                                            <select name="partnerWork">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerWork == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerWork == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Benefits</strong><br />
                                            <select name="partnerBenefits">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerBenefits == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerBenefits == "no") {
                                    echo "selected=\"selected\"";
                                } ?>>No</option> 
                                            </select>

                                            <input type="submit" value="Update">

                                                </form>


                                                </div>

                                                </body>
                                                </html>
HTML;
            } else {
                header("location:index.php");
            }
            ?>

Open in new window

Thanks marqusG but the php Still didn't work.

Ray, you are right there is no bnefit to copying the variables over I'm just gonna use the row array directly unless I'm going to explode them, this should clean up my code...


The error message is just Parse error and the line of code is the last line. In zend framework ide it says unexpected EOF.

Thanks for the book recommendation I will definitely buy that, although is it possible to point me to tutorial about generating the select option tags as you mention or possibly a quick example? Just because it's quite urgent and I woudn't be able to get the book by next week.

Thanks again for your help.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial