$sql = 'SELECT id, name, email FROM USERS';
$users = $db->query($sql)->fetchAll(PDO::FETCH_OBJ);[
0 => {id: 123, name: "John", email: "[email protected]"},
1 => {id: 278, name: "Mary", email: "[email protected]"},
2 => {id: 390, name: "Evan", email: "[email protected]"},
]
PDO::FETCH_UNIQUE uses the first column in the query as the key for the result set:
$users = $db->query($sql)->fetchAll(PDO::FETCH_OBJ|PDO::FETCH_UNIQUE);[
123 => {name: "John", email: "[email protected]"},
278 => {name: "Mary", email: "[email protected]"},
390 => {name: "Evan", email: "[email protected]"},
]
If you want to keep that column in the objects as well, you will need to add it to the query twice:
$sql = 'SELECT id, id, name, email FROM USERS';
$users = $db->query($sql)->fetchAll(PDO::FETCH_OBJ);[
123 => {id: 123, name: "John", email: "[email protected]"},
278 => {id: 278, name: "Mary", email: "[email protected]"},
390 => {id: 390, name: "Evan", email: "[email protected]"},
]
This saves having to do the "normal" query, then loop through the results to create a second array indexed by id.