"; $con = mysql_connect("localhost","root",""); $search =$_POST["user"]; $pword=$_POST["pass"]; $ver=$_POST["verify"]; $verify=$_POST["verifypass"]; $flag=0; if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("tcems", $con); if ($ver=='' or $verify=='') { include("header.php"); echo "
Either New Password or Verify password is empty.
Go Back
"; } else { if($pword==$_POST["prevpass"]){ if ($ver==$verify) { $query="update tbl_admin set Username='$search', AdminPword='$ver' where Username='$_POST[prev]'"; $query2="update tblcurrentuser set Username='$search', Password='$ver' where Username='$_POST[prev]'"; mysql_query($query2); mysql_query($query); header ('Location: main.php'); } else { include("header.php"); echo "
Verification of new password not match.
Go Back
"; } } else{ echo "
PASSWORD DOES NOT MATCH.
Go Back
"; } } mysql_close($con); echo"