categories.php

<?php
	require_once("koneksi.php");
    include 'header.php';
    global $sql;
	$id  = $_GET['kd'];
	$sql = mysqli_query($koneksi, "SELECT * FROM t_buku WHERE kategori='$id' ORDER BY isbn");
?>

<!-- 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 Kategori</li> ';
					}
					else {
						echo '
						<li><a href="index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span>Beranda</a></li>
						<li class="active">Daftar Kategori</li> ';
					}
				?>
			</ol>
				<?php 
					if(isset($_POST['cari'])) {
						$cari = $_POST['search'];
						$sql  = mysqli_query($koneksi, "SELECT * FROM t_buku WHERE judul LIKE '%$cari%' ORDER BY kategori");
					}
				?>
			<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 -->
<!-- groceries -->
	<div class="products">
		<div class="container">
			<div class="col-md-4 products-left">
				<div class="categories">
					<h2>KATEGORI</h2>
					<ul class="cate">
					<?php
						$kategori   = mysqli_query($koneksi, "SELECT * FROM t_kategori ORDER BY id_kategori");
						while($data = mysqli_fetch_array($kategori)) {
					?>
						<li><a href="categories.php?kd=<?php echo $data['id_kategori'];?>"><i class="fa fa-arrow-right" aria-hidden="true"></i><?php echo $data['nama_kategori']; ?></a></li>
					<?php   
			      		}
			      	?>
					</ul>
				</div>																																												
			</div>
			<div class="col-md-8 products-right">
				<div class="agile_top_brands_grids">
						<?php

							while($data = mysqli_fetch_array($sql)) {
						?>
						<div class="col-md-4 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><h5><?php echo $data['judul']; ?></h5></center>
														<center><h5><?php echo $data['pengarang']; ?></h5></center>
														<center><h5><?php echo $data['tahun']; ?></h5></center>
														<center><h5>Rp.<?php echo number_format($data['harga'],2,",",".");?></h5></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>
			</div>
			<div class="clearfix"> </div>
		</div>
	</div>
<!-- groceries -->

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