SELECT COUNT(*)AS计数-如何使用此计数 [英] SELECT COUNT(*) AS count - How to use this count

问题描述

代替:

$cars = $mysqli->query("SELECT * FROM cars");
$count = $cars->num_rows();
if ($count) {
  // is rows
}

我不想只选择所有行或一列，我只想计数.

I want to not have to select all rows or a single column, I simply want the count.

在我的脑海中

$cars = $mysqli->query("SELECT COUNT(*) as count FROM cars");

但是我该如何使用该计数值?我需要对其运行if语句.

But then how do I use that count value? I need to run an if statement on it.

推荐答案

不建议对SQL中的名称使用保留字.因此，我将计数结果称为cnt.由于您的函数是标量，也就是说，您只希望返回一个值，因此可以使用:

It's not recommended to use reserved words for names in SQL. So I call the count result cnt instead. As your function is scalar, i.e. you expect only one value back, you can use:

$count = $mysqli->query("select count(*) as cnt from cars")->fetch_object()->cnt; 

这篇关于SELECT COUNT(*)AS计数-如何使用此计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！