The use of mysqli_num_rows() depends on whether you use buffered or unbuffered result sets. In case you use unbuffered resultsets mysqli_num_rows() will not correct the correct number of rows until all the rows in the result have been retrieved.

Return values

Returns number of rows in the result set.

Note: If the number of rows is greater than maximal int value, the number will be returned as a string.

Example

Example 1. Object oriented style


<?php

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");



/* check connection */

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);



    /* close result set */

    $result->close();

}



/* close connection */

$mysqli->close();

?>

Example 2. Procedural style


<?php

$link = mysqli_connect("localhost", "my_user", "my_password", "world");



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}



if ($result = mysqli_query($link, "SELECT Code, Name FROM Country ORDER BY Name")) {



    /* determine number of rows result set */

    $row_cnt = mysqli_num_rows($result);



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



    /* close result set */

    mysqli_free_result($result);

}



/* close connection */

mysqli_close($link);

?>

The above examples would produce the following output:

Result set has 239 rows.

mysqli_num_rows

Description

Return values

See Also

Example