Signatur
class PDOStatement implements IteratorAggregate
Beschreibung
Methoden: execute($params), fetch(), fetchAll(), fetchColumn(), rowCount(), bindValue(), bindParam().
Rückgabewert
Typ
PDOStatement
Beschreibung
Statement.
Beispiele
Fetch mit Klasse
<?php
$stmt = $pdo->prepare('SELECT id, name FROM users');
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_CLASS, User::class);
foreach ($stmt as $user) {
// $user ist User-Instanz
}FetchColumn
<?php
$stmt = $pdo->prepare('SELECT COUNT(*) FROM orders WHERE user_id = ?');
$stmt->execute([$userId]);
echo (int) $stmt->fetchColumn();