使用 MySQLi 的 SUM 的单个结果 [英] Single Result From SUM With MySQLi

问题描述

看遍了.找不到答案.PHP 文档不清楚(对我来说).

Looked all over. Can't find an answer. PHP docs not clear (to me).

我正在通过 mysqli->query 做一个简单的 MySQL 求和.如何使用 MySQLi 获得结果，例如 mysql_result?

I'm doing a simple MySQL sum through mysqli->query. How can I get the result with MySQLi like mysql_result?

推荐答案

在 SELECT 语句中给 mysqli_query 的任何内容都将返回一个 mysql_result 类型，如果查询成功.因此，如果您有一个 SELECT 语句，例如:

Whatever is given in the SELECT statement to mysqli_query is going to return a mysql_result type if the query was successful. So if you have a SELECT statement such as:

SELECT sum(field) FROM table1

您仍然需要获取带有结果的行，并且 sum() 函数的值将是行数组中的唯一条目:

you still need to fetch the row with the result, and the value of the sum() function will be the only entry in the row array:

$res = mysqli_query($dbh,'SELECT sum(field) FROM table1');
$row = mysqli_fetch_row($res);
$sum = $row[0];

这篇关于使用 MySQLi 的 SUM 的单个结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！