1. Afriza Dwi Nurrochim - 165610029
#10 Modifikasi Tampilan Input Data Kue
Tampilan Pada Index.php
========================================================================
Kode Program
Kue.php
<!DOCTYPE html>
<html>
<head>
<title>DATA KUE</title>
<link rel="stylesheet" type="text/css" href="style/style.css">
</head>
<body>
<!-- AWAL TABEL DAFTAR KUE -->
<div id="body">
<h2 align="center">BORNEO BAKERY</h2>
<div id="header_center">
<div id="menu_wrapper">
<ul id="menu">
<li><a href="kue.php">DAFTAR KUE</a></li>
<li><a href="pelanggan.php">DAFTAR PELANGGAN</a></li>
<li><a href="pesanan.php">DAFTAR PESANAN</a></li>
</ul>
</div>
</div>
<!-- Input Data Baru -->
<div id="form-kue">
<h4>.:Tambah Data Kue</h4>
<form action="kue.php" method="POST" enctype="multipart/form-data">
<table border="1">
<tr>
<th>Nama Kue</th>
<th>Harga (IDR)</th>
<th>Gambar</th>
</tr>
<tr>
<td>
<input type="hidden" name="id_kue">
<input type="text" name="nama">
</td>
<td><input type="text" name="harga"></td>
<td><input type="file" name="gambar"></td>
<td><input type="submit" name="submit" value="+TAMBAH"></td>
</tr>
</table>
</form>
</div>
</br>
<!-- Tabel Kue -->
<div id="tabel-kue">
<h4>.:Daftar Kue</h4>
<table border="5">
<tr>
<th>No.</th>
<th>Nama Kue</th>
<th>Harga (IDR)</th>
<th>Gambar</th>
<th>Alat</th>
</tr>
<tr>
<?php
include 'koneksi.php';
$no = 1;
$data = mysqli_query($koneksi,"SELECT * FROM kue")or die(mysqli_error());
while($d = mysqli_fetch_array($data)){
?>
<td><?php echo $no++; ?></td>
<td><?php echo $d['nama']; ?></td>
<td><?php echo $d['harga']; ?></td>
<td><?php echo $d['gambar']; ?></td>
<td>
<a href="edit_kue.php?id_kue=<?php echo $d['id_kue']; ?>">Edit</a>
<a href="hapus_kue.php?id_kue=<?php echo $d['id_kue']; ?>">Hapus</a>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
<!-- AKHIR TABEL DAFTAR KUE -->
</body>
</html>
<!-- KODE INPUT DATA KUE -->
<?php
if(isset($_POST['submit'])){
include 'koneksi.php';
$id_kue = $_POST['id_kue'];
$nama = $_POST['nama'];
$harga = $_POST['harga'];
$gambar = setGambar();
mysqli_query($koneksi,"INSERT INTO kue VALUES(null,'$nama','$harga','$gambar')");
header("location:kue.php");
}
function setGambar(){
$namaFile = $_FILES['gambar']['name'];
$error = $_FILES['gambar']['error'];
$tmpFile = $_FILES['gambar']['tmp_name'];
$exeGambarValid = ['jpg','jpeg','png'];
$exeGambar = explode('.', $namaFile);
$exeGambar = strtolower(end($exeGambarValid));
if(!in_array($exeGambar, $exeGambarValid)){
echo "<script>
alerts('Bukan gambar itu...');
</script>";
return false;
}
$gambarBaru = uniqid();
$gambarBaru .='.';
$gambarBaru .=$exeGambar;
move_uploaded_file($tmpFile, 'gambar/'.$gambarBaru);
return $gambarBaru;
}
?>
=====================================================================
hapus_kue.php
<?php
include 'koneksi.php';
$id_kue = $_GET['id_kue'];
mysqli_query($koneksi,"DELETE FROM kue WHERE id_kue='$id_kue'");
header("location:kue.php");
?>
======================================================================
