计算特定记录的MySQL

Question

我想显示在PHP MySQL中状态为1（参见代码）的用户数。

<?php

// something like this

$result = mysqli_query($mysqli, "SELECT COUNT(*) FROM users WHERE status = '1'");

echo "$result";

?>

Answer 1

尝试这个：$query = "SELECT COUNT(*) as countvar FROM users where status = '1'";$result = mysqli_query($con,$query);$row = mysqli_fetch_array($result);$count= $row['countvar '];