MySQL Improved Extension (
Mysqli
)
2483
mixed mysqli_fetch_array(
mysqli_result result,
int resulttype
= =MYSQLI_BOTH);
Returns an array that corresponds to the fetched row or
NULL
if there are no more rows for the
resultset represented by the
result
parameter.
mysqli_fetch_array
is an extended version of the
mysqli_fetch_row
function. In addition to
storing the data in the numeric indices of the result array, the
mysqli_fetch_array
function can also
store the data in associative indices, using the field names of the result set as keys.
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP
NULL
value.
If two or more columns of the result have the same field names, the last column will take precedence
and overwrite the earlier data. In order to access multiple columns with the same name, the numerically
indexed version of the row must be used.
Parameters
result
Procedural style only: A result set identifier returned
by
mysqli_query
,
mysqli_store_result
or
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
.
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 of strings that corresponds to the fetched row or
NULL
if there are no more rows in
resultset.
Examples
Example 20.186. Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...