Database didnt upadate after making changes
Posted: Wed Dec 14, 2011 1:30 pm
When i clicked modify, the password didnt changed in the database.. anyone know? Here my code
Code: Select all
<div id="main">
<div class="h3">Account Settings</div>
<div class="mainbox">
<?php
if(isset($_SESSION['usernamejob'])) {
if(!isset($_POST['modify'])){;
$query = mysql_query("SELECT * FROM `employee_user` WHERE `usernamejob`='".$_SESSION['usernamejob']."'") or die(mysql_error());
$row = mysql_fetch_array($query);
?>
<center>
<table cellspacing=1 cellpadding=5>
<tr><td class=listtitle colspan=2><center><span class='title2'></span></center></td></tr>
<?php
echo "
<form method=\"POST\">
<tr><td class=list align=left>Name</td><td class=list> ".$row['name']."<br></td></tr>
<tr><td class=list align=left>Current Password</td><td class=list> <input type=\"password\" name=\"password\" maxlength=\"12\"><br></td></tr>
<tr><td class=list align=left>New Password</td><td class=list> <input type=\"password\" name=\"newpassword\" maxlength=\"12\"><br></td></tr>
<tr><td class=list align=left>Repeat Password</td><td class=list> <input type=\"password\" name=\"repeatpassword\" maxlength=\"12\"><br></td></tr>
<tr><td class=listtitle align=left colspan=2><center><input type=\"submit\" name=\"modify\" value=\"Modify\"></form></td></tr></center>";
} else {
$connect = mysql_connect("localhost","root","") or die();
mysql_select_db("job_seeks") or die();
$usernamejob = mysql_query("SELECT * FROM `employee_user` WHERE `usernamejob`='".$_SESSION['usernamejob']."'") or die(mysql_error());
$user = mysql_fetch_array($usernamejob);
$password = mysql_real_escape_string($_POST['password']);
$newpassword = mysql_real_escape_string($_POST['newpassword']);
$repeatpassword = mysql_real_escape_string($_POST['repeatpassword']);
$passworddb = $user['password'];
if ($password==$passworddb)
{
if ($newpassword==$repeatpassword)
{
$user = mysql_query("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$usernamejob."'") or die(mysql_error());
session_destroy();
echo "Your password has been change";
}
else
echo "New passwords dont match";
}
else
{
echo "old password doesnt match";
}
}
}
echo "</td></tr></table>";
?>
</div>
</div>