使用crypt函数进行数据验证
$conn = mysql_connect("localhost","root","root") or die("数据库链接错误".mysql_error());
mysql_select_db("db_database21",$conn) or die("数据库访问错误".mysql_error());
mysql_query("set names gb2312");
?>
if(trim($_POST[username])!= "" and trim($_POST[password])!= ""){ $usr = crypt(trim($_POST[username]),$_POST[username]); $pwd = crypt(trim($_POST[password]),$_POST[password]); $sql = "select * from tb_user where username = '".$usr."' and password='".$pwd."'"; $rst = mysql_query($sql,$conn); $result=mysql_num_rows($rst); if($result>0){ echo "用户登录成功。"; }else{ echo "用户登录失败!"; } }else{ echo "请认真填写用户名和密码!"; } ?> | |||||||||||