When working with a single record in a database table, what are some alternative methods to Fetch Array that could be used in PHP?

When working with a single record in a database table in PHP, an alternative method to Fetch Array could be using Fetch Object. This method returns the next row as an object instead of an array, which can be useful if you prefer working with objects in your code. Another alternative could be using Fetch Assoc, which fetches a row as an associative array, making it easier to access values by column names. 

// Using Fetch Object
$query = $pdo->query("SELECT * FROM table_name WHERE id = 1");
$row = $query->fetch(PDO::FETCH_OBJ);
echo $row->column_name;

// Using Fetch Assoc
$query = $pdo->query("SELECT * FROM table_name WHERE id = 1");
$row = $query->fetch(PDO::FETCH_ASSOC);
echo $row['column_name'];

Keywords

MySQLi fetch_assoc PDO fetch_object database record.

Related Questions