PHP Database Pdo Connection Prepared Statements

Ringkasan

PDO (PHP Data Objects) adalah lapisan akses DB yang konsisten & aman. Prepared statement mencegah SQL injection.

Konsep Dasar

• DSN: string koneksi (mysql:host=...;dbname=...;charset=utf8mb4).
• new PDO($dsn, $user, $pass, $opts) di dalam try/catch.
• prepare() + execute([params]) → query aman.
• Placeholder ? (positional) atau :nama (named).

Cara Kerja / Struktur

php

try {
    $pdo = new PDO(
        "mysql:host=localhost;dbname=app;charset=utf8mb4",
        "user", "pass",
        [PDO::