PDOStatmant::fetchColumnを使う
$sql = 'select count(*) from T_test where name = :name';
$stmt = $pdo -> prepare($sql);
$stmt -> execute(array('name' => 'もえの'));
$count = $stmt -> fetchColumn();
//fetchColumn(0)の0を省略
echo $count;
fetchAll()の[0][0]と同じ。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme