Training Trains Internship
Student login
← PHP learning path
PHP · Module 7 of 10

Databases with PDO

Connect to MySQL safely with PDO.

📖 Key ideas

  1. PDO connects to MySQL and other databases.
  2. Use prepared statements: $stmt = $pdo->prepare("SELECT * FROM users WHERE email = ?");
  3. Execute with values: $stmt->execute([$email]);
  4. Fetch results: fetch(), fetchAll(PDO::FETCH_ASSOC).
  5. Hash passwords with password_hash().
💡 Real-life example: Prepared statements are fill-in forms with fixed boxes: data stays data, never becomes commands.
PDOPHP Data Objects database layer
Prepared statementQuery with placeholders
fetchAllGets all result rows
password_hashSecure password hashing