$st = $pdo->prepare('SELECT * FROM test LIMIT 1');
$st->execute();
$row = $st->fetch(PDO::FETCH_ASSOC);
$pdo->prepare
- prepare given query to execute$st->execute(
- run query on the serverfetch
- returns single row from resulting setFETCH_ASSOC
- will return row as an associative array (rather than numbered array)group: fetch
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('SELECT * FROM test LIMIT 1');
$st->execute();
$row = $st->fetch(PDO::FETCH_ASSOC);
print_r($row);
Array
(
[id] => 1
[age] => 25
[name] => A
[data] =>
)
View on GitHub: https://github.com/Onelinerhub/onelinerhub/blob/main/php-pdo/fetch-single-row-with-php-pdo.md