Home » PHP » Cara Hapus Data dari Database PHP MySQL

Cara Hapus Data dari Database PHP MySQL

by Hanifah Nurbaeti
by Hanifah Nurbaeti

Hapus Data Dari Tabel MySQL Menggunakan MySQLi dan PDO

Pernyataan DELETE digunakan untuk menghapus record dari tabel:

DELETE FROM table_name
WHERE some_column = some_value

Perhatikan klausa WHERE dalam sintaks DELETE: Klausa WHERE menentukan record atau record mana yang harus dihapus. Jika dihilangkan klausa WHERE, semua record akan dihapus!

Mari kita lihat tabel “MyGuests”:

idfirstnamelastnameemailreg_date
1JohnDoe[email protected]2014-10-22 14:26:15
2MaryMoe[email protected]2014-10-23 10:22:30
3JulieDooley[email protected]2014-10-26 10:48:23

Contoh berikut menghapus record dengan id = 3 di tabel “MyGuests”:

Contoh (MySQLi Object-oriented) :

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Buat Koneksi
$conn = new mysqli($servername, $username, $password, $dbname);
// Periksa Koneksi
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

// sql untuk menghapus record
$sql = "DELETE FROM MyGuests WHERE id=3";

if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . $conn->error;
}

$conn->close();
?>

Contoh (MySQLi Prosedural) :

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Buat Koneksi
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Periksa Koneksi
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

// sql untuk menghapus record
$sql = "DELETE FROM MyGuests WHERE id=3";

if (mysqli_query($conn, $sql)) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

Contoh (PDO) :

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // mengatur mode error  PDO ke exceptions
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  // sql untuk menghapus record
  $sql = "DELETE FROM MyGuests WHERE id=3";

  // gunakan exec() karena tidak ada hasil yang dikembalikan
  $conn->exec($sql);
  echo "Record deleted successfully";
} catch(PDOException $e) {
  echo $sql . "<br>" . $e->getMessage();
}

$conn = null;
?>

Setelah record dihapus, tabel akan terlihat seperti ini:

idfirstnamelastnameemailreg_date
1JohnDoe[email protected]2014-10-22 14:26:15
2MaryMoe[email protected]2014-10-23 10:22:30

You may also like