mysqli_result::fetch_all

mysqli_fetch_all

(PHP 5 >= 5.3.0, PHP 7)

mysqli_result::fetch_all -- mysqli_fetch_all — Fetches all result rows as an associative array, a numeric array, or both

说明

面向对象风格

mysqli_result::fetch_all ([ int $resulttype = MYSQLI_NUM ] ) : mixed

过程化风格

mysqli_fetch_all ( mysqli_result $result [, int $resulttype = MYSQLI_NUM ] ) : mixed

mysqli_fetch_all() fetches all result rows and returns the result set as an associative array, a numeric array, or both.

参数

result

仅以过程化样式：由 mysqli_query()，mysqli_store_result() 或 mysqli_use_result()返回的结果集标识。

resulttype

This optional parameter is a constant indicating what type of array should be produced from the current row data. The possible values for this parameter are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH.

返回值

Returns an array of associative or numeric arrays holding result rows.

仅 MySQL 原生驱动

仅可用于 mysqlnd。

As mysqli_fetch_all() returns all the rows as an array in a single step, it may consume more memory than some similar functions such as mysqli_fetch_array(), which only returns one row at a time from the result set. Further, if you need to iterate over the result set, you will need a looping construct that will further impact performance. For these reasons mysqli_fetch_all() should only be used in those situations where the fetched result set will be sent to another layer for processing.

参见

相关文章
php cubrid mysql 兼容性函数 fetch a result row as an associative array a numeric array or bothphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp frontbase 函数 fetch a result row as an associative array a numeric array or bothphp frontbase 函数 fetch a result row as an associative arrayphp maxdb 函数 fetch a result row as an associative a numeric array or bothphp maxdb 函数 fetch a result row as an associative arrayphp mssql 函数 fetch a result row as an associative array a numeric array or bothphp oci8 函数 returns the next row from a query as an associative or numeric arrayphp odbc 函数 fetch a result row as an associative arrayphp postgresql 函数 fetches all rows in a particular result column as an arrayphp sqlite 函数 fetches the current row from a result set as an arrayphp sqlite 函数 fetches all rows from a result set as an array of arraysphp sybase 函数 fetch a result row as an associative arrayphp mysql xdevapi rowresult get all rows from resultphp mysql xdevapi sqlstatementresult get all rows from resultphp mysqli result fetches all result rows as an associative array a numeric array or bothphp mysqli result fetch a result row as an associative a numeric array or bothphp mysqli result fetch a result row as an associative arrayphp mysqli stmt return the number of rows in statements result setphp sqlite3result fetches a result row as an associative or numerically indexed array or both
关注编程学问公众号