How to query the number of records returned in php

Method: 1. Use the mysql_num_rows function with the syntax "mysql_num_rows (result set)"; 2. Use the mysql_query function to execute the "COUNT(*)" query, and then use the mysql_fetch_row function to retrieve the numeric array from the result set.

The operating environment of this tutorial: windows7 system, PHP7.1 version, DELL G3 computer

PHP query statement, there are two ways to obtain the query the total number of records.

MySQLi process-oriented approach

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = mysqli_query($conn, $sql);
 
num_rows=mysqli_num_rows($result);

The first is to use the mysql_num_rows function, example code:

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);
 
$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
?>

The second is to modify the query statement, using COUNT(*) as the query content, example Code:

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);
 
$result = mysql_query("SELECT COUNT(*) FROM table1", $link);
list($num_rows) = mysql_fetch_row($result);
echo "$num_rows Rows\n";
?>

Recommended: "2021 PHP interview questions summary (collection)" "php video Tutorial》

The above is the detailed content of How to query the number of records returned in php. For more information, please follow other related articles on the PHP Chinese website!