I have my query page set up so that it displays each record along with a link to an update page and a link to a delete page. The problem occurs when I click the "Update client info" link: the updateclient.php page ends up with nothing on it. The surrounding HTML is all there, but there should be a form included with the fields' values filled in from the variables.
This is the PHP from the query page:
<?php
@ $db = mysql_pconnect('hostname', 'username', 'password');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('databasename);
$query = "select * from tablename ORDER BY fullname ASC";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo '<p>Number of clients found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$myrow = mysql_fetch_array($result);
$id = $myrow['id'];
echo '<table border="0" cellpadding="2" cellspacing="2"><tr><td><strong>'.($i+1).'. ';
echo htmlspecialchars(stripslashes($myrow['fullname']));
echo '</strong><br />';
echo stripslashes($myrow['address']);
echo '<br />';
echo stripslashes($myrow['city']);
echo ', ';
echo stripslashes($myrow['state']);
echo ' ';
echo stripslashes($myrow['zip']);
echo '</td></tr><tr><td>Phone: ';
echo stripslashes($myrow['phone']);
echo ' ';
echo stripslashes($myrow['extension']);
echo '<br />Fax: ';
echo stripslashes($myrow['fax']);
echo '<br />Email: ';
echo stripslashes($myrow['email']);
echo '</td></tr><tr><td>Service of interest: ';
echo stripslashes($myrow['service']);
echo '<br />Peer Review: ';
echo stripslashes($myrow['review']);
echo '<br />Peer Review Due Date: ';
echo stripslashes($myrow['reviewduemonth']);
echo ' ';
echo stripslashes($myrow['reviewdueday']);
echo ', ';
echo stripslashes($myrow['reviewdueyear']);
echo '<br />
<a href="updateclient.php?id=$id">Update client info</a><br />
<a href="deleteclient.php?id=$id">Delete client from database</a>';
echo '</td></tr></table><br />';
}
?>
This is the PHP from the updateclient.php page:
<?php
$id = $_POST['id'];
@ $db = mysql_pconnect('hostname', 'username', 'password');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db(databasename');
$query = "select * from tablename WHERE id='$id'";
$result = mysql_query($query);
mysql_close();
while(list($id,$fullname,$address,$city,$state,$zip,$phone,$extension,$fax,$email,$service,$review,$reviewduemonth,$reviewdueday,$reviewdueyear) = mysql_fetch_row($result)) {
?>
<form action="updatedclient.php" method="post">
<input type="hidden" name="ud_id"
value="<? echo $id; ?>">
Name:
<input type="text" name="ud_fullname"
value="<? echo $fullname; ?>"><br />
Address:
<input type="text" name="ud_address"
value="<? echo $address; ?>"><br />
City:
<input type="text" name="ud_city"
value="<? echo $city; ?>">,
State:
<input type="text" name="ud_state"
value="<? echo $state; ?>">
Zip:
<input type="text" name="ud_zip"
value="<? echo $zip; ?>"><br />
Phone:
<input type="text" name="ud_phone"
value="<? echo $phone; ?>">
Ext:
<input type="text" name="ud_extension"
value="<? echo $extension; ?>"><br />
Fax:
<input type="text" name="ud_fax"
value="<? echo $fax; ?>"><br />
Email:
<input type="text" name="ud_email"
value="<? echo $email; ?>"><br />
Service:
<input type="text" name="ud_service"
value="<? echo $service; ?>"><br />
Review:
<input type="text" name="ud_review"
value="<? echo $review; ?>">
Date:
<input type="text" name="ud_reviewduemonth"
value="<? echo $reviewduemonth; ?>">
<input type="text" name="ud_reviewdueday"
value="<? echo $reviewdueday; ?>">,
<input type="text" name="ud_reviewdueyear"
value="<? echo $reviewdueyear; ?>"><br />
<input type="Submit" value="Update">
</form>
<?php
}
?>
Any help you could provide would be much appreciated! Thanks!
