Question

php中用mysqlcount(*) 如何取返回值?

RT,лл

Answer 1

取值示例代码如下：

<?php 
//数据库连接
$conn=mysql_connect("localhost","root","root");
if(!$conn){
    
    die("对不起，数据库连接失败！ ").mysql_errno();
}
//选择数据库
mysql_select_db("testdb");
//sql语句
$sql="SELECT COUNT(*) AS count FROM user";
//执行sql
$query=mysql_query($sql,$conn);
//对结果进行判断
if(mysql_num_rows( $query)){
    
   $rs=mysql_fetch_array($query);
   
   //统计结果
   $count=$rs[0];
   
}else{
    
    $count=0;
}
 echo $count;
?>

Answer 2

select count(*) as a from yourtable where.....
然后再结果数组中用 a为键取值

Answer 3

$sql = "select count(*) as num from table";
$query = mysql_query($sql);
$row = mysql_fetch_array($query);
echo $row['num'];