Hướng dẫn php fetcharray

mysqli_fetch_array

(PHP 5, PHP 7, PHP 8)

mysqli_result::fetch_array -- mysqli_fetch_array — Fetch the next row of a result set as an associative, a numeric array, or both

Description

Object-oriented style

public mysqli_result::fetch_array(int $mode = MYSQLI_BOTH): array|null|false

mysqli_fetch_array(mysqli_result $result, int $mode = MYSQLI_BOTH): array|null|false

In addition to storing the data in the numeric indices of the result array, this function can also store the data in associative indices by using the field names of the result set as keys.

If two or more columns of the result have the same name, the last column will take precedence and overwrite any previous data. To access multiple columns with the same name, the numerically indexed version of the row must be used.

Note: Field names returned by this function are case-sensitive.

Note: This function sets NULL fields to the PHP null value.

Parameters

Procedural style only: A mysqli_result object returned by mysqli_query(), mysqli_store_result(), mysqli_use_result() or mysqli_stmt_get_result().

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.

By using the MYSQLI_ASSOC constant this function will behave identically to the mysqli_fetch_assoc(), while MYSQLI_NUM will behave identically to the mysqli_fetch_row() function. The final option MYSQLI_BOTH will create a single array with the attributes of both.

Return Values

Returns an array representing the fetched row, null if there are no more rows in the result set, or false on failure.

Examples

Example #1 mysqli_result::fetch_array() example

Object-oriented style

<?php

mysqli_report

Procedural style

<?php

mysqli_report

The above examples will output something similar to:

Kabul (AFG)
Qandahar (AFG)
Herat (AFG)

See Also

• mysqli_fetch_assoc() - Fetch the next row of a result set as an associative array
• mysqli_fetch_column() - Fetch a single column from the next row of a result set
• mysqli_fetch_row() - Fetch the next row of a result set as an enumerated array
• mysqli_fetch_object() - Fetch the next row of a result set as an object
• mysqli_query() - Performs a query on the database
• mysqli_data_seek() - Adjusts the result pointer to an arbitrary row in the result