How can the use of mysqli_num_rows() improve the performance of PHP code compared to COUNT(id) in certain scenarios?

Using mysqli_num_rows() can improve the performance of PHP code compared to COUNT(id) in certain scenarios because it directly fetches the number of rows returned by a query without the need to retrieve the actual data. This can be more efficient when you only need the count of rows and not the actual data itself, as it reduces unnecessary data transfer and processing. 

// Connect to database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query to get number of rows
$query = "SELECT * FROM table_name WHERE condition";
$result = mysqli_query($connection, $query);

// Get the number of rows
$num_rows = mysqli_num_rows($result);

// Output the count
echo "Number of rows: " . $num_rows;

// Close connection
mysqli_close($connection);

Keywords

mysqli_num_rows COUNT performance PHP code scenarios

Related Questions