PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
aquilina
Forum Commoner
Posts: 30 Joined: Wed Sep 21, 2011 1:23 am
Post
by aquilina » 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>
social_experiment
DevNet Master
Posts: 2793 Joined: Sun Feb 15, 2009 11:08 am
Location: .za
Post
by social_experiment » Wed Dec 14, 2011 1:36 pm
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());
?>
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
aquilina
Forum Commoner
Posts: 30 Joined: Wed Sep 21, 2011 1:23 am
Post
by aquilina » Wed Dec 14, 2011 1:42 pm
i tried it already but its still remain the same things happen.. database didnt update..
social_experiment
DevNet Master
Posts: 2793 Joined: Sun Feb 15, 2009 11:08 am
Location: .za
Post
by social_experiment » Wed Dec 14, 2011 1:45 pm
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;
?>
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
aquilina
Forum Commoner
Posts: 30 Joined: Wed Sep 21, 2011 1:23 am
Post
by aquilina » Wed Dec 14, 2011 1:47 pm
here UPDATE `employee_user` SET `password`='mnbvcxz' WHERE `usernamejob`='Resource id #12'Your password has been change
social_experiment
DevNet Master
Posts: 2793 Joined: Sun Feb 15, 2009 11:08 am
Location: .za
Post
by social_experiment » Wed Dec 14, 2011 1:54 pm
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());
?>
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
aquilina
Forum Commoner
Posts: 30 Joined: Wed Sep 21, 2011 1:23 am
Post
by aquilina » Wed Dec 14, 2011 1:58 pm
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>
social_experiment
DevNet Master
Posts: 2793 Joined: Sun Feb 15, 2009 11:08 am
Location: .za
Post
by social_experiment » Wed Dec 14, 2011 2:03 pm
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());
?>
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
aquilina
Forum Commoner
Posts: 30 Joined: Wed Sep 21, 2011 1:23 am
Post
by aquilina » Wed Dec 14, 2011 2:07 pm
gratz to u XD it solved.. and its only because of small mistake.. thankx