allbook.php

<?php
	require_once("koneksi.php");
    include 'header.php';

    $per_hal		= 12;
	$jumlah_record	= mysqli_query($koneksi, "SELECT * FROM t_buku");
	$no 			= 1;
	$jum 			= mysqli_num_rows($jumlah_record);
	$halaman 		= ceil($jum / $per_hal);
	$page 			= (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
	$start 			= ($page - 1) * $per_hal;
	
    global $sql;
	$sql = mysqli_query($koneksi, "SELECT * FROM t_buku ORDER BY isbn ASC LIMIT $start, $per_hal");
?>
	<!-- breadcrumbs -->
		<div class="breadcrumbs">
			<div class="container">
				<ol class="breadcrumb breadcrumb1 animated wow slideInLeft" data-wow-delay=".5s">
					<?php
	                if (isset($_SESSION['pengunjung'])) {
					    echo '
						<li><span><i class="fa fa-sign-in" aria-hidden="true"></i><a href="login.php"> Masuk</a></span></li>
						<li class="active">Daftar Buku</li> ';
					}
					else {
						echo '
						<li><a href="index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span>Beranda</a></li>
						<li class="active">Daftar Buku</li> ';
					}
				?>
				</ol>
					<?php 
						if(isset($_POST['cari'])){
							$cari 	= $_POST['search'];
							$sql 	= mysqli_query($koneksi, "SELECT * FROM t_buku WHERE judul LIKE '%$cari%' ORDER BY isbn");
						}
					?>
				<div class="w3l_search">
					<form action="" method="post">
						<input type="search" name="search" placeholder="Cari Judul Buku" required="">
						<button type="submit" class="btn btn-default search" aria-label="Left Align" name="cari">
							<i class="fa fa-search" aria-hidden="true"> </i>
						</button>
						<div class="clearfix"></div>
					</form>
				</div>
			</div>
		</div>
	<!-- //breadcrumbs -->
	<!-- gourmet -->
		<div class="products">
			<div class="container">
					<div class="agile_top_brands_grids">
						<?php
							while($data = mysqli_fetch_array($sql)){
						?>
						<div class="col-md-3 top_brand_left">
							<div class="hover14 column">
								<div class="agile_top_brand_left_grid">
								<?php 
									if ($data['keterangan'] != 1) {
										echo '<div class="agile_top_brand_left_grid_pos">
												<img src="images/offer.png" alt=" " class="img-responsive">
											</div>';
										}
								?>
									<div class="agile_top_brand_left_grid1">
										<figure>
											<div class="snipcart-item block" >
												<div class="snipcart-thumb">	
													<a href="singlebook.php?kd=<?php echo $data['isbn'];?>"><img class="col-md-12" title="Klik Disini" src="<?php echo $data['gambar']; ?>" >
													<center><h4><?php echo $data['judul']; ?></h4></center>
													<center><h4><?php echo $data['pengarang']; ?></h4></center>
													<center><h4><?php echo $data['tahun']; ?></h4></center>
													<center><h4>Rp.<?php echo number_format($data['harga'],2,",",".");?></h4></center>
													</a>
												</div>
												<div class="snipcart-details top_brand_home_details">
													<a href="function.php?act=add&amp;barang_id=<?php echo $data['isbn']; ?>&amp;ref=checkout.php?kd=<?php echo $data['isbn'];?>" >
													<input type="submit" name="simpan" value="Pesan" class="button" /></a>
												</div>
											</div>
										</figure>
									</div>
								</div>
							</div>
							<br>	
						</div>
						<?php   
				      			}
				      	?>
						<div class="clearfix"> </div>
					</div>
				<nav class="numbering">
					<div class="pagination paging">
							<?php 
								for($page=1;$page<=$halaman;$page++){
							?>
							<li><a href="?page=<?php echo $page ?>"><?php echo $page ?></a></li>
							<?php
								}
							?>
					</div>
				</nav>
			</div>
		</div>
	<!-- gourmet -->

<?php
	include 'footer.php';
?>