如何将SQL COUNT语句的结果存储在PHP变量中 [英] How can I store the result of an SQL COUNT statement in a PHP variable

问题描述

我想获取MySQL表中的行数并将其存储在php变量中.这是我正在使用的代码:

I want to get the number of rows in my MySQL table and store that number in a php variable. This is the code I'm using:

$size = @mysql_query("SELECT COUNT(*) FROM News");

$ size最终是资源ID#7".如何将行数直接放入$ size?

$size ends up being "Resource ID #7." How do I put the number of rows directly into $size?

推荐答案

mysql_query返回查询资源ID.为了从中获取值，您需要在资源ID上使用mysql_fetch_assoc，以将行读取到数组中.

mysql_query returns a query resource id. In order to get values from it you need to use mysql_fetch_assoc on the resource id to fetch a row into an array.

$result = mysql_query("SELECT COUNT(*) FROM News");
$row = mysql_fetch_assoc($result);
$size = $row['COUNT(*)'];

这篇关于如何将SQL COUNT语句的结果存储在PHP变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！