Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
<?php $stmt = $pdo->query("SELECT id, name, email FROM users"); // FETCH_ASSOC: ["id"=>1, "name"=>"Alice"] $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); // FETCH_OBJ: $row->name $rows = $stmt->fetchAll(PDO::FETCH_OBJ); // FETCH_CLASS: maps to User properties $users = $stmt->fetchAll(PDO::FETCH_CLASS, User::class); // FETCH_COLUMN: just the first column $names = $stmt->fetchAll(PDO::FETCH_COLUMN, 0); // ["Alice", "Bob"] // FETCH_KEY_PAIR: ["id" => "name"] map $idToName = $stmt->fetchAll(PDO::FETCH_KEY_PAIR); // [1=>"Alice", 2=>"Bob"]
Result
Open