latihan membuat website

MYSQL 1-create-db.sql

CREATE DATABASE latihan CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MYSQL 2-create-table.sql

CREATE TABLE artikel (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    judul VARCHAR(255) NOT NULL,
    isi TEXT NOT NULL
)

PDO 1-connect-to-db.php

<?php

$hostname = 'localhost';
$dbname = 'latihan';
$username = 'root';
$password = '';

$pdo = new PDO('mysql:host='.$hostname.';dbname='.$dbname, $username, $password, array(
  PDO::ATTR_PERSISTENT => true
));

PDO 2-error-handling.php

<?php

$hostname = 'localhost';
$dbname = 'latihanlagi';
$username = 'root';
$password = '';

try {
	$pdo = new PDO('mysql:host='.$hostname.';dbname='.$dbname, $username, $password, array(
		PDO::ATTR_PERSISTENT => true
	));
	$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e){
	echo "Ada error gan: ".$e->getMessage();
}

PDO 3-insert.php

<?php

$judul = "judul artikel yang baru";
$isi = "isi artikel baru yang akan diinputkan ke database";

$sql_insert = "INSERT INTO `artikel` (`judul`,`isi`) VALUES (?,?)";
$query = $pdo->prepare($sql_insert);
$query->bindParam(1, $judul);
$query->bindParam(2, $isi);
$query->execute();

PDO 4-select.php

<?php

$sql_select = "SELECT * FROM `artikel`";
$query = $pdo->prepare($sql_select);
$query->execute();
$row = $query->fetchAll();
foreach ($row as $data) {
	echo "<h3>Judul = ".$data['judul']."</h3>";
	echo "<p>Isi = ".$data['isi']."</p>";
}

PDO 5-update.php

<?php

$judul = "ganti dengan judul baru";
$isi = "ganti isi artikel dengan yang baru";
$id = 1;

$sql_update = "UPDATE `artikel` SET `judul` = ?, `isi` = ? WHERE `id` = ?";
$query = $pdo->prepare($sql_update);
$query->bindParam(1, $judul);
$query->bindParam(2, $isi);
$query->bindParam(3, $id);
$query->execute();

PDO 6-delete.php

<?php

$id = 2;
$sql_delete = "DELETE FROM `artikel` WHERE `id` = ?";
$query = $pdo->prepare($sql_delete);
$query->execute(array($id));