PDOFETCHOBJ

PDOFETCHOBJ refers to the fetch mode used with PHP's PDO extension to retrieve query results as objects. The actual constant to use in code is PDO::FETCH_OBJ, which is passed to fetch or fetchAll on a PDOStatement.

When using PDO::FETCH_OBJ, each row of the result set is returned as an instance of the built-in stdClass. The properties of that object correspond to the columns in the result set, with property names derived from the column names. Access is done with object property syntax, for example: $row->username. If a column name is not a valid PHP identifier (for instance, contains spaces or special characters), access can be performed using curly brace syntax, such as $row->{'Column Name'}.

This fetch mode is convenient when you prefer object-oriented access to fields instead of associative arrays. It is commonly used with fetch to obtain a single row or with fetchAll to retrieve multiple rows as an array of objects.

Example:

$stmt = $pdo->query("SELECT id, username FROM users");

$row = $stmt->fetch(PDO::FETCH_OBJ);

echo $row->username;

Compared with PDO::FETCH_ASSOC, which returns arrays, PDO::FETCH_OBJ returns objects, which may influence how you structure the rest of your code. PDO::FETCH_OBJ is one of several fetch modes offered by PDO to tailor data retrieval to your needs.