$stmt = $pdo->query('SELECT * FROM users'); while ($row = $stmt->fetch()) { echo $row['username'] . "\n"; }
$stmt = $pdo->prepare('SELECT * FROM products WHERE id = :id'); $stmt->execute(['id' => $product_id]); $product = $stmt->fetch(); echo $product['name'];