data06.php

<?php
# UNTUK PAGING (PEMBAGIAN HALAMAN)
$row = 20;
$hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
$pageSql = "SELECT * FROM tbl_souvenir";
$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());
$jml     = mysql_num_rows($pageQry);
$max     = ceil($jml/$row);
?>
<div class="btn-toolbar list-toolbar">
    <a href="?page=Tambah-Souvenir"><button class="btn btn-primary"><i class="fa fa-plus"></i> Tambah Barang</button></a>
    <div class="btn-group"></div>
    <br>
</div>
<div class="btn-toolbar list-toolbar">
    <form action="?page=Data-Souvenir" method="post" class="form-horizontal" role="form">
    <div class="col-lg-3 col-md-2">
        <input type="text" class="form-control form-cascade-control" name="qcari" value="">
    </div>
        <input type="submit" class="btn btn-primary" name="cari" value="Cari">
    </form>
</div>
<table class="table table-hover table-stripped">
    <thead>
        <tr>
            <th>No</th>
            <th>Nama Barang</th>
            <th>Stok</th>
            <th>Gambar</th>
            <th>&nbsp;</th>
        </tr>
    </thead>
     <?php
        if(isset($_POST['cari'])){
            $qcari=$_POST['qcari'];
            $userSql="SELECT * FROM  tbl_souvenir
            where nm_souvenir like '%$qcari%'";
        }

        $userSql = "SELECT * FROM tbl_souvenir ORDER BY nm_souvenir ASC LIMIT $hal, $row";
        $userQry = mysql_query($userSql, $koneksidb)  or die ("Query souvenir salah : ".mysql_error());
        $nomor  = 0;
        while ($userRow = mysql_fetch_array($userQry)) {
        $nomor++;
        $Kode = $userRow['id_souvenir'];
    ?>
    <tbody>
        <tr>
            <td><?php echo $nomor; ?></td>
            <td><?php echo $userRow['nm_souvenir']; ?></td>
            <td><?php echo $userRow['stok']; ?></td>
            <td><a class="fancybox" href='<?php echo $base_url;?>assets/images/souvenir/<?php echo $userRow['gambar']; ?>' title="<?php echo $userRow['ket']; ?>" data-fancybox-group="gallery" >
            <img src="<?php echo $base_url;?>assets/images/souvenir/<?php echo $userRow['gambar']; ?>" width="50" class="img-responsive"></a></td>
            <td><a href="?page=Edit-Souvenir&amp;Kode=<?php echo $Kode; ?>" target="_self" title="Edit Souvenir"><i class="fa fa-pencil"></i></a></td>
        </tr>
    </tbody>
    <?php
        }
    ?>
</table>
<ul class="pagination">
<?php
    for ($h = 1; $h <= $max; $h++) {
        $list[$h] = $row * $h - $row;
        echo " <li><a href='?page=Data-Souvenir&hal=$list[$h]'>$h</a></li> ";
    }
?>

</ul>