<div class="">
<div class="page-title">
<div class="title_right">
<div class="col-md-12 col-sm-12 col-xs-12 form-group pull-right top_search">
<div class="input-group">
<input type="text" class="form-control" placeholder="Search for...">
<span class="input-group-btn">
<button class="btn btn-default" type="button">Go!</button>
</span>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>

<div class="row">

<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="title_left">
<h3>
Data Barang

</h3>
</div>

<ul class="nav navbar-right panel_toolbox">
<li><a href ="?page=tambahbarang"><span class="glyphicon glyphicon-plus" alt="Tambah Barang" aria-hidden="true" ></span></a>
</li>
</ul>
<div class="clearfix"></div>

<div class="x_content">
<?php
require("../config/kon.php");
$baris = 20;
$hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
$pageSql = "Select stok,nama ,ukuran, kode,nama_kategori,harga,gambar from stok join barang on stok.id_barang=barang.id_barang join kategori on barang.id_kategori=kategori.id_kategori ";
$pageQry = mysql_query($pageSql) or die("Query Gagal".mysql_error());
$jumlah = mysql_num_rows($pageQry);
$maksData= ceil($jumlah/$baris);
?>
<table id="example" class="table table-striped responsive-utilities jambo_table">
<thead>
<tr class="headings">
<th>No </th>
<th>Kode </th>
<th>Nama Produk </th>
<th>Ukuran</th>
<th>Stok</th>
<th>Nama Kategori </th>
<th> Harga </th>
<th> Gambar </th>
<th colspan="2" class=" no-link last"><span align="" class="nobr">Action</span>
</th>
</tr>
</thead>
<?php
$mySql = "Select stok,nama, ukuran, kode,nama_kategori,harga,gambar from stok join barang on stok.id_barang=barang.id_barang join kategori on barang.id_kategori=kategori.id_kategori order by kode desc LIMIT $hal, $baris ";
$myQry = mysql_query($mySql) or die ("Query salah : ".mysql_error());
$nomor = $hal;

while($data=mysql_fetch_array($myQry)){
$nomor++;
$kode = $data['kode'];
?>
<tbody>
<tr class="even pointer">
<td ><?php echo $nomor; ?></td>
<td class=" "><?php echo $data['kode']; ?></td>
<td class=" "><?php echo $data['nama']; ?></td>
<td class=" "><?php echo $data['ukuran']; ?></td>
<td class=" "><?php echo $data['stok']; ?></td>
<td class=" "><?php echo $data['nama_kategori']; ?></td>
<td class=" "><?php echo $data['harga']; ?></td>
<td class=" "><img width = "100" height = "100" ></td>
<td class=" last"><a href = '?page=editbarang&kode=<?php echo $kode; ?>'><span class="glyphicon glyphicon-edit" aria-hidden="true"></span></a></td>
<td class=" last"><a href = '?page=deletebarang&kode=<?php echo $kode; ?>'><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a></td>
</tr>
</tbody>
<?php } ?>
</table>
Jumlah Data : <?php echo $jumlah; ?>
Halaman ke :
<?php
for ($h = 1; $h <= $maksData; $h++) {
$list[$h] = $baris * $h - $baris;
echo " <a href='?page=barang&hal=$list[$h]'>$h</a> ";
}
?></div>
</div>
</div>
</div>
</div>