PHP MySQLi mysqli_fetch_row()

mysqli_fetch_row()

The mysqli_fetch_row() function fetches one row from a result set and returns it as a numerical array. We access the data via indexes, where counting starts at 0.

EXAMPLE

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

$connection = mysqli_connect($server, $username, $password, $database);
$query = "SELECT * FROM mysqli_table";

if ($result = mysqli_query($connection, $query)) {
    // Reading rows as numeric arrays (indices)
    // NOTE: The mysqli_fetch_row() function does not use text keys. 
    // We get column data exclusively via numeric indices, which start at 0. 
    // In our table, 0 is the ID, 1 is the fruit, and 2 is the vegetable.
    while ($row = mysqli_fetch_row($result)) {
        printf("ID %d: %s goes well with: %s<br>", $row[0], $row[1], $row[2]);
    }
    mysqli_free_result($result);
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is fast, but we must be careful about the order of the columns in the database. In the example below, we are outputting the ID (index 0) and the color (index 2):

Data is accessible via numbers (0, 1, 2...).

The order of the indexes matches the order of the columns in the SQL query.

Ideal when we do not need column names, but only raw data.