PERTEMUAN 10 { CRUD_BUKU TAMU }
~`BUKU TAMU`~
 |
| output awal |
Nahh berikut adalah tampilan dari proses yang dimaksud.
selamat belajar....
~Berikut script tampilbukutamu.php~
<?php
//koneksi ke database
$conn = mysqli_connect("localhost", "root", "", "buku_tamu");
function query($query) {
global $conn;
$result = mysqli_query($conn, $query);
$rows = [];
while( $row = mysqli_fetch_assoc($result) ) {
$rows[] = $row;
}
return $rows;
}
function tambah($data) {
global $conn;
//ambil data dari tiap elemen dalam form
$nama = htmlspecialchars($data["nama"]);
$email = htmlspecialchars($data["email"]);
$pesan = htmlspecialchars($data["pesan"]);
//query insert data
$query = "INSERT INTO tamu VALUES ('','$nama','$email','$pesan')";
mysqli_query($conn,$query);
return mysqli_affected_rows($conn);
}
function hapus($id) {
global $conn;
mysqli_query($conn, "DELETE FROM tamu where id= $id");
return mysqli_affected_rows($conn);
}
function ubah($data) {
global $conn;
$id = $data["id"];
$nama = htmlspecialchars($data["nama"]);
$email = htmlspecialchars($data["email"]);
$pesan = htmlspecialchars($data["pesan"]);
//query insert data
$query = "UPDATE tamu SET
nama = '$nama',
email = '$email',
pesan = '$pesan'
WHERE id = $id";
mysqli_query($conn,$query);
return mysqli_affected_rows($conn);
}
function cari($keyword) {
$query = "SELECT * FROM tamu WHERE
nama LIKE '%$keyword%' OR
email LIKE '%$keyword%'
";
return query($query);
}
?>
= Dan screenshot seperti berikut =
~Berikut script tambahbukutamu.php~
<?php
require 'functions.php';
//cek tombol submit sudah ditekan atau belum
if( isset($_POST["submit"]) ) {
//cek data berhasil ditambah atau tidak
if (tambah($_POST) > 0 ) {
echo "
<script>
alert('data berhasil ditambah!');
document.location.href = 'index.php';
</script>";
} else {
echo "
<script>
alert('data gagal ditambah!');
document.location.href = 'index.php';
</script>";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Tambah data buku tamu</title>
<title>Data Buku Tamu</title>
<!-- bootstrap css -->
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css">
<!-- bootstrap javascript -->
<script src="js/bootstrap.min.js"></script>
</head>
<body>
<h1 align="center">Tambah data buku tamu</h1><br>
<form align="center" action="" method="post" enctype="multipart/form-data">
<div class="form-group row">
<label align="right" for="nama" class="col-sm-4 col-form-label">Nama</label>
<div class="col-lg-4 col-sm-4">
<input type="text" class="form-control" id="nama" name="nama" placeholder="masukkan nama" required>
</div>
</div>
<div class="form-group row">
<label align="right" for="email" class="col-sm-4 col-form-label">Email</label>
<div class="col-lg-4 col-sm-4 col-sm-4">
<input type="text" class="form-control" id="email" name="email" placeholder="masukkan email" required>
</div>
</div>
<div class="form-group row">
<label align="right" for="pesan" class="col-sm-4 col-form-label">Pesan</label>
<div class="col-lg-4 col-sm-4">
<input type="text" class="form-control" id="pesan" name="pesan" placeholder="masukkan pesan" required>
</div>
</div>
<div align="right" class="col-lg-6 col-sm-2">
<button class="btn btn-primary" type="submit" name="submit">Tambah data</button>
</div>
</form>
</body>
</html>
= Dan screenshot seperti berikut =
~Berikut script simpanbukutamu.php~
<!DOCTYPE html>
<html>
<head>
<title>Data Buku Tamu</title>
<!-- bootstrap css -->
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css">
<!-- bootstrap javascript -->
<script src="js/bootstrap.min.js"></script>
<script>
function reloadpage()
{
location.reload()
}
</script>
</head>
<body>
<table class="table table-striped" cellpadding="0" cellspacing="0" widht="70%" align="center">
<tr>
<thead>
<td colspan="6">
<h1 align="center"><b>DATA BUKU TAMU</b></h1>
<a class="btn btn-primary" href="tambah.php">Tambah Buku Tamu</a>
<input class="btn btn-primary" type="submit" value="Refresh Page" onClick="document.location.reload(true)"><br><br>
<form action="" method="post">
<div class="input-group">
<input type="text" class="form-control col-4" autofocus placeholder="masukkan kata kunci pencarian" autocomplete="off" name="keyword">
<div class="input-group-append">
<button class="btn btn-outline-secondary" name="cari" type="submit">search</button>
</div>
</div>
</form>
</td>
</thead>
</tr>
<tr>
<thead>
<th scope="col" width="6%">No.</th>
<th scope="col" width="20%">Nama</th>
<th scope="col" width="25%">Email</th>
<th scope="col" width="39%">Pesan</th>
<th scope="col" width="20%">Aksi</th>
</thead>
</tr>
<tr>
<td scope="row">1</td>
<td>nana</td>
<td>nana@gmail.com</td>
<td>hall</td>
<td>
<a class="badge badge-success" href="ubah.php?id=3">edit</a> |
<a class="badge badge-danger" href="hapus.php?id=3" onclick="return confirm('yakin?');">hapus</a>
</td>
</tr>
<tr>
<td scope="row">2</td>
<td>kaka</td>
<td>kaka@gmail.com</td>
<td>1232</td>
<td>
<a class="badge badge-success" href="ubah.php?id=4">edit</a> |
<a class="badge badge-danger" href="hapus.php?id=4" onclick="return confirm('yakin?');">hapus</a>
</td>
</tr>
<tr>
<td scope="row">3</td>
<td>qwqw</td>
<td>qwqw@gmail.com</td>
<td>asd</td>
<td>
<a class="badge badge-success" href="ubah.php?id=5">edit</a> |
<a class="badge badge-danger" href="hapus.php?id=5" onclick="return confirm('yakin?');">hapus</a>
</td>
</tr>
<tr>
<td scope="row">4</td>
<td>Natalia walter kidi djawang</td>
<td>nataliadjawang@gmail.com</td>
<td>studi kasus 1 buku tamu</td>
<td>
<a class="badge badge-success" href="ubah.php?id=6">edit</a> |
<a class="badge badge-danger" href="hapus.php?id=6" onclick="return confirm('yakin?');">hapus</a>
</td>
</tr>
<tr>
<td scope="row">5</td>
<td>Natalia</td>
<td>nataliadjawang@gmail.com</td>
<td>hello</td>
<td>
<a class="badge badge-success" href="ubah.php?id=7">edit</a> |
<a class="badge badge-danger" href="hapus.php?id=7" onclick="return confirm('yakin?');">hapus</a>
</td>
</tr>
</table>
</body>
</html>
= Dan screenshot seperti berikut =
* Dan yang terakir tampilan output yang muncul di web *
THANK YOU🤞🤞😊
Komentar
Posting Komentar