Page 1 of 1

Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:30 pm
by aquilina
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>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:36 pm
by social_experiment

Code: Select all

<?php
$user = mysql_query("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$usernamejob."'") or die(mysql_error());
// try this instead
$user = "UPDATE `employee_user` SET `password` = '" . $newpassword . "' WHERE `usernamejob` = '" . $usernamejob . "' ";
$sql = mysql_query($user) or die(mysql_error());
?>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:42 pm
by aquilina
i tried it already but its still remain the same things happen.. database didnt update..

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:45 pm
by social_experiment
What is displayed if you echo $user ?

Code: Select all

<?php
$user = mysql_query("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$usernamejob."'");
echo $user;
?>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:47 pm
by aquilina
here UPDATE `employee_user` SET `password`='mnbvcxz' WHERE `usernamejob`='Resource id #12'Your password has been change

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:54 pm
by social_experiment

Code: Select all

<?php
$user = mysql_query("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='". $_SESSION['usernamejob']."'");
?>
This will probably work, in the query you passed $usernamejob which is already assigned in this line

Code: Select all

<?php
$usernamejob = mysql_query("SELECT * FROM `employee_user` WHERE `usernamejob`='".$_SESSION['usernamejob']."'") or die(mysql_error());
?>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 1:58 pm
by aquilina
here my latest code and i already edit as what u said but still the same

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 = ("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$_SESSION['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>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 2:03 pm
by social_experiment

Code: Select all

<?php
$user = ("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$_SESSION['usernamejob']."'") or die(mysql_error());
// should be
$user = mysql_query("UPDATE `employee_user` SET `password`='".$newpassword."' WHERE `usernamejob`='".$_SESSION['usernamejob']."'") or die(mysql_error());
?>

Re: Database didnt upadate after making changes

Posted: Wed Dec 14, 2011 2:07 pm
by aquilina
gratz to u XD it solved.. and its only because of small mistake.. thankx