Home > Backend Development > PHP Problem > How to query the number of records returned in php

How to query the number of records returned in php

醉折花枝作酒筹
Release: 2023-03-10 08:14:01
Original
2226 people have browsed it

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.

How to query the number of records returned in php

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);
Copy after login

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";
?>
Copy after login

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";
?>
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template