<?php
$link=new mysqli("localhost","root","123456","test");
$link->query("set names gb2312",MYSQLI_USE_RESULT);
if($_POST["submit"]<>""){
$result=$link->query("call user_login('".$_POST[username]."','".$_POST[pwd]."')");
$info=$result->fetch_array(MYSQLI_ASSOC);
if($info!=NULL){
echo "<script>alert('恭喜您,登录成功!');</script>";
}
else{
echo "<script>alert('对不起,您输入的用户名或密码错误,请您重新输入!');</script>";
}
}
?>提示错误信息是:
Fatal error: Call to a member function fetch_array() on a non-object in E:\web\php\test7.php on line 72
$link=new mysqli("localhost","root","123456","test");
$link->query("set names gb2312",MYSQLI_USE_RESULT);
if($_POST["submit"]<>""){
$result=$link->query("call user_login('".$_POST[username]."','".$_POST[pwd]."')");
$info=$result->fetch_array(MYSQLI_ASSOC);
if($info!=NULL){
echo "<script>alert('恭喜您,登录成功!');</script>";
}
else{
echo "<script>alert('对不起,您输入的用户名或密码错误,请您重新输入!');</script>";
}
}
?>提示错误信息是:
Fatal error: Call to a member function fetch_array() on a non-object in E:\web\php\test7.php on line 72
$link=new mysqli("localhost","root","123456","test");
$link->query("set names gb2312",MYSQLI_USE_RESULT);
if($_POST["submit"] <>""){
$result=$link->query("call user_login('".$_POST[username]."','".$_POST[pwd]."')");
if($result!=null){
$info=$result->fetch_array(MYSQLI_ASSOC);
}
if($info!=NULL){
echo " <script>alert('恭喜您,登录成功!'); </script>";
}
else{
echo " <script>alert('对不起,您输入的用户名或密码错误,请您重新输入!'); </script>";
}
}
?>