sir.. patulong po sa code ko. ayaw po kc nya mg connect sa database eh. pa help po.. ang problema ko po dito sa password nya.. ayaw mag update. gumawa kasi ako ng change password kaso ayaw talaga mg update ang password nya.. okay naman lahat. successfull na cya pagkalagay ko sa old password at new password. talagang hindi lng cya umaupdate. pa help po.
session_start();
$username = $_SESSION['password'];
if ($username)
{
//user is logged in
if ($_POST['submit'])
{
//check fields
$password =($_POST['password']);
$newpassword =($_POST['newpassword']);
$repeatnewpassword =($_POST['repeatnewpassword']);
//check pass against db
$connect = mysql_connect("localhost","root","");
mysql_select_db('test1');
$queryget = mysql_query("SELECT password FROM members WHERE username='$username'") or die("Query didn't work");
$row = mysql_fetch_assoc($queryget);
$password = $row['password'];
//check pass
if ($password==$password)
{
//check twonew pass
if ($newpassword==$repeatnewpassword)
{
//success
//change pass in db
if (strlen($newpassword)>25||strlen($newpassword)<6)
{
echo "Password must be betwwen 6 & 25";
}
else
{
$querychange = mysql_query("UPDATE * FROM members WHERE username='$username' and password='$password'");
$result=mysql_query($querychange);
session_destroy();
die("Your pass has benn changed.<a href='home.php'>Return</a> to the main page");
}
}
else
die("New Pass don't match");
}
else
die("Old Pass doesn't match");
}
else
{
echo "
<form action='changepassword.php' method='POST'>
Old password: <input type='text' name='password'><p>
New password: <input type='password' name='newpassword'><p><br>
Repeat new password: <input type='password' name='repeatnewpassword'><p>
<input type='submit' name='submit' value='Change Password'>
</form>
";
}
}
else
die("You must be logged in to change your password");
