mysqli_result::fetch_all
mysqli_fetch_all
(PHP 5 >= 5.3.0, PHP 7)
mysqli_result::fetch_all -- mysqli_fetch_all — Fetch all result rows as an associative array, a numeric array, or both
说明
面向对象风格
$mode
= MYSQLI_NUM
) : array过程化风格
Returns a two-dimensional array of all result rows as an associative array, a numeric array, or both.
参数
-
result
-
仅以过程化样式:由 mysqli_query()、mysqli_store_result()、 mysqli_use_result()、mysqli_stmt_get_result() 返回的结果集标识。
-
mode
-
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
, orMYSQLI_BOTH
.
返回值
Returns an array of associative or numeric arrays holding result rows.
仅 MySQL 原生驱动
仅可用于 mysqlnd。
范例
示例 #1 mysqli_result::fetch_all() example
面向对象风格
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$result = $mysqli->query("SELECT Name, CountryCode FROM City ORDER BY ID LIMIT 3");
$rows = $result->fetch_all(MYSQLI_ASSOC);
foreach ($rows as $row) {
printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
}
过程化风格
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
$result = mysqli_query($mysqli, "SELECT Name, CountryCode FROM City ORDER BY ID LIMIT 3");
$rows = mysqli_fetch_all($result, MYSQLI_ASSOC);
foreach ($rows as $row) {
printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
}
以上例程会输出:
Kabul (AFG) Qandahar (AFG) Herat (AFG)
参见
- mysqli_fetch_array() - Fetch a result row as an associative, a numeric array, or both
- mysqli_query() - 对数据库执行一次查询