Retrieving Data as Objects with fetchObject()

The fetchObject() method returns the next row from a result set as an object. The column names from the database become the properties of this object. The main advantage of this approach is its consistency with the rest of your object-oriented code, as you access the data using the $object->column syntax instead of $array["column"], which enhances readability and reduces the likelihood of typos.

EXAMPLE

<?php
class Database {
    private $server = "localhost";
    private $username = "root";
    private $password = "";
    private $db_name = "pdo_db";
    public $connection;

    public function __construct() {
        try {
            // Added charset=utf8mb4 for character support
            $dsn = "mysql:host=" . $this->server . ";dbname=" . $this->db_name . ";charset=utf8mb4";
            $this->connection = new PDO($dsn, $this->username, $this->password);
            $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch(PDOException $e) {
            die("Connection failed: " . $e->getMessage());
        }
    }

    public function getUserAsObject($id) {
        $statement = $this->connection->prepare("SELECT first_name, last_name FROM users WHERE id = :id");
        $statement->execute(['id' => $id]);
        
        // fetchObject() returns the row as an object
        $user = $statement->fetchObject();
        
        $statement->closeCursor();
        return $user;
    }
}

// PART 3: Usage
$db = new Database();
$u = $db->getUserAsObject(1);

if ($u) {
    echo "Object-oriented access: " . $u->first_name . " " . $u->last_name;
}
?>

RESULT

The result will be displayed here...

Practical Application: We use the fetchObject method in modern applications where we want the database rows to behave like true objects. Check the process at home by following these steps:

Start the Apache and MySQL modules in the XAMPP control panel.
Ensure via phpMyAdmin that the users table with test data exists within the pdo_db database.
The method returns an object of type stdClass; if there are no more rows, it returns false.
Insert the example below into a PHP file and test accessing data using the arrow syntax.