What is the purpose of using PDO::FETCH_CLASS in PHP?

When fetching data from a database using PDO in PHP, the default fetch mode is to return an array. However, using PDO::FETCH_CLASS allows you to fetch the data directly into an object of a specified class, making it easier to work with the data in an object-oriented manner. 

class User {
    public $id;
    public $username;
    public $email;
}

$stmt = $pdo->prepare("SELECT * FROM users WHERE id = :id");
$stmt->execute(['id' => 1]);
$user = $stmt->fetch(PDO::FETCH_CLASS, 'User');
echo $user->username;

Keywords

PDO FETCH_CLASS PHP object-oriented programming database connectivity

Related Questions