Example 1 — Count Rows From a Buffered Query
Default mysqli_query() stores the result, so num_rows works immediately.
<?php
$mysqli = mysqli_connect("localhost", "demo_user", "demo_pass", "app_db");
$result = mysqli_query($mysqli, "SELECT id, name FROM users LIMIT 5");
echo "Rows: ", mysqli_num_rows($result), PHP_EOL;
mysqli_free_result($result);
mysqli_close($mysqli); How It Works
- mysqli_query() uses MYSQLI_STORE_RESULT by default.
- mysqli_num_rows() reads the buffered row count.
- The sample SELECT returns five rows.
- Free the result when finished.

