PHPize Online / SQLize Online  /  SQLtest Online

<?php // $mysqli is already declared as a working database connection by this sandbox $sql = "SELECT * FROM my_table"; foreach ($pdo->query($sql) as $row) { vprintf("id: %d, n: %s, k: %s\n";, $row); } echo "\n---\n"; foreach ($pdo->query($sql) as $row) { echo "id: {$row['id']}, n: {$row['n']}, k: {$row['k']}\n"; } echo "\n---\n"; foreach ($pdo->query($sql) as ['id' => $id, 'n' => $n, 'k' => $k]) { echo "id: $id, n: $n, k: $k\n"; } echo "\n---\n"; $result = []; foreach ($pdo->query($sql) as ['id' => $id, 'n' => $n, 'k' => $result[$id][$n]]); var_export($result);