写的一段登录系统的处理代码,但是从页面登录转到login.php也就是下面的代码页之后完全空白,没有任何结果,是为什么?求教。
报过一次错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
其他几次都没有任何结果。<?php
session_start();
include('include/dbconnect.php');
$admin=$_POST['admin'];
$password = $_POST['password'];
if($admin!=='' && $password!==''){
$sql = "SELECT * FROM `operator` WHERE opname='$admin' and password='$password'";
$info=mysql_query($sql);
$rs=mysql_fetch_array($info);
if($rs){
?>
<script language="javascript">
alert("恭喜您,登录成功!");window.location.href="mian_index.php";
</script>
<?php
$_SESSION['admin']=$admin;
$_SESSION['level']=1;
}
else{
?>
<script language="javascript">
alert("对不起,您输入的用户名或密码错误!");window.location.href="welcome.html";
</script>
<?php
}
}
?>
报过一次错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource
其他几次都没有任何结果。<?php
session_start();
include('include/dbconnect.php');
$admin=$_POST['admin'];
$password = $_POST['password'];
if($admin!=='' && $password!==''){
$sql = "SELECT * FROM `operator` WHERE opname='$admin' and password='$password'";
$info=mysql_query($sql);
$rs=mysql_fetch_array($info);
if($rs){
?>
<script language="javascript">
alert("恭喜您,登录成功!");window.location.href="mian_index.php";
</script>
<?php
$_SESSION['admin']=$admin;
$_SESSION['level']=1;
}
else{
?>
<script language="javascript">
alert("对不起,您输入的用户名或密码错误!");window.location.href="welcome.html";
</script>
<?php
}
}
?>
session_start();
include('include/dbconnect.php');
$admin=$_POST['admin'];
$password = $_POST['password'];
if($admin!=='' && $password!==''){
$sql = "SELECT * FROM `operator` WHERE opname='$admin' and password='$password'";
$info=mysql_query($sql);
$rs=mysql_fetch_row($info); //这里取一行就行了
if($rs){
$_SESSION['admin']=$admin;
$_SESSION['level']=1; //先记录 session 再跳转
?>
<script language="javascript">
alert("恭喜您,登录成功!");window.location.href="mian_index.php";
</script>
<?php
}
else{
?>
<script language="javascript">
alert("对不起,您输入的用户名或密码错误!");window.location.href="welcome.html";
</script>
<?php
}
}
?>
$con = mysql_connect('localhost','root','admin');
if(!$con){
echo "数据库连接出错!".mysql_errno().":".mysql_error();
exit;
} else {
mysql_select_db('ktv',$con) or die ("选择数据库出错".mysql_error());
mysql_query("set names utf8");
}
?> 上面是dbconnect的代码 这个没问题的。我测试过呢