来自SQL查询的PHP echo总行数

Question

我不确定我在哪里做错了。我在这里搜索过类似的问题，但没有运气。任何帮助都将不胜感激。谢谢!

$check = "SELECT Number FROM advisors";
$result = mysqli_query($check);
$count = mysqi_num_rows($result);

echo $count;

Answer 1

您应该像这样使用php prepare语句

$count  = 0;
$mysqli = new mysqli(host, dbUser, dbPassword, dbName);
mysqli_set_charset($mysqli, "utf8");
$sql    = "select count(*)  from advisors";
if ($stmt   = mysqli_prepare($mysqli, $sql))
{
    mysqli_stmt_execute($stmt);
    mysqli_stmt_store_result($stmt);
    mysqli_stmt_bind_result($stmt, $c);
    if (mysqli_stmt_fetch($stmt))
    {
        $count = $c;
    }
    mysqli_stmt_close($stmt);
}
return $count;

欲了解更多信息，这里是php prepare语句Documentation of php prepare statement的链接

Answer 2

您应该在查询中使用COUNT，看看它是否有效，"SELECT COUNT ( number ) as number FROM advisors"；顺便说一下，我注意到$count中有一个拼写错误，应该是$count = mysqli_num_count($result)。