When a user initially wants to submit their information, I "SELECT * FROM members" which is the table that stores all user information entered when a user registeres for the site. I then pre-populate the input fields with that data. When the user clicks submit, it stores all of that data into a different table called "current".
Additionally, I store their unique ID in the current table as "memnum."
The problem I am having is now I need to let the users be able to edit their information once submitted. They can't submit twice because I do not want duplicate entries.
What I have done is entered the following onto the page:
Code: Select all
if ($_POST['action'] == 'updatecurrent')
{
$name = $_POST['name'];
$email = $_POST['email'];
$city = $_POST['city'];
$state = $_POST['state'];
$phone = $_POST['phone'];
$cell = $_POST['cell'];
$website = $_POST['website'];
$memnum = $_POST['memnum'];
$query = "UPDATE current SET name = '$name', email = $email', city = '$city', state = '$state', phone = '$phone', cell = '$cell', website = '$website' WHERE id = '$id', memnum = '$memnum'";
$result = mysql_query($query);
$errormsg = "<font color ='#FF0000'>Updated!</font>";
$p = 6; //List View
}
else
{
$errormsg = "<font color ='#FF0000'>Oops.. something went wrong!</font>";
$p = 6;
}Here is the code from the include file which (in theory) should prepopulate that users information, but I know I am wrong somewhere.
Code: Select all
<?PHP
include_once("db.inc.php");
mysql_connect($db_host,$db_user,$db_pass) or DIE("Could not connect to DB Server");
mysql_select_db("$db_name") or DIE("Could not find DB on Server");
$query = "SELECT * FROM current WHERE id = '$memnum'";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0)
{
$row = mysql_fetch_array($result);
extract($row);
}
?>
<title>Update Member Information</title><table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td valign="top" align="center"><form name="editcurrent" method="post" action="<?PHP echo "$PHP_SELF"; ?>">
<table width="100%" border="0" cellspacing="2" cellpadding="3">
<tr>
<td colspan="2"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="3">Edit
Your Current Member Directory Info:
<?PHP echo $errormsg; ?>
</font></b></td>
</tr>
<tr>
<td colspan="2">If all of the information is correct, please click
submit. You will need to enter the year you began at IV and the
year you ended.</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="3" bgcolor="#CCCCCC">
<tr bgcolor="e7e7e7">
<td width="30%"><b>Username:</b></td>
<td width="70%">
<?PHP echo "$memnum"; ?>
</td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>Name:</b></td>
<td width="70%">
<input name="name" type="text" id="name" value="<?PHP echo "$name"; ?>">
</td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>Email:</b></td>
<td width="70%">
<input name="email" type="text" id="email" value="<?PHP echo "$email"; ?>">
</td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>City/State/Zip</b></td>
<td width="70%">
<input name="city" type="text" id="city" value="<?PHP echo "$city"; ?>">
<input name="state" type="text" id="state" value="<?PHP echo "$state"; ?>" size="2" maxlength="2">
<input name="zip" type="text" id="zip" value="<?PHP echo "$zip"; ?>" size="5" maxlength="5">
</td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>Phone:</b></td>
<td width="70%">
<input name="phone" type="text" id="phone" value="<?PHP echo "$phone"; ?>">
EX: (802) 123-4567</td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>Cell:</b></td>
<td width="70%">
<input name="cell" type="text" id="cell" value="<?PHP echo "$cell"; ?>">
EX: (802) 123-4567 </td>
</tr>
<tr bgcolor="e7e7e7">
<td width="30%"><b>Website:</b></td>
<td width="70%"> http://
<input name="website" type="text" id="website" value="<?PHP echo "$website"; ?>">
EX: http://www.burlingtonivcf.org</td>
</tr>
<tr>
<td height="15" colspan="2" align="center" bgcolor="#4A6588">
<input name="action" type="hidden" value="updatecurrent">
<input name="id" type="hidden" value="<?PHP echo "$id"; ?>">
<input name="memnum" type="hidden" id="memnum" value="<?PHP echo "$memnum"; ?>">
<input name="Submit" type="submit" id="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>