Syntax
$statement = $pdo->prepare("SELECT * FROM users WHERE email = :email");
$statement->execute(["email" => $email]);Examples
PHP PDO prepared statements example
A focused example you can adapt while practising.
$statement = $pdo->prepare("SELECT * FROM users WHERE email = :email");
$statement->execute(["email" => $email]);Best practices
- Start with the smallest working example, then adapt it to your project.
- Use the language’s standard library and idioms before introducing extra dependencies.
Runtime & versions
PHP runtime on a server or CLI. Feature availability depends on the language and runtime version used by your project; consult the official reference below.
PHP Manual