php mysqli_num_rows()函数

定义

mysqli_num_rows()函数返回结果集中的行数。

语法

PHP mysqli_num_rows()函数具有以下语法。

面向对象的风格：

int $mysqli_result->num_rows;

程序风格：

int mysqli_num_rows ( mysqli_result $result )

参数

返回

返回结果集中的行数。

如果行数大于MAXINT，则该数字将作为字符串返回。

实例

以下代码返回结果集中的行数。

<?php
//  http://www.manongjc.com/article/1686.html
//  作者：码农教程
$con=mysqli_connect(\"localhost\",\"my_user\",\"my_password\",\"my_db\");
if (mysqli_connect_errno($con)){
  echo \"Failed to connect to MySQL: \" . mysqli_connect_error();
}

$sql=\"SELECT Lastname FROM Persons\";

if ($result=mysqli_query($con,$sql)){
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf(\"Result set has %d rows.\\n\",$rowcount);

  mysqli_free_result($result);
}

mysqli_close($con);
?>

实例2

<?php
//  http://www.manongjc.com/article/1686.html
//  作者：码农教程
$mysqli = new mysqli(\"localhost\", \"my_user\", \"my_password\", \"world\");

if (mysqli_connect_errno()) {
    printf(\"Connect failed: %s\\n\", mysqli_connect_error());
    exit();
}

if ($result = $mysqli->query(\"SELECT Code, Name FROM Country ORDER BY Name\")) {

    /* determine number of rows result set */
    $row_cnt = $result->num_rows;

    printf(\"Result set has %d rows.\\n\", $row_cnt);

    $result->close();
}

$mysqli->close();
?>