即时通讯新的PHP和学习相当快。我有一个表格,允许用户更新他/她的安全问题,并且还要求用户输入他/她的参考号码以便继续进行更改。PHP查看密码是否匹配,如果是的话,提交其数据
我对表单代码如下:
Secret Question | Please Select Your Secret Question What Is Your Mothers Maiden Name What Was The Name Of Your First Pet What Was Your First Car What Is Your Favourite Colour * |
Your Anwser | * |
Your Reference | * |
我的PHP脚本如下:
$secret_question = mysql_real_escape_string($_REQUEST['secret_question']);
$secret_anwser = mysql_real_escape_string($_REQUEST['secret_anwser']);
$sql= "UPDATE public SET secret_question = '$secret_question', secret_anwser = '$secret_anwser' WHERE active = 'activated' AND ni = '". $_SESSION['ni']."'";
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
else
{
echo '
Security Question Has Been Updated
';
}
?>
什么我不知道是如何代码,以便它可以检查用户输入的ref与我的数据库中的ref域相匹配,如果是这样,那么它应该继续进行更新,如果不是,它应该要求用户再次输入他的密码?