Spear — Learn to Code

Docs/PHP/MySQL (PDO)

PHP PDO (MySQL)

PDO (PHP Data Objects) adalah cara aman dan modern untuk mengakses database.

Keunggulan PDO

Prepared statements (anti SQL injection)
Support banyak database
Error handling dengan exceptions

CRUD

Create — INSERT
Read — SELECT
Update — UPDATE
Delete — DELETE

index.php

Try It →

<?php
// Connection
try {
    $pdo = new PDO(
        "mysql:host=localhost;dbname=myapp;charset=utf8mb4",
        "root", "password",
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
    echo "✅ Connected!

";
} catch (PDOException $e) {
    die("❌ Connection failed: " . $e->getMessage());
}

// CREATE
$stmt = $pdo->prepare("INSERT INTO users (name, email) VALUES (:name, :email)");
$stmt->execute(['name' => 'Ali', 'email' => 'ali@mail.com']);
echo "Inserted ID: " . $pdo->lastInsertId() . "
";

// READ
$stmt = $pdo->prepare("SELECT * FROM users WHERE email = ?");
$stmt->execute(['ali@mail.com']);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
echo "User: " . $user['name'] . "
";

// UPDATE
$stmt = $pdo->prepare("UPDATE users SET name = ? WHERE id = ?");
$stmt->execute(['Ali Updated', 1]);

// DELETE
$stmt = $pdo->prepare("DELETE FROM users WHERE id = ?");
$stmt->execute([1]);

echo "
// Always use prepared statements!";
?>

← Previous

Regular Expressions

Arrow & Closure