PHP MySQLi mysqli_fetch_array()

mysqli_fetch_array()

The mysqli_fetch_array() function fetches a result row as an array that can be associative, numeric, or both at the same time.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);
$table = mysqli_query($connection, "SELECT fruit FROM mysqli_table");

// Use associative mode for reading inside the loop
// NOTE: Since the mysqli_fetch_array() function reads only one row at a time, we 
// place it inside a while loop. The loop will run cycle after cycle until there are 
// no more rows in the database. Each cycle will load the next fruit into the $row variable.
while ($row = mysqli_fetch_array($table, MYSQLI_ASSOC)) {
    print($row["fruit"] . "<br>");
}

mysqli_free_result($table);
mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function accepts an optional parameter to determine the type of array. If you use MYSQLI_ASSOC, you get column names, with MYSQLI_NUM you get numbers, and with MYSQLI_BOTH you get both. Test it at home like this:

The most versatile function for fetching rows.

If you do not specify the parameter, the default value is MYSQLI_BOTH.

Very useful when you need a quick switch between data access modes.