PHP Crud Pdo Insert Select Update Delete

Ringkasan

CRUD = Create, Read, Update, Delete. Polanya sama di semua engine berkat PDO.

Konsep Dasar

• Create: INSERT + execute([...]).
• Read: SELECT + fetch / fetchAll.
• Update: UPDATE ... WHERE id=?.
• Delete: DELETE FROM ... WHERE id=?.
• Ambil lastInsertId() setelah insert.

Cara Kerja / Struktur

php

// Create
$st = $pdo->prepare("INSERT INTO posts(title, body) VALUES(?,?)");
$st->execute([$title, $body]);
$id = $pdo->lastInsertId();
 
// Read
$st = $pdo->prepare("SELECT * FROM posts WHERE id = ?");
$st->execute([$id]);
$post = $st->fetch(PDO::FETCH_ASSOC);
 
// Update
$pdo->prepare("UPDATE posts SET title=? WHERE id=?")->execute([$t, $id]);
 
// Delete
$pdo->prepare("DELETE FROM posts WHERE id=?")->execute([$id]);

Catatan Implementasi

• Bungkus dalam transaksi (beginTransaction/commit) bila multi-query.
• Validasi input sebelum masuk query (lihat PHP Security).
• Walkthrough aplikasi nyata dibuat terpisah.

Kesalahan Umum

• WHERE tanpa parameter → hapus/update semua baris.
• Lupa execute() → statement tidak jalan.

Glosarium

• CRUD: 4 operasi dasar penyimpanan data.
• lastInsertId: ID baris terakhir di-insert.

Referensi

• PHP Database: PDO Connection