Could you check whats wrong with my code? Cause it passes the validations but doesn't update my old password with a new one... i even try to echo values after successful UPDATE and at the end it returns me my old password instead of new one.
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Profilio redagavimas</title>
<link href="CSS/stilius.css" rel="stylesheet" type="text/css"/>
<link href="CSS/menu.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<?php require("includes/validate.php");?>
<?php require("includes/stilius.php");?>
<?php
echo "Jūsų vardas: ".$row["name"]."<br>";
echo "Jūsų miestas: ".$row["city"]."<br>";
echo "Jūsų telefono numeris: ".$row["phone"]."<br>";
if(strlen($row["web"]) > 0)
echo "Jūsų svetainės adresas: ".$row["web"]."<br>";
else
echo "Registracijos metu neįvedėte savo svetainės adreso."."<br>";
echo "pass";
?>
<form method='post' action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
<td>Old Password:</td>
<td><input name='oldpw' type='password' required='required'/></td>
<tr>
<td>New Password:</td>
<td><input name='newpw' type='password' required = 'required' /></td>
<tr>
<td>Confirm Password:</td>
<td><input name='conpw' type='password' required = 'required' /></td>
<td>
<input type='submit' value='Pakeisti slaptažodį' />
</td>
</tr>
</form>
<?php
if (isset($_POST['newpw'])){
$newpwd = mysql_real_escape_string(md5($_POST['newpw']));
if (md5($_POST['oldpw'])== $row['pass'])
{
if ($_POST['newpw']==$_POST['conpw'])
{
if(mysql_query("UPDATE vartotojai SET pass='$newpwd' WHERE 'V_ID' = '{$_SESSION['user_id']}'"))
{
echo $newpwd."<br>";
echo $_SESSION['user_id']."<br>";
echo "Slaptažodis sėkmingai pakeistas"."<br>";
echo $row['pass'];
}
else {echo "Klaida: " .mysql_error();}
}
else { echo "Slaptažodžiai nesutampa"; }
}
else { echo "Įvestas blogas senas slaptažodis";}
}
?>
<?php mysql_close(); ?>
<?php require("includes/footer.php");?>
</body>
</html>
EDIT: SOLVED Thanks to Shankar Damodaran.
