PHP MySQLi mysqli_fetch_object()

mysqli_fetch_object()

The mysqli_fetch_object() function returns the current row of a result set as an object. The field names returned by this function are case-sensitive.

EXAMPLE

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

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

if ($result) {
    echo "<table border='1'>";
    echo "<tr><th>ID</th><th>Fruit</th><th>Vegetable</th><th>Date</th></tr>";
    
    // Here we read the row as an object
    // NOTE: Instead of a classic array with square brackets, the 
    // mysqli_fetch_object() function returns the row as a standard PHP object (stdClass). 
    // Therefore, we access column values elegantly using the arrow operator -> (e.g., $obj->fruit).
    while ($obj = mysqli_fetch_object($result)) {
        printf("<tr><td>%d</td><td>%s</td><td>%s</td><td>%s</td></tr>", 
            $obj->table_id, 
            $obj->fruit, 
            $obj->vegetable, 
            $obj->date
        );
    }
    echo "</table>";
    mysqli_free_result($result);
}
mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This approach is very popular in object-oriented programming (OOP). Instead of using square brackets $row["fruit"], we use the arrow operator $object->fruit.

Each row from the database is transformed into a PHP object.

Column names in the database become property names (e.g., ->fruit).

Ideal for code that follows object-oriented programming standards.