Berikut adalah script sederhana menggunakan HTML, PHP, dan MySQL untuk menyimpan, menambah, dan menghapus nama dan alamat
Buat database mySQL
CREATE DATABASE db_data;
USE db_data;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
address TEXT NOT NULL
);
Buat file index.php
<?php
include 'config.php';
// Tambah Data
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST['name'];
$address = $_POST['address'];
$query = "INSERT INTO users (name, address) VALUES ('$name', '$address')";
mysqli_query($conn, $query);
header("Location: index.php");
exit();
}
// Hapus Data
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
$query = "DELETE FROM users WHERE id=$id";
mysqli_query($conn, $query);
header("Location: index.php");
exit();
}
// Ambil Data
$result = mysqli_query($conn, "SELECT * FROM users");
?>
<!DOCTYPE html>
<html lang="id">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Data Nama & Alamat</title>
</head>
<body>
<h2>Tambah Data</h2>
<form action="index.php" method="POST">
<input type="text" name="name" placeholder="Nama" required>
<input type="text" name="address" placeholder="Alamat" required>
<button type="submit">Simpan</button>
</form>
<h2>Daftar Nama & Alamat</h2>
<table border="1">
<tr>
<th>No</th>
<th>Nama</th>
<th>Alamat</th>
<th>Aksi</th>
</tr>
<?php
$no = 1;
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>
<td>".$no++."</td>
<td>".$row['name']."</td>
<td>".$row['address']."</td>
<td>
<a href='index.php?delete=".$row['id']."' onclick='return confirm(\"Yakin hapus?\")'>Hapus</a>
</td>
</tr>";
}
?>
</table>
</body>
</html>
Posting Komentar untuk "Berikut adalah script sederhana menggunakan HTML, PHP, dan MySQL untuk menyimpan, menambah, dan menghapus nama dan alamat"