biar kebaca

 <h3>Kategori Buku</h3>
<?php
$id = isset($_GET['idbag']) ? $_GET['idbag'] : NULL;
$mod = isset($_GET['mod']) ? $_GET['mod'] : NULL;

if ($mod == "del") {
$q_delete_bagian = mysql_query("DELETE FROM perpus_kategori WHERE id = '$id'");
if ($q_delete_bagian) {
echo "<div class='alert alert-block alert-success'><button type='button' class='close' data-dismiss='alert'><i class=''></i></button><strong><i class='ace-icon fa fa-check'></i> BERHASIL</strong> Data Kategori Buku Berhasil di hapus<br/></div>";
} else {
echo "<div class='alert alert-danger'><button type='button' class='close' data-dismiss='alert'><i class='icon-remove'></i></button><strong><i class='ace-icon fa fa-times'></i> MAAF! </strong>" .mysql_error()."<br/></div>";
}
}

// ================ DATA FORM ( POST ) =====================//
$display = "style='display: none'"; //default = formnya dihidden
$tb_act = isset($_POST['tb_act']) ? $_POST['tb_act'] : NULL; //ambil variabel POST value Tombol FOrm
$p_id = isset($_POST['id']) ? $_POST['id'] : NULL; //ambil variabel POST id
$p_kategori = isset($_POST['kategori']) ? $_POST['kategori'] : NULL; //ambil variabel POST kategori
$p_rak = isset($_POST['rak']) ? $_POST['rak'] : NULL; //ambil variabel POST kategori


if ($tb_act == "Tambah") {
$display = "style='display: none'";
$q_tambah_bagian = mysql_query("INSERT INTO perpus_kategori VALUES ('', '$p_kategori','$p_rak')");
if ($q_tambah_bagian) {
echo "<div class='alert alert-block alert-success'><button type='button' class='close' data-dismiss='alert'><i class=''></i></button><strong><i class='ace-icon fa fa-check'></i> BERHASIL</strong> Data Kategori Buku Berhasil di simpan<br/></div>";
} else {
echo "<div class='alert alert-danger'><button type='button' class='close' data-dismiss='alert'><i class='icon-remove'></i></button><strong><i class='ace-icon fa fa-times'></i> MAAF! </strong>" .mysql_error()."<br/></div>";
}
} else if ($tb_act == "Edit") {
$display = "style='display: none'";
$q_edit_bagian = mysql_query("UPDATE perpus_kategori SET kategori = '$p_kategori', rak = '$p_rak' WHERE id = '$p_id'");
if ($q_edit_bagian) {
echo "<div class='alert alert-block alert-success'><button type='button' class='close' data-dismiss='alert'><i class='icon-remove'></i></button><strong><i class='ace-icon fa fa-check'></i> BERHASIL</strong> Data Kategori Buku Berhasil di update<br/></div>";
} else {
echo "<div class='alert alert-danger'><button type='button' class='close' data-dismiss='alert'><i class='icon-remove'></i></button><strong><i class='ace-icon fa fa-times'></i> MAAF! </strong>" .mysql_error()."<br/></div>";
}
} else {
$display = "style='display: none'";
}
?>

<div class="module_content">
<h5><a data-toggle="modal" href="?page=SISBO-Pengaturan Perpustakaan&mod=add" class="btn btn-primary" >Tambah Data</a></h5>

<?php
// ================ TAMPILKAN DATANYA =====================//
echo "
<class='ibox-content'>
<table id='sample-table-2' class='table table-striped table-bordered table-hover dataTables-example'>
<thead>
<tr>
<th width='5%'>No</th>
<th width='60%'>Kategori</th>
<th width='28%'>Rak Buku</th>
<th width='7%'>Aksi</th>
</tr>
</thead>
<tbody>";
$q_bagian = mysql_query("SELECT * FROM perpus_kategori ORDER BY id ASC") or die (mysql_error());
$j_data = mysql_num_rows($q_bagian);

if ($j_data == 0) {
echo "<tr>
<td id='tengah' colspan='3'>-- Tidak Ada Data --</td>
</tr>";
} else {
$no = 1;
while ($a_bagian = mysql_fetch_array($q_bagian)) {
echo "<tr>
<td id='tengah'>$no</td>
<td>$a_bagian[1]</td>
<td>$a_bagian[2]</td>
<td id='tengah'>
<a data-toggle='modal' href='?page=SISBO-Pengaturan Perpustakaan&mod=edit&idbag=$a_bagian[0]'>
<span class='blue'><i class='ace-icon fa fa-pencil-square-o bigger-120' title='Edit'></i></span>
</a>
|
<a href='?page=SISBO-Pengaturan Perpustakaan&mod=del&idbag=$a_bagian[0]' onclick='return confirm(\"Yakin Hapus Kategori Buku Ini...?\");'><span class='red'><i class='ace-icon fa fa-trash-o bigger-120' title='Hapus'></i></span></a>
</td>
</tr>";
$no++;
}
}
echo "</table> </tbody>";
?>

</div>

<?php
// ================ DATA URL "mod" ( GET ) =====================//

if ($mod == "edit") {
$display = "";
$q_edit_bag = mysql_query("SELECT * FROM perpus_kategori WHERE id = '$id'");
$a_edit_bag = mysql_fetch_array($q_edit_bag);

$kategori = $a_edit_bag[1];
$view = "Edit";

} else if ($mod == "add") {
$display = "";
$id = "";
$kategori = "";
$view = "Tambah";
} else {
$display = "style='display: none'";
}

?>

<div class="module width_full" <?php echo $display;?>>


<header><h3 class="header smaller lighter blue"><?php echo $view;?> Data Kategori Buku</h3></header>
<div class="module_content">

<form action="?page=SISBO-Pengaturan Perpustakaan&mod=add" method="post">
<table class="tbl_form">
<tr><td>ID</td>
<td><div class="col-md-6"><input class="form-control" name="id" readonly value="<?php echo $id; ?>"></div></td>

<tr><td>Kategori</td> <td><div class="col-md-12"><input class="form-control" name="kategori" value="<?php echo $kategori; ?>"></div></td></tr>
<tr><td>Lokasi Rak Buku</td> <td><div class="col-md-10"><input class="form-control" name="rak" value="<?php echo $rak; ?>"></div></td></tr>
<tr height="10"><td></td></tr>
<tr><td></td><td><div>&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" class="btn btn-primary" name="tb_act" value="<?php echo $view; ?>"></div></td></tr>

</table>
</form>


</div>
</div>