I have a member system I've created and am trying to update a user's profile. I have two forms that displays their info. The first one, commented out, works when the user clicks update profile. When I try using the second form and a user clicks update nothing happens. I'm trying to delete the first form and use the second one since the <label> tags are used for CSS styling. However, this second form is not working with updating the user's info to the database. I checked to make sure there are no syntax errors and spelling mistakes.
<?
session_start();
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());
if($_SESSION['logged-in'] == true)
{
$username = $_SESSION['username'];
echo "Welcome " . $username . "<br />";
if($_POST["username"]==""){
$query = mysql_query("SELECT * FROM login WHERE username='$username' LIMIT 1");
if(mysql_error())
{
print(mysql_error());
}
else
{
while($row = mysql_fetch_array($query))
{
/* echo "<form id='form1' name='form1' method='post' action='". $PHP_SELF . "?id=editprofile'>
<b>User: </b><input type='text' name='username' id='username' value='$row[username]' ><br />
<b>First Name: </b><input type='text' name='firstname' id='username' value='$row[firstname]' ><br />
<b>Last Name: </b><input type='text' name='lastname' id='username' value='$row[lastname]' ><br />
<b>Email: </b><input type='text' name='email' id='username' value='$row[email]' ><br />
<b>AIM: </b><input type='text' name='aim' id='username' value='$row[aim]' ><br />
<b>MSN: </b><input type='text' name='msn' id='username' value='$row[msn]' ><br />
<b>Website: </b><input type='text' name='website' id='username' value='$row[website]' ><br />
<input name='update' type='submit' id='update' value='Update Profile' />
<input type='reset' name='Submit2' value='Reset'/>
</form>";*/
echo"
<form id='form1' name='form1' method='post' action='". $PHP_SELF . "'>
<p>
<label for='email'>Email:</label>
<input type='text' name='email' id='username' value='$row[email]' />
</p>
<p>
<label for='firstname'>First Name:</label>
<input type='text' name='firstname' id='username' value='$row[firstname]' />
</p>
<p>
<label for='lastname'>Last Name:</label>
<input type='text' name='lastname' id='username' value='$row[lastname]' />
</p>
<p>
<label for='aim'>AIM:</label>
<input type='text' name='aim' id='username' value='$row[aim]' />
</p>
<p>
<label for='msn'>MSN:</label>
<input type='text' name='msn' id='username' value='$row[msn]' />
</p>
<p>
<label for='website'>Website:</label>
<input type='text' name='website' id='username' value='$row[website]' />
</p>
<p>
<label for='update'></label>
<input name='update' type='submit' id='update' value='Update Profile' />
</p>
</form>";
}
}
}
else
{
$sql = "UPDATE login SET email='" . $_POST["email"] . "', firstname='" . $_POST["firstname"] . "', lastname='" . $_POST["lastname"] . "', aim='" .$_POST["aim"] . "', msn='" .$_POST["msn"] . "', website='" . $_POST["website"] . "' WHERE username='" . $username . "'";
$result = mysql_query($sql) or die(mysql_error());
if($result)
{
echo "<p align='center'><b>Your profile has been updated, " . $username . ".</b></p>";
}
}
}
else {
?>
<p>You must login to see this page.</p>
<form id="form1" name="form1" method="post" action="<? $_SERVER[PHP_SELF];?>">
Username:<br />
<input name="username" type="text" id="username" />
<br />
Password:<br />
<input name="password" type="password" id="password" /><br />
<input name="login" type="submit" id="login" value="Login" />
<input type="reset" name="Submit2" value="Reset" />
</form>
<?
}
?>
