במ12[cvbnvbnvcvbcvbcvbvvvccccccccccccccvbcvbcvbnmnmqewv;'

]]jkjjgdjffksdkdxmnvbcbcvbvcbbbbbbbbbvcbcbvcbmnmbnwqeqwewqskfgj במ12[cvbnvbnvcvbcvbcvbvvvccccccccccccccvbcvbcvbnmnmqewv;'

<?php
require('inc/header.php');
$limit = 9;
$page = isset($_GET['page']) ? $_GET['page'] : 1; 
$start = ($page - 1) * $limit;

$pr = "SELECT * FROM product ORDER BY id DESC LIMIT $start, $limit";
$exe = mysqli_query($conn,$pr);
$count = mysqli_num_rows($exe);
?>
<style>
    .pagination{
        gap:0.5rem;
    }
    ul.pagination li a.selected {
    background-color: #0d9b4d;
    color: #fff;
    border: 1px solid #0d9b4d;
}
</style>
    
    <div class="search-popup-wrap" tabindex="-1" role="dialog" aria-hidden="true">
        <div class="search-wrap text-center">
            <div class="container">
                <div class="row">
                    <div class="col-12">
                        <div class="search-form">
                            <form method="get" action="">
                                <input type="text" name="s" value="" placeholder="Enter your keyword..." required>
                                <button class="search-btn"><i class="flaticon-search"></i></button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="search-backdrop"></div>

</header>

<div class="offCanvas-wrap">
    <div class="offCanvas-toggle">
        <img src="../wp-content/themes/suxnix/assets/img/icons/close.png" alt="icon">
    </div>
    <div class="offCanvas-body">
        <div class="offCanvas-content">
            <h3 class="title">Getting all of the <span>Nutrients</span> you need simply cannot be done without supplements.</h3>
            <p>Nam libero tempore, cum soluta nobis eligendi cumque quod placeat facere possimus assumenda omnis dolor repellendu sautem temporibus officiis</p>
        </div>
        <div class="offcanvas-contact">
            <h4 class="number">+1 599 162 4545</h4>
            <h4 class="email">Vitaminsforus@gmail.com</h4>
            <p>5689 Lotaso Terrace, Culver City, <br> CA, United States</p>

</div>
    </div>
</div>
<div class="offCanvas-overlay"></div>

<main class="main-area fix">

</nav>
                        </div>
                    </div>
                                    </div>
            </div>
            <div class="video-shape one"><img src="../wp-content/themes/suxnix/assets/img/others/video_shape01.png" alt="shape"></div>
            <div class="video-shape two"><img src="../wp-content/themes/suxnix/assets/img/others/video_shape02.png" alt="shape"></div>
        </section>

<div class="shop-top-wrap">
		<div class="row">
			<div class="col-md-6">
				<div class="shop-top-left">
					<div class="woocommerce-notices-wrapper"></div><p>
	Showing <span><?php echo $count?></span> results</p>
				</div>
			</div>
			<div class="col-md-6">
				<div class="shop-top-right">
					<form class="woocommerce-ordering" method="get">
	<select name="orderby" class="orderby" aria-label="Shop order">
					<option value="menu_order"  selected='selected'>Default sorting</option>
					<option value="popularity" >Sort by popularity</option>
					<option value="rating" >Sort by average rating</option>
					<option value="date" >Sort by latest</option>
					<option value="price" >Sort by price: low to high</option>
					<option value="price-desc" >Sort by price: high to low</option>
			</select>
	<input type="hidden" name="paged" value="1" />
	</form>
				</div>
			</div>
		</div>
   </div>
	<div class="row row-cols-xl-3 row-cols-lg-3 row-cols-md-2 row-cols-1">
	    
	     
	     
	     <?php
	     
	     if($count > 0){
	         while($row = mysqli_fetch_assoc($exe)){
	     ?>
	    
<div class="col">
    <div class="suxnix-product-main">
	   <div class="home-shop-item inner-shop-item">
           <div class="home-shop-thumb">

<a href="shopdetails.php?id=<?php echo $row['id']?>" style="text-align: center;display: flex;">
            <img src="admin/uploads/<?php echo $row['pr_img']?>" sizes="(max-width: 605px) 100vw, 605px" style="width: 120px;" /></a>
                
                <div class="on-sale-wrap"></div>

</div>

<div class="home-shop-content">
                                <div class="shop-item-cat">
                   <a href="category_product.php?cat=<?php echo $row['pr_cat']?>"><?php echo $row['pr_cat']?></a>            </div>
                <h4 class="title">
                    <a href="shopdetails.php?id=<?php echo $row['id']?>"><?php echo $row['pr_nm']?></a>
                </h4>
                <div class="home-shop-price">
                <?php
                if($row['sale_price'] != 0){
                ?>    
	<span class="price"><span class="woocommerce-Price-amount amount"><bdi><span class="woocommerce-Price-currencySymbol">&#36;</span><?php echo $row['sale_price'];?></bdi></span></span>
	           <?php } else{?>
	           <span class="price"><span class="woocommerce-Price-amount amount"><bdi><span class="woocommerce-Price-currencySymbol">&#36;</span><?php echo $row['pr_price'];?></bdi></span></span>
	           <?php } ?>
                </div>
                <div class="home-shop-rating">
                    <div class="details-rating shop-single-rating" title="Rating 5.00 out of 5"><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="fas fa-star"></i><span class="rating-count">( 5.00 out of 5 )</span></div>                </div>
                <div class="shop-content-bottom">
                    
                                 <?php
                                  if($row['sale_price'] != 0){
                                      $price = $row['sale_price'];
                                  }
                                  else{
                                      $price = $row['pr_price'];
                                  }
                                  ?>
                                  
                                           <form method="POST" action="manage_cart.php">
    											
    											<input type="hidden" name="item_id" value="<?php echo $row['id'];?>">
                                                <input type="hidden" name="item_image" value="<?php echo $row['pr_img'];?>">
                                                <input type="hidden" name="item_name" value="<?php echo $row['pr_nm'];?>">
                                                <input type="hidden" name="item_price" value="<?php echo $price;?>">
                                                <input type="hidden" name="item_qty" value="1">
                                                <input type="hidden" name="item_cat" value="<?php echo $row['pr_cat']?>">
                                                <button type="submit" style="border:none" class="add-cart-btn cart-button icon-btn product_type_simple add_to_cart_button ajax_add_to_cart" name="add_cart"><i style="font-size:25px" class="flaticon-shopping-cart-1"></i></button>
                                            </form>
                    
                    
                    
                    <form method="POST" action="checkout.php">
                        <input type="hidden" value="<?php echo $row['id'];?>" name="itm_id">
                        <input type="hidden" value="<?php echo $row['pr_nm'];?>" name="itm_nm">
                        <input type="hidden" value="<?php echo $price;?>" name="itm_price">
                        <input type="submit" class="btn btn-two" name="buy" value="Buy Now">
                    </form>
                    
                </div>
            </div>

</div>
        <div class="tinv-wraper woocommerce tinv-wishlist tinvwl-after-add-to-cart tinvwl-loop-button-wrapper tinvwl-woocommerce_after_shop_loop_item"
	 data-tinvwl_product_id="80">
	<div class="tinv-wishlist-clear"></div><a role="button" tabindex="0" name="add-to-wishlist" aria-label="Add to Wishlist" class="tinvwl_add_to_wishlist_button tinvwl-icon-heart  tinvwl-position-after tinvwl-loop" data-tinv-wl-list="[]" data-tinv-wl-product="80" data-tinv-wl-productvariation="0" data-tinv-wl-productvariations="[0]" data-tinv-wl-producttype="simple" data-tinv-wl-action="add"><span class="tinvwl_add_to_wishlist-text">Add to Wishlist</span></a><div class="tinv-wishlist-clear"></div>		<div
		class="tinvwl-tooltip">Add to Wishlist</div>
</div>
</div>
</div>

<?php } }?>
 
</div>

<?php
// Pagination links
$query = "SELECT COUNT(*) AS count FROM product";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$total_records = $row['count'];
$total_pages = ceil($total_records / $limit);

$previous_page = $page - 1;
$next_page = $page + 1;

echo "<ul class='pagination'>";
if ($page > 1) {
    echo "<li><a href='?page=$previous_page'>Previous</a></li>";
}
for ($i = 1; $i <= $total_pages; $i++) {
    if ($i == $page) {
        echo "<li><a href='?page=$i' class='selected'>$i</a></li>";
    } else {
        echo "<li><a href='?page=$i'>$i</a></li>";
    }
}
if ($page < $total_pages) {
    echo "<li><a href='?page=$next_page'>Next</a></li>";
}
echo "</ul>";
?>

</div>

<div class="col-xl-3 col-lg-4 col-md-8 col-sm-8">
   <aside class="shop-sidebar">
		<div id="woocommerce_price_filter-2" class="product-widgets side-cat woocommerce widget_price_filter"><h4 class="sidebar-title">Filter by Price</h4>
<form method="POST">
	<div class="price_slider_wrapper">
		<div class="price_slider" style="display:none;"></div>
		<div class="price_slider_amount" data-step="10">
			<label class="screen-reader-text" for="min_price">Min price</label>
			<input type="text" id="min_price" name="min_price" value="10" data-min="10" placeholder="Min price" />
			<label class="screen-reader-text" for="max_price">Max price</label>
			<input type="text" id="max_price" name="max_price" value="60" data-max="60" placeholder="Max price" />
						<button type="submit" class="button wp-element-button">Filter</button>
			<div class="price_label" style="display:none;">
				Price: <span class="from"></span> &mdash; <span class="to"></span>
			</div>
						<div class="clear"></div>
		</div>
	</div>
</form>

</div><div id="woocommerce_product_categories-2" class="product-widgets side-cat woocommerce widget_product_categories"><h4 class="sidebar-title">Product categories</h4>
<ul class="product-categories">
    
<?php
	$fetch = "SELECT DISTINCT pr_cat FROM product";
	$fetch_que = mysqli_query($conn,$fetch);
	$count = mysqli_num_rows($fetch_que);
	if($count > 0){
	    while($get_cat = mysqli_fetch_assoc($fetch_que)){
	        $catnm = $get_cat['pr_cat'];
	        $ct = "SELECT * FROM product WHERE pr_cat='$catnm'";
	        $ct_rn = mysqli_query($conn,$ct);
	        $ct_count = mysqli_num_rows($ct_rn);
	?>
<li class="cat-item cat-item-27"><a href="category_product.php?cat=<?php echo $get_cat['pr_cat'];?>"><?php echo $get_cat['pr_cat']?></a> </a> <span class="float-right"><?php echo $ct_count;?></span></span></li>
 <?php } }?>

</ul></div>

<div id="woocommerce_products-2" class="product-widgets side-cat woocommerce widget_products">
    <h4 class="sidebar-title">LATEST PRODUCTS</h4><ul class="product_list_widget">
    <?php
    $latest = "SELECT * FROM product ORDER BY id DESC LIMIT 3";
    $run_latest = mysqli_query($conn,$latest);
    $ct = mysqli_num_rows($run_latest);
    if($ct > 0){
        while($lt = mysqli_fetch_assoc($run_latest)){
    ?>    
<li>
	
	<div class="lp-post-thumb">
		<div class="product-widget-thumb-inner">
			<a href="#">
				<img width="350" height="350" src="admin/uploads/<?php echo $lt['pr_img'];?>" class="attachment-woocommerce_thumbnail size-woocommerce_thumbnail" alt="" loading="lazy" />			</a>
		</div>
	</div>

<div class="star-rating" role="img" aria-label="Rated 4.00 out of 5"><span style="width:80%">Rated <strong class="rating">4.00</strong> out of 5</span></div>		
		<h4 class="title">
			<a href="#"><?php echo $lt['pr_nm']?></a>
		</h4>
        <?php
        if($lt['sale_price'] != 0){
        ?>
		<del aria-hidden="true"><span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">&#036;</span><?php echo $lt['pr_price']?></span></del> <ins><span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">&#036;</span><?php echo $lt['sale_price']?></span></ins>	</div>
        <?php } else{?>
        <ins><span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">&#036;</span><?php echo $lt['pr_price']?></span></ins>
        <?php } ?>
	</li>
	
<?php } }?>
</ul></div>

</div>	</aside>
</div>

</div></div>
</div>

</main>

<?php
require('inc/footer.php');
?>