Field
|
Jenis
|
Kosong
|
Default
|
Kode_Alat
|
int(10)
|
Ya
|
|
Nama_Alat
|
varchar(50)
|
Ya
|
|
Kode_Lab
|
varchar(40)
|
Ya
|
|
Nama_Lab
|
varchar(50)
|
Ya
|
|
Tgl_Masuk
|
date
|
Ya
|
|
Tgl_Pengajuan
|
date
|
Ya
|
|
Tgl_Penghapusan
|
date
|
Ya
|
|
Type
|
varchar(10)
|
Ya
|
|
Spesifikasi
|
varchar(50)
|
Ya
|
|
Jumlah
|
varchar(50)
|
Ya
|
|
Ket
|
varchar(100)
|
Ya
|
|
Foto
|
blob
|
Ya
|
Source code php
<?php
include("include/fungsi_del.php");
if ($_GET['act']=="del") hapus_alat();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style title="currentStyle" type="text/css">
@import "javascript/css/demo_page.css";
@import "javascript/css/demo_table.css";
</style>
<script language="javascript" src="javascript/js/jquery.js" type="text/javascript">
</script>
<script language="javascript" src="javascript/js/jquery.dataTables.js" type="text/javascript">
</script>
<script charset="utf-8" type="text/javascript">
$(document).ready(function() {
$('#example').dataTable({
"sPaginationType": "full_numbers"
});
} );
</script>
</head>
<body id="dt-example">
<table width="100%" border="0" bgcolor="#CCCCCC" class="display" id="example">
<thead>
<tr>
<th colspan="8" align="left" valign="top"><a href="admin_home.php?page=13">+Tambah Data Alat
<!--Tambah Data Barang -->
</a> </th>
</tr>
<tr>
<th width="5">N0</th>
<th>Kode Alat</th>
<th>Nama Alat</th>
<th>Kode_Lab</th>
<th>Nama_Lab</th>
<th>Spesifikasi</th>
<th>Foto</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
include"include/koneksi.php";
$tampil=mysql_query("select*from tbl_alat order by Kode_Alat");
$no=$posisi+1;
while($data=mysql_fetch_array($tampil)){
echo"<tr class='odd gradeU'>
<td valign='top'>$no</td>
<td valign='top'>$data[Kode_Alat]</td>
<td valign='top'>$data[Nama_Alat]</td>
<td valign='top'>$data[Kode_Lab]</td>
<td valign='top'>$data[Nama_Lab]</td>
<td valign='top'>$data[Spesifikasi]</td>
<td><a href=\"foto_alat.php?Kode_Alat=$data[Kode_Alat]\"target=\"_blank\"><img src='foto_alat/$data[Foto]' title='$data[Nama_Alat]' width='50' height='50'><a></td>
<td align='center' valign='center' class='style22'><a href=\"detail_alat.php?Kode_Alat=$data[Kode_Alat]\" target=\"_blank\"><img src='images/detail.png' title='Detail rincian data alat' width='20' height='20'></a>
<a href=\"detail_alat.php?Kode_Alat=$data[Kode_Alat]\" target=\"_blank\"><img src='images/edit.png' title='Edit data alat' width='25' height='25'></a>
<a href=\"admin_home.php?page=6&act=del&Kode_Alat=$data[Kode_Alat]\"><img src='images/delete.png' title='Hapus rincian data alat' width='20' height='20' onClick=\"return confirm('Apakah anda akan menghapus $data->Nama_Alat?')\"></a>
</td>
</tr>";
$no++;
}
?>
</tbody>
</table>
</body>
</html>
Hasil Tampilan
TA
BalasHapus