問題描述
看遍了.找不到答案.PHP 文檔不清楚(對我來說).
Looked all over. Can't find an answer. PHP docs not clear (to me).
我正在通過 mysqli->query 做一個簡單的 MySQL 求和.如何使用 MySQLi 獲得結(jié)果，例如 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 的任何內(nèi)容都將返回一個 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
您仍然需要獲取帶有結(jié)果的行，并且 sum() 函數(shù)的值將是行數(shù)組中的唯一條目:
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];
這篇關(guān)于使用 MySQLi 的 SUM 的單個結(jié)果的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！