php - 计算总行数

Question

我确实希望用户能够看到他们上传了多少张图片。

此代码已到位:

$result = mysql_query("select count(1) from userid = '$userid' where FROM picture");
$row = mysql_fetch_array($result);

$total = $row[0];
echo "Total picture: " . $total;

但是什么也没显示。当我删除“userid”时，它会计算图片表中的所有行。

我尝试过但失败了。

错误:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in on line 14

Answer 1

您的 SQL 查询不正确，因此 $result 不是行集。这就是您在 mysql_fetch_array() 上收到错误的原因。假设*，如果您在执行该查询后立即检查 mysql_error()，这会告诉您发生的错误。

您的查询是:

select count(1) from userid = '$userid' where FROM picture

你应该有这样的东西:

SELECT count(1) AS picture_count FROM picture WHERE userid = '$userid'

然后您可以在 $row['picture_count'] 处获取总计。

*正如其他人所建议的，mysql_* 函数已被弃用。请参阅PHP manual .

This extension is deprecated as of PHP 5.5.0, and is not recommended for writing new code as it will be removed in the future. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API.

mySql Improved (mysqli_*)函数将是最容易实现的。