PEMROGRAMAN WEB II
UAS
NANDA NUR ADLI
11214307
INFORMATIKA
UNIVERSITAS SERANG RAYA
SERANG – BANTEN
1. Struktur Database
2. Codingan :
<!DOCTYPE html>
<html>
<head>
<title>Nanda Nur Adli 11214307</title>
</head>
<body>
<?php
// --- koneksi
$koneksi = mysqli_connect("localhost","root","","uts") or die(mysqli_connect_error());
// Insert Data
function insert($koneksi){
if (isset($_POST['btn_simpan'])){
$id_member = $_POST['id_member'];
$nama_depan = $_POST['nama_depan'];
$nama_belakang = $_POST['nama_belakang'];
$email = $_POST['email'];
$alamat = $_POST['alamat'];
$provinsi = $_POST['provinsi'];
$kabupaten = $_POST['kabupaten'];
$username = $_POST['username'];
$password = $_POST['password'];
if(!empty($id_member) && !empty($nama_depan) && !empty($nama_belakang) &&
!empty($email) && !empty($alamat) && !empty($provinsi) && !empty($kabupaten) &&
!empty($username) && !empty($password)){
$sql = "INSERT INTO member (id_member, nama_depan, nama_belakang,
email, alamat, provinsi, kabupaten, username, password) VALUES
('".$id_member."', '".$nama_depan."', '".$nama_belakang."',
'".$email."','".$alamat."', '".$provinsi."', '".$kabupaten."', '".$username."', '".$password."')";
$simpan = mysqli_query($koneksi, $sql);
if($simpan && isset($_GET['aksi'])){
if($_GET['aksi'] == 'create'){
header('location: uas.php');
} else {
$pesan = "Tidak dapat menyimpan, data belum lengkap!";
?>
<form action="" method="POST">
<fieldset>
<legend><h2>Insert Data</h2></legend>
<table>
<tr><td><input type="int" name="id_member" placeholder="ID
Member"></td></tr>
<tr><td><input type="varchar" name="nama_depan"
placeholder="Nama Depan"></td></tr>
<tr><td><input type="varchar" name="nama_belakang"
placeholder="Nama Belakang"></td></tr>
<tr><td><input type="text" name="email"
placeholder="Email"></td></tr>
<tr><td><input type="text" name="alamat"
placeholder="Alamat"></td></tr>
<tr><td><input type="text" name="provinsi"
placeholder="Provinsi"></td></tr>
<tr><td><input type="text" name="kabupaten"
placeholder="Kabupaten"></td></tr>
<tr><td><input type="text" name="username"
placeholder="Username"></td></tr>
<tr><td><input type="text" name="password"
placeholder="Password"></td></tr>
</table>
<br>
<label>
<input type="submit" name="btn_simpan" value="Simpan"/>
<input type="reset" name="reset" value="Besihkan"/>
</label>
<br>
<p><?php echo isset($pesan) ? $pesan : "" ?></p>
</fieldset>
</form>
<?php
// Close Insert Data
// View Data
function view_data($koneksi){
$sql = "SELECT * FROM member";
$query = mysqli_query($koneksi, $sql);
$no = 0;
echo "<fieldset>";
echo "<legend><h2>Data Member</h2></legend>";
echo "<table border='1' cellpadding='10'>";
echo "<tr>
<th>No</th>
<th>ID Member</th>
<th>Nama Depan</th>
<th>Nama Belakang</th>
<th>Email</th>
<th>Alamat</th>
<th>Provinsi</th>
<th>Kabupaten</th>
<th>Username</th>
<th>Password</th>
<th>Tindakan</th>
</tr>";
while($data = mysqli_fetch_array($query)){
$no++;
?>
<tr>
<td><?php echo "$no"; ?></td>
<td><?php echo $data['id_member']; ?></td>
<td><?php echo $data['nama_depan']; ?></td>
<td><?php echo $data['nama_belakang']; ?></td>
<td><?php echo $data['email']; ?></td>
<td><?php echo $data['alamat']; ?></td>
<td><?php echo $data['provinsi']; ?></td>
<td><?php echo $data['kabupaten']; ?></td>
<td><?php echo $data['username']; ?></td>
<td><?php echo $data['password']; ?></td>
<td>
<a href="uas.php?aksi=update&id_member=<?php echo
$data['id_member']; ?>&id_member=<?php echo $data['id_member']; ?>&nama_depan=<?php echo
$data['nama_depan']; ?>&nama_belakang=<?php echo $data['nama_belakang']; ?>&email=<?php echo
$data['email']; ?>&alamat=<?php echo $data['alamat']; ?>&provinsi=<?php echo $data['provinsi'];
?>&kabupaten=<?php echo $data['kabupaten']; ?>&username=<?php echo $data['username'];
?>&password=<?php echo $data['password']; ?>">Edit</a> |
<a href="uas.php?aksi=delete&id_member=<?php echo
$data['id_member']; ?>" onclick="return confirm('Are you sure you want to delete this data
?');">Delete</a>
</td>
</tr>
<?php
echo "</table>";
echo "</fieldset>";
// Close View Data
// Edit Data (Update)
function edit($koneksi){
// edit data
if(isset($_POST['btn_edit'])){
$id_member = $_POST['id_member'];
$nama_depan = $_POST['nama_depan'];
$nama_belakang = $_POST['nama_belakang'];
$email = $_POST['email'];
$alamat = $_POST['alamat'];
$provinsi = $_POST['provinsi'];
$kabupaten = $_POST['kabupaten'];
$username = $_POST['username'];
$password = $_POST['password'];
if(!empty($id_member) && !empty($nama_depan) && !empty($nama_belakang) &&
!empty($email) && !empty($alamat) && !empty($provinsi) && !empty($kabupaten) &&
!empty($username) && !empty($password)){
$perubahan =
"id_member='".$id_member."',nama_depan='".$nama_depan."',nama_belakang='".$nama_belakang."',
email='".$email."',alamat='".$alamat."',provinsi='".$provinsi."',kabupaten='".$kabupaten."',username='"
.$username."',password='".$password."'";
$sql_update = "UPDATE member SET ".$perubahan." WHERE
id_member=$id_member";
$update = mysqli_query($koneksi, $sql_update);
if($update && isset($_GET['aksi'])){
if($_GET['aksi'] == 'update'){
header('location: uas.php');
} else {
$pesan = "Data tidak lengkap!";
}
// Form Edit Data
if(isset($_GET['id_member'])){
$sql = "SELECT * FROM member WHERE id_member='".$_GET['id_member']."' ";
$exec = mysqli_query($koneksi, $sql);
$data = mysqli_fetch_assoc($exec);
?>
<a href="uas.php"> « Home</a> |
<a href="uas.php?aksi=create"> (+) Insert Data</a>
<hr>
<form action="" method="POST">
<fieldset>
<legend><h2>Edit Data</h2></legend>
<table>
<tr><td><input type="int" name="id_member" placeholder="ID
Member" value='<?php echo $data['id_member']; ?>' ></td></tr>
<tr><td><input type="varchar" name="nama_depan"
placeholder="Nama Depan" value='<?php echo $data['nama_depan']; ?>' ></td></tr>
<tr><td><input type="varchar" name="nama_belakang"
placeholder="Nama Belakang" value='<?php echo $data['nama_belakang']; ?>' ></td></tr>
<tr><td><input type="text" name="email" placeholder="Email"
value='<?php echo $data['email']; ?>' ></td></tr>
<tr><td><input type="text" name="alamat"
placeholder="Alamat" value='<?php echo $data['alamat']; ?>' ></td></tr>
<tr><td><input type="text" name="provinsi"
placeholder="Provinsi" value='<?php echo $data['provinsi']; ?>' ></td></tr>
<tr><td><input type="text" name="kabupaten"
placeholder="Kabupaten" value='<?php echo $data['kabupaten']; ?>' ></td></tr>
<tr><td><input type="text" name="username"
placeholder="Username" value='<?php echo $data['username']; ?>' ></td></tr>
<tr><td><input type="text" name="password"
placeholder="Password" value='<?php echo $data['password']; ?>' ></td></tr>
</table>
<br>
<label>
<input type="submit" name="btn_edit" value="Simpan
Perubahan"/> atau <a href="uas.php?aksi=delete&id_member=<?php echo $data['id_member']; ?>"
onclick="return confirm('Are you sure you want to delete this data ?');"> (x) Delete this data</a>!
</label>
<br>
<p><?php echo isset($pesan) ? $pesan : "" ?></p>
</fieldset>
</form>
<?php
// Close Edit Data (Update)
// Delete data
function delete($koneksi){
if(isset($_GET['id_member']) && isset($_GET['aksi'])){
$id_member = $_GET['id_member'];
$sql_delete = "DELETE FROM member WHERE id_member=" . $id_member;
$delete= mysqli_query($koneksi, $sql_delete);
if($delete){
if($_GET['aksi'] == 'delete'){
header('location: uas.php');
// Close Delete Data
// ===================================================================
// --- Program
if (isset($_GET['aksi'])){
switch($_GET['aksi']){
case "create":
echo '<a href="uas.php"> « Home</a>';
insert($koneksi);
break;
case "read":
view_data($koneksi);
break;
case "update":
edit($koneksi);
view_data($koneksi);
break;
case "delete":
delete($koneksi);
break;
default:
echo "<h3>Aksi <i>".$_GET['aksi']."</i> tidaka ada!</h3>";
insert($koneksi);
view_data($koneksi);
} else {
insert($koneksi);
view_data($koneksi);
?>
</body>
</html>
Tampilan web :
