| Server IP : 162.0.232.25 / Your IP : 3.147.103.33 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/bm1holdings-ltd.com/ |
Upload File : |
<?php
include './header.php';
include './assets/php/connect.php';
include './assets/php/filterFile.php';
?>
<div class="breadcrumbs">
<div class="container">
<div class="row">
<div class="col-12">
<div class="bread-inner">
<ul class="bread-list">
<li><a href="home">Home<i class="ti-arrow-right"></i></a></li>
<li class="active"><a href="team">Search</a></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<?php
if (isset($_POST['submit'])) {
$search = $_POST['search'];
$category = $_POST['category'];
?>
<section class="shop-home-list section">
<div class="container">
<div class="row">
<?php
$query = ($category=="all") ? "SELECT * FROM `products` WHERE `product` LIKE '%$search%'" : "SELECT * FROM `products` WHERE `category`='$category' AND `product` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h6 class="text-center text-primary my-1">RESULTS: <?php echo $count; ?></h6>
</div>
<?php
while ($row = mysqli_fetch_array($run)) {
?>
<div class="col-lg-4 col-md-6 col-12" data-aos="flip-up" data-aos-duration="600" data-aos-delay="50">
<div class="single-list">
<div class="row">
<div class="col-lg-6 col-md-6 col-12">
<div class="list-image overlay">
<img src="assets/products/<?php echo $row['image']; ?>" alt="#">
<a href="product=<?php echo filter_file($row['pid'] . '-' . $row['product']); ?>" class="buy"><i class="fa fa-shopping-bag"></i></a>
</div>
</div>
<div class="col-lg-6 col-md-6 col-12 no-padding">
<div class="content">
<h4 class="title"><a href="product=<?php echo filter_file($row['pid'] . '-' . $row['product']); ?>"><?php echo $row['product']; ?></a></h4>
<div class="product-rate">
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="far fa-star"></i>
</div>
<p class="price with-discount">K<?php echo $row['discount']; ?></p>
</div>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
</section>
<?php
}
include './footer.php';
include './scripts.php';
?>
<script>
document.querySelector("title").innerText = "BM 1 HOLDINGS LTD - SEARCH";
</script>