mysqli_query-返回值 [英] mysqli_query - return values
问题描述
我正在使用PHP函数mysqli_query
来运行SELECT
查询.
I am using the PHP function mysqli_query
to run a SELECT
query.
如果查询成功运行,但没有找到匹配项,mysqli_query
返回什么?
What does mysqli_query
return if the query runs successfully, but the query finds no matches?
推荐答案
每个手册:
失败时返回FALSE.对于成功的SELECT,SHOW,DESCRIBE或EXPLAIN查询,mysqli_query()将返回mysqli_result对象.对于其他成功的查询,mysqli_query()将返回TRUE.
Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.
运行但不返回任何结果的查询仍被视为成功查询",因为该查询确实已在数据库中运行,并且空结果集是合法的响应.这意味着查询仍将返回mysqli_result
对象,并且如果您检查其行计数(通过面向对象样式的$result->num_rows
或过程样式的mysqli_num_rows($result)
),它将返回0.
A query that runs but returns no results is still considered a "successful query", since the query did run in the database and an empty result set is a legitimate response. This means the query will still return a mysqli_result
object, and if you check its row count (either via $result->num_rows
in the object-oriented style or mysqli_num_rows($result)
in the procedural style) it will return 0.
这篇关于mysqli_query-返回值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!