mysqli_result::fetch_assoc

mysqli_fetch_assoc

(PHP 5)

mysqli_result::fetch_assoc -- mysqli_fetch_assocFetch a result row as an associative array

Description

Object oriented style

array mysqli_result::fetch_assoc ( void )

Procedural style

array mysqli_fetch_assoc ( mysqli_result $result )

Returns an associative array that corresponds to the fetched row or NULL if there are no more rows.

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

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

Parameters

result

Procedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().

Return Values

Returns an associative array of strings representing the fetched row in the result set, where each key in the array represents the name of one of the result set's columns or NULL if there are no more rows in resultset.

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you either need to access the result with numeric indices by using mysqli_fetch_row() or add alias names.

Examples

Example #1 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 DESC LIMIT 50,5";

if (
$result $mysqli->query($query)) {

    
/* fetch associative array */
    
while ($row $result->fetch_assoc()) {
        
printf ("%s (%s)\n"$row["Name"], $row["CountryCode"]);
    }

    
/* free result set */
    
$result->free();
}

/* close connection */
$mysqli->close();
?>

Example #2 Procedural style

<?php
$link 
mysqli_connect("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 DESC LIMIT 50,5";

if (
$result mysqli_query($link$query)) {

    
/* fetch associative array */
    
while ($row mysqli_fetch_assoc($result)) {
        
printf ("%s (%s)\n"$row["Name"], $row["CountryCode"]);
    }

    
/* free result set */
    
mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

The above examples will output:

Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)

Example #3 A mysqli_result example comparing iterator usage

<?php
$c 
mysqli_connect('127.0.0.1','user''pass');

// Using iterators (support was added with PHP 5.4)
foreach ( $c->query('SELECT user,host FROM mysql.user') as $row ) {
    
printf("'%s'@'%s'\n"$row['user'], $row['host']);
}

echo 
"\n==================\n";

// Not using iterators
$result $c->query('SELECT user,host FROM mysql.user');
while (
$row $result->fetch_assoc()) {
    
printf("'%s'@'%s'\n"$row['user'], $row['host']);
}

?>

The above example will output something similar to:

'root'@'192.168.1.1'
'root'@'127.0.0.1'
'dude'@'localhost'
'lebowski'@'localhost'

==================

'root'@'192.168.1.1'
'root'@'127.0.0.1'
'dude'@'localhost'
'lebowski'@'localhost'

See Also

Коментарии

IMPORTANT NOTE:

If you were used to using code like this:

<?php
while(false !== ($row mysql_fetch_assoc($result)))
{
   
//...
}
?>

You must change it to this for mysqli:

<?php
while(null !== ($row mysqli_fetch_assoc($result)))
{
   
//...
}
?>

The former will cause your script to run until max_execution_time is reached.
2011-08-11 20:58:31
http://php5.kiev.ua/manual/ru/mysqli-result.fetch-assoc.html
Автор:
I often like to have my results sent elsewhere in the format of an array (although keep in mind that if you just plan on traversing through the array in another part of the script, this extra step is just a waste of time).

This is my one-liner for transforming a mysqli_result set into an array.
<?php
$sql 
= new MySQLi($host$username$password$database);

$result $sql->query("SELECT * FROM `$table`;");
for (
$set = array (); $row $result->fetch_assoc(); $set[] = $row);
print_r($set);
?>

Outputs:
Array
(
    [0] => Array
        (
            [id] => 1
            [field2] => a
            [field3] => b
        ),
    [1] => Array
        (
            [id] => 2
            [field2] => c
            [field3] => d
        )
)

I use other variations to adapt to the situation, i.e. if I am selecting only one field:
<?php
$sql 
= new MySQLi($host$username$password$database);
$result $sql->query("SELECT `field2` FROM `$table`;");
for (
$set = array (); $row $result->fetch_assoc(); $set[] = $row['field2']);
print_r($set);
?>
Outputs:
Array
(
    [0] => a
    [1] => c
)

Or, to make the array associative with the primary index (code assumes primary index is the first field in the table):
<?php
$sql 
= new MySQLi($host$username$password$database);
$result $sql->query("SELECT * FROM `$table`;");
for (
$set = array (); $row $result->fetch_assoc(); $set[array_shift($row)] = $row);
print_r($set);
?>
Outputs:
Array
(
    [1] => Array
        (
            [field2] => a
            [field3] => b
        ),
    [2] => Array
        (
            [field2] => c
            [field3] => d
        )
)
2013-08-07 20:26:27
http://php5.kiev.ua/manual/ru/mysqli-result.fetch-assoc.html
Автор:
There is a difference between MariaDB and MySQL(>5.4) whether the input parameter (mysqli object) has data or is empty (it comes from a previus query).
-MariaDB:  you get an exception:
Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result
-MySQL: you can continue, in spite of not having data in the mysqli object.
2023-04-26 11:35:34
http://php5.kiev.ua/manual/ru/mysqli-result.fetch-assoc.html

    Поддержать сайт на родительском проекте КГБ