searchresults.php

<?php
	session_start();
	require_once "config/connect.php";
	include 'inc/header.php';
	include 'inc/nav.php';
?>

<div class="close-btn fa fa-times"></div>

<!-- SHOP CONTENT -->
<section id="content"  style="background: #ffffff">
	<div class="content-blog">
		<div class="container">
			<div class="row">
				<!-- <div class="page_header text-center">
					<h2>Shop</h2>
					<p>You can order products from here</p>
				</div> -->
				<div class="col-md-12">
					<div class="row">
						<div id="shop-mason" class="shop-mason-4col">

							<?php
								$sql = "SELECT * FROM products";
								if(isset($_GET['search']) & !empty($_GET['search'])){
									$search = $_GET['search'];
									$sql .= " WHERE name LIKE '%$search%'";
								}
                                $res = mysqli_query($connection, $sql);
                                $result_count = 0;
								while($r = mysqli_fetch_assoc($res)){
                                    $result_count++;
							?>
							<div class="sm-item isotope-item" style="box-sizing:border-box;	width:280px; height:400px; background-color: #fff;">
								<div class="product">
									<div class="product-thumb">
										<img src="admin/<?php echo $r['thumb']; ?>" class="img-responsive" alt="">
										<div class="product-overlay">
											<span>
												<a href="single.php?id=<?php echo $r['id']; ?>" class="fa fa-link"></a>
												<a href="addtocart.php?id=<?php echo $r['id']; ?>" class="fa fa-shopping-cart"></a>
											</span>
										</div>
									</div>
									<div class="rating">
										<span class="fa fa-star act"></span>
										<span class="fa fa-star act"></span>
										<span class="fa fa-star act"></span>
										<span class="fa fa-star act"></span>
										<span class="fa fa-star act"></span>
									</div>
									<h2 class="product-title"><a href="single.php?id=<?php echo $r['id']; ?>">
											<?php echo $r['name']; ?></a></h2>
									<div class="product-price">
										<?php echo $r['price']; ?> BDT</div>
								</div>
							</div>
                            <?php }
                            if($result_count == 0) { ?>
                                <div class="no-results">
                                    <h2 style="text-align: center;">Nothing Found!</h2>
                                </div>
                            <?php } ?>

						</div>
					</div>
					<div class="clearfix"></div>
					<!-- Pagination -->
					<div class="page_nav">
						<a href=""><i class="fa fa-angle-left"></i></a>
						<a href="" class="active">1</a>
						<a href="">2</a>
						<a href="">3</a>
						<a class="no-active">...</a>
						<a href="">9</a>
						<a href=""><i class="fa fa-angle-right"></i></a>
					</div>
					<!-- End Pagination -->
				</div>
			</div>
		</div>
	</div>
</section>

<div class="clearfix space70"></div>
<div class="clearfix space70"></div>
<div class="clearfix space20"></div>

<?php include 'inc/footer.php' ?>