php做的登录系统 帮忙

来源:百度知道 编辑:UC知道 时间:2024/06/28 17:43:15
<html>
<head>
<title>用户登入</title>

</head>
<body>

<?
$mysql_servername = "localhost"; //主机地址
$mysql_username = "root"; //数据库用户名
$mysql_password ="root"; //数据库密码
$mysql_database ="student"; //数据库
mysql_connect($mysql_servername , $mysql_username ,$mysql_password);
mysql_select_db($mysql_database);

$sname=$_POST['username'];
$sin=$_POST['userio'];

$sql = "SELECT * FROM info WHERE name = '$sname' and no='$sin'";
$res =mysql_query($sql);
$rows=@mysql_num_rows($res);
echo $rows;
if(!$rows){
echo "登录失败,错误的用户名或学号";
exit;
}
echo "<br>输入的姓名为:";
echo $sname;
echo "<br>输入的学号为:";
echo $sin;
?>
</body>
</html>

胡乱输入英文 显示Resource id #3登录失败,错误的用户

<?
$mysql_servername = "localhost"; //主机地址
$mysql_username = "root"; //数据库用户名
$mysql_password ="root"; //数据库密码
$mysql_database ="student"; //数据库
mysql_connect($mysql_servername , $mysql_username ,$mysql_password);
mysql_select_db($mysql_database);

$sname=$_POST['username'];
$sin=$_POST['userio'];

$sql = "SELECT * FROM info WHERE name = $sname and no=$sin";
$res =@mysql_query($sql);
$rs=@mysql_fetch_array($res);
if($rs==NULL){
die('登录失败,错误的用户名或学号')
}else{
echo "<br>输入的姓名为:";
echo $sname;
echo "<br>输入的学号为:";
echo $sin;
}

?>