Why Prepared Statements Matter
Prepared statements guarantee that input data is never evaluated as SQL syntax, rendering SQL injection impossible when utilized correctly.
<?php
$pdo = new PDO($dsn, $user, $pass, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
]);
$stmt = $pdo->prepare("SELECT id, username, email FROM users WHERE status = :status AND role = :role");
$stmt->execute([
':status' => 'active',
':role' => 'admin'
]);
$users = $stmt->fetchAll();