<?php
include_once("koneksi.php");
if (isset($_POST["simpan"])) {
$judul = $_POST["judul"];
$gambar = $_FILES["gambar"]["name"]; // Ambil nama file gambar
$kategori = $_POST["kategori"];
$isi = $_POST["isi"];
// Buat query SQL dengan tanda kutip pada nilai string
$queryPost = "INSERT INTO books VALUES ('','$judul', '$gambar', '$kategori', '$isi)";
if (mysqli_query($conn, $queryPost)) {
echo "
<script>
alert('Berhasil Menambahkan buku baru!');
window.location.href = 'index.php';
</script>
";
} else {
echo "<script>
alert('Gagal disimpan')
</script>";
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Books</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65" crossorigin="anonymous">
</head>
<body>
<!-- navbar start -->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container">
<a class="navbar-brand" href="#">Navbar</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse"
data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false"
aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav me-auto mb-2 mb-lg-0">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="#">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" role="button" data-bs-toggle="dropdown"
aria-expanded="false">
Dropdown
</a>
<ul class="dropdown-menu">
<li><a class="dropdown-item" href="#">Action</a></li>
<li><a class="dropdown-item" href="#">Another action</a></li>
<li>
<hr class="dropdown-divider">
</li>
<li><a class="dropdown-item" href="#">Something else here</a></li>
</ul>
</li>
<li class="nav-item">
<a class="nav-link disabled">Disabled</a>
</li>
</ul>
<form class="d-flex" role="search">
<input class="form-control me-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success" type="submit">Search</button>
</form>
</div>
</div>
</nav>
<!-- navbar end -->
<!-- form start -->
<div class="container mt-5">
<div class="row">
<h1>Halaman Admin</h1>
</div>
<div class="row my-5">
<div class="col-8">
<form action="" method="POST" enctype="multipart/form-data">
<div class="mb-5">
<label for="judul" class="form-label"> Judul buku</label>
<input type="text" class="form-control" name="judul" id="judul" placeholder="Isi judul buku anda" required>
</div>
<div class="mb-5">
<label for="judul" class="form-label">Upload Gambar</label>
<input type="file" class="form-control" name="gambar" id="judul" required>
</div>
<div class="mb-5">
<label for="Isi" class="form-label">Isi keterangan</label>
<textarea class="form-control" id="keterangan" name="keterangan" rows="3" required></textarea>
</div>
<div class="mb-5">
<label for="Isi" class="form-label">Isi</label>
<textarea class="form-control" id="keterangan" name="isi" rows="3" required></textarea>
</div>
<div class="mb-5">
<label for="kategori" class="form-label">Kategori</label>
<select name="kategori" id="kategori" class="form-select" required>
<option value="Coding">Coding</option>
<option value="Design">Design</option>
<option value="Personal">Personal</option>
</select>
</div>
<a href="index.php" class="btn btn-outline-secondary btn-lg">Back</a>
<button type="submit" name="simpan" class="btn btn-outline-success btn-lg col-4">Simpan</button>
</form>
</div>
</div>
</div>
<!-- form end -->
<!-- gs bootstrap -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"
integrity="sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK/7HAuoJl+0I4"
crossorigin="anonymous"></script>
</body>
</html>
<?php
include "koneksi.php";
if(isset($_GET['id'])){
$id = $_GET['id'];
$queryDelete = "DELETE FROM books WHERE id=$id";
if(mysqli_query($conn, $queryDelete)) {
header("location:index.php");
}else {
echo "data is failed to delete :" .mysqli_error($conn);
}
}
?>
<?php
include_once("koneksi.php");
$id = $_GET["id"];
$getData = mysqli_query($conn, "select * from books where id = $id");
$books = mysqli_fetch_assoc($getData);
if (isset($_POST["ubah"])) {
// ini untuk menyimpan data kedalam variablle
$judul = htmlspecialchars($_POST["judul"]);
$gambar = $_FILES["gambar"]["name"];
isi = htmlspecialchars($_POST["isi"]);
$kategori = $_POST["kategori"];
// query
$query = "UPDATE books SET judul = '$judul', gambar = '$gambar', isi = '$isi', kategori = '$kategori' where id = $id";
mysqli_query($conn, $query);
if (mysqli_affected_rows($conn) > 0) {
header("Location: index.php");
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Books</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65" crossorigin="anonymous">
</head>
<body>
<!-- navbar start -->
<nav class="navbar navbar-expand-lg bg-light">
<div class="container-fluid">
<a class="navbar-brand" href="#">Navbar</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse"
data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false"
aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav me-auto mb-2 mb-lg-0">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="#">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" role="button" data-bs-toggle="dropdown"
aria-expanded="false">
Dropdown
</a>
<ul class="dropdown-menu">
<li><a class="dropdown-item" href="#">Action</a></li>
<li><a class="dropdown-item" href="#">Another action</a></li>
<li>
<hr class="dropdown-divider">
</li>
<li><a class="dropdown-item" href="#">Something else here</a></li>
</ul>
</li>
<li class="nav-item">
<a class="nav-link disabled">Disabled</a>
</li>
</ul>
<form class="d-flex" role="search">
<input class="form-control me-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success" type="submit">Search</button>
</form>
</div>
</div>
</nav>
<!-- navbar end -->
<!-- form start -->
<div class="container mt-5">
<div class="row">
<h1>Ubah data buku</h1>
</div>
<div class="row my-5">
<div class="col-8">
<form action="" method="POST" enctype="multipart/form-data">
<div class="mb-5">
<label for="judul" class="form-label"> Judul buku</label>
<input type="text" class="form-control" name="judul" id="judul" placeholder="Isi judul buku anda" value="<?= $books["judul"]; ?>">
</div>
<div class="mb-5">
<label for="judul" class="form-label">Upload Gambar</label>
<input type="file" class="form-control" name="gambar" id="judul" value="<?= $books["gambar"]; ?>">
<p><?= $books["gambar"]; ?></p>
</div>
<div class="mb-5">
<label for="Isi" class="form-label">Isi keterangan</label>
<textarea class="form-control" id="isi" name="isi" rows="3">
<?= $books["isi"]; ?>
</textarea>
</div>
<div class="mb-5">
<label for="kategori" class="form-label">Kategori</label>
<select name="kategori" id="kategori" class="form-select">
<option value="<?= $books["kategori"]; ?>" hidden><?= $books["kategori"]; ?></option>
<option value="Coding">Coding</option>
<option value="Design">Design</option>
<option value="Personal">Personal</option>
</select>
</div>
<a href="index.php" class="btn btn-outline-secondary btn-lg">Back</a>
<button type="submit" name="ubah" class="btn btn-outline-success btn-lg col-4">ubah</button>
</form>
</div>
</div>
</div>
<!-- form end -->
<!-- gs bootstrap -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"
integrity="sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK/7HAuoJl+0I4"
crossorigin="anonymous"></script>
</body>
</html>
<?php
session_start();
session_destroy();
header("Location: login.php");
exit;
?>
