调用未定义函数mysqli_result()[duplicate]

Question

我对mysql_result()->有问题（例如mysql_result)

我的代码：

$per_page = 6;
$pages_query = mysqli_query($conn, 'SELECT COUNT(id) FROM users');  
$pages = ceil(mysqli_result($pages_query, 0) / $per_page);

浏览器错误：

错误：在第11行调用/applications/mamp/htdocs/bootstrap/pagination.php中未定义的函数mysqli_result()

Answer 1

与mysql_result()相反，mysqli中没有mysqli_result()函数。

使用mysqli_fetch_array()函数获取行总数。您的代码应该是这样的：

$per_page = 6;
$pages_query = mysqli_query($conn, 'SELECT COUNT(id) FROM users'); 
$row = mysqli_fetch_array($pages_query);
$pages = ceil($row[0] / $per_page);