mysql_num_rows提示未定义,php – 调用未定义的函数MYSQL_NUM_ROWS()[复制]

标签：php

参见英文答案 > Deprecated: mysql_connect()                                    15个

我试图用PHP验证登录但是收到此错误：

Fatal error: Uncaught Error: Call to undefined function MYSQL_NUM_ROWS() in /opt/lampp/htdocs/social/index.php:100 Stack trace: #0 {main} thrown in /opt/lampp/htdocs/social/index.php on line 100

这是我的代码

if(isset($_POST['login'])){

$studentid = $_POST['studid'];

$pass = $_POST['password'];

$query2 = mysqli_query($con, "SELECT * FROM members WHERE student_id = '$studentid' AND password = '$pass' ") or die (mysqli_connect_error());

while($studid = mysqli_fetch_object($query2))

{

echo "$studid->member_id";

}

$numberOfRows = MYSQL_NUM_ROWS($query2);

if ($numberOfRows == 0)

{

}

else if ($numberOfRows > 0){

$wewness = mysql_query("SELECT * FROM members WHERE student_id = $studentid")or die(mysql_error());

$getid = mysql_fetch_array($wewness);

if($getid['account_status']==0){

$_SESSION['login'] = 'maybe';

$_SESSION['member_id'] = $getid['member_id'];

$_SESSION['studentid'] = $getid['student_id'];

header('location:registerexec.php');

}elseif($getid['account_status']==2){

$_SESSION['login'] = 'true';

$_SESSION['member_id'] = $getid['member_id'];

$_SESSION['studentid'] = $getid['student_id'];

header('location:hometest.php');

}elseif($getid['account_status']==1){

$_SESSION['login'] = 'maybe';

$_SESSION['member_id'] = $getid['member_id'];

$_SESSION['studentid'] = $getid['student_id'];

header('location:fill.php');

}

}

}

解决方法:

对于PHP 5以上的PHP版本,我们必须使用mysqli_ functions

mysqli_num_rows()

标签：php

来源： https://codeday.me/bug/20190716/1475166.html