/
barang.php
65 lines (59 loc) · 2.23 KB
/
barang.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
include_once "library/inc.connection.php";
include_once "library/inc.library.php";
#nomor halaman (paging)
$baris = 10;
$hal = isset($_GET['hal']) ? $_GET['hal'] : 1;
$pageSql = "select * from barang";
$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging".mysql_error());
$jml = mysql_num_rows($pageQry);
$maks = ceil($jml/$baris);
$mulai = $baris * ($hal-1);
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tbody>
<tr>
<td colspan="2" align="center" bgcolor="#cccccc">KOLEKSI BARANG</td>
</tr>
<?php
//menampilkan daftar barang
$barangSql = "select barang.*, kategori.nm_kategori from barang left join kategori on barang.kd_kategori = kategori.kd_kategori order by barang.kd_barang asc limit $mulai, $baris";
$barangQry = mysql_query($barangSql, $koneksidb) or die ("Gagal Query".mysql_error());
$nomor = 0;
while ($barangData = mysql_fetch_array($barangQry)) {
$nomor++;
$KodeBarang = $barangData['kd_barang'];
$KodeKategori = $barangData['kd_kategori'];
// Membaca file gambar
if ($barangData['file_gambar']=="") {
$fileGambar = "noimage.jpg";
}
else {
$fileGambar = $barangData['file_gambar'];
}
?>
<tr>
<td width="24%"><a href="?open=Barang-Lihat&Kode=<?php echo $KodeBarang; ?>"><img src="img-barang/<?php echo $fileGambar; ?>" width="100" border="0"> </a> <br>
<div class='harga'>Rp. <?php echo format_angka($barangData['harga_jual']); ?> </div><br>
<a href="?open=Barang-Beli&Kode=<?php echo $KodeBarang; ?>" class="button orange small"> <strong>Beli</strong></a> </td>
<td width="76%">
<a href="?open=Barang-Lihat&Kode=<?php echo $KodeBarang; ?>">
<div class='judul'> <?php echo $barangData['nm_barang']; ?> </div>
</a>
<p><?php echo substr($barangData['keterangan'], 0, 200); ?> ....</p>
<p><strong>Stok :</strong> <?php echo $barangData['stok']; ?> </p>
<strong>Kategori :</strong> <a href="?open=Kategori-Barang&Kode=<?php echo $KodeKategori; ?>"> <?php echo $barangData['nm_kategori']; ?> </a> </td>
</tr>
<?php } ?>
<tr>
<td colspan="2" align="center" bgcolor="#F5F5F5">
<b>Halaman:
<?php
for ($h = 1; $h <= $maks; $h++) {
echo "[ <a href='?hal=$h'>$h</a> ]";
}
?>
</b></td>
</tr>
</tbody>
</table>