mysqli_num_rows

Gets the number of rows in a result (PHP 5)
int mysqli_num_rows ( mysqli_result result )

Example 1531. 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 1532. Procedural style

copy to clipboard

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

Code Examples / Notes » mysqli_num_rows

this is stated in the main mysqli section under constants, but isn't stated here: to get a get a buffered result set, use MYSQLI_STORE_RESULT in your query or call mysqli_store_result() when fetching the result set from a prepared query. this allows you to get the right rowcount every time, since your result set is going to be atomic. don't forget that whether or not you really want to buffer the result set is a different question altogether.

mysqli_num_rows

Gets the number of rows in a result (PHP 5) int mysqli_num_rows ( mysqli_result result )

Example 1531. Object oriented style

Example 1532. Procedural style

Code Examples / Notes » mysqli_num_rows

Change Language

Gets the number of rows in a result (PHP 5)
int mysqli_num_rows ( mysqli_result result )