Home> Topics> php mysql> body text

How to query the number of records in php mysql

藏色散人
Release: 2020-10-10 10:02:58
Original
5317 people have browsed it

php Mysql method of querying the number of records: 1. Count directly when querying, with statements such as "$count=$result['count'];"; 2. Take out first, then count, with statements such as "$ count=mysql_num_rows($result);”.

How to query the number of records in php mysql

Recommended tutorial: "php mysql"

PHP queries the number of records that meet the conditions in the database (Two implementation methods)

When you need to output the number of website user registrations or determine whether there are duplicate records before inserting data, you need to obtain the number of records that meet the conditions of the MySQL query. The following two methods are introduced Query statistical methods.

The first method: direct statistics when querying

The code is as follows:

$sql="SELECT COUNT(*) AS count FROM TABLE WHERE id='$id'"; $result=mysql_fetch_array(mysql_query($sql)); $count=$result['count'];
Copy after login

The second method: take out first, then count

The code is as follows:

$sql="SELECT * FROM TABLE WHERE id='$id'"; $result=mysql_fetch_array(mysql_query($sql)); $count=count($result);//或者$count=mysql_num_rows($result);
Copy after login

However, when using MySQL's COUNT(*) directly, the efficiency advantage is very significant when the amount of data is huge. Because the latter requires secondary calculation, it is better to use the former to count data items. registration.

The above is the detailed content of How to query the number of records in php mysql. 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
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!