MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.83
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0750) :  /home2/imyrqtmy/public_html/opulanceindia/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/opulanceindia/scatbycat.php
<?php 

session_start();
error_reporting(E_ERROR | E_PARSE);
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
    // header("Location: login.php");
}
include("admin/includes/config.php");;
 

   if(isset($_POST['add_to_cart']))
   {
       $product_name  = $_POST['product_name'];
       $price   = $_POST['price'];
       $photo  = $_POST['photo'];
   
       $product_quantity = 1;
       $select_cart = mysqli_query($conn,"select * from `cart` where name='$product_name'");

       if (mysqli_num_rows($select_cart) > 0) {
        echo "<script>alert('Product Already Added to Cart');</script>";
    } else {
        $query = mysqli_query($conn, "INSERT INTO cart (name, price, photo, quantity) VALUES ('$product_name','$price','$photo','$product_quantity')");
        if ($query) {
            echo "<script>alert('Product Added to Cart');</script>";
        } else {
            echo "<script>alert('Failed to Add Product to Cart');</script>";
        }
    }


   }
   ?>



<!DOCTYPE html>
<!--[if (gte IE 9)|!(IE)]><!-->
<html lang="en">
   <!--<![endif]-->
   <?php require "inc/head.php" ?>
   <body>
      <!-- =====  LODER  ===== -->
      <!-- <div class="loder"></div> -->
      <div class="wrapper">
         <!-- =====  HEADER START  ===== -->
         <?php require "inc/header.php" ?>
         <!-- =====  HEADER END  ===== --> 
         <!-- =====  BANNER STRAT  ===== -->
         <div class="breadcrumb">

            <?php
                    $category_id = $_GET['id'];
                        $category_query = "SELECT cat_name FROM categories WHERE id = $category_id";
                        $category_result = mysqli_query($conn, $category_query);

                        if (mysqli_num_rows($category_result) > 0) {
                            $category_row = mysqli_fetch_assoc($category_result);
                            $category_name = $category_row['cat_name'];
                        } else {
                            $category_name = "Unknown category"; 
                        }

                        $query = "SELECT * FROM scategories WHERE category_id = $category_id";
                        $query_run = mysqli_query($conn, $query);

                        if (mysqli_num_rows($query_run) > 0) {
                        ?>
            <h1><?php echo $category_name; ?></h1>
            <?php

    foreach ($query_run as $row) {
?>


<?php
    }
} else {
    echo "<p>No sub-category found for this category.</p>";
}
?>

            <ul>
               <li><a href="index.php">Home</a></li>

               
               <li class="active">Products</li>
            </ul>
         </div>
         <!-- =====  BREADCRUMB END===== --> 
         <!-- =====  CONTAINER START  ===== -->
         <div class="container">

        
                                            <?php
                                            if(isset($display_message)){
                                                foreach($display_message as $display_message){
                                            
                                                echo "<div class= 'display_message'>
                                                <span>$display_message</span>
                                                <i class= 'fas fs-times' onClick='this.parentElement.style.display=`none`';></i>
                                            </div>";
                                            }
                                            }
                                            ?> 
                                      
            <div class="row">

            <div id="column-right" class="col-sm-4 col-md-4 col-lg-3 ">
                  <div class="left-sidebar-widget">
                     <div class="all-category mb_50">
                        <div class="heading-part ">
                           <h2 class="sub_title pull-left">All Sub-Category</h2>
                        </div>
                        <div class="nav-responsive">
                           <ul>

                           <?php  
                            $query = "SELECT c.*, COUNT(sc.id) AS category_count 
                                        FROM categories c 
                                        LEFT JOIN scategories sc ON c.id = sc.category_id
                                        GROUP BY c.id";
                            $query_run = mysqli_query($conn, $query);

                            if($query_run) {
                                foreach($query_run as $row) {

                            ?>
                              <li><a href="scatbycat.php?id=<?php echo $row['id']; ?>"><?php echo $row['cat_name'] ?>  (<span><?php echo $row['category_count']; ?></span>)</a></li>

                              <?php }}  ?>
                           </ul>
                        </div>
                     </div>
                  
                  </div>
                 
               </div>
               <div class="col-sm-8 col-md-8 col-lg-9 mb_30">
                
                  <div class="row">

                  <?php
              
              $category = $_GET['id'];
              $query = "SELECT * FROM scategories WHERE category_id='$category'";
              $query_run =mysqli_query($conn, $query);
              if(mysqli_num_rows($query_run) > 0){
              foreach($query_run as $row){

                
          ?>


                     <form action="" method="post">
                     <div class="product-layout  product-grid  col-lg-4 col-md-4 col-xs-6 ">
                        <div class="item">
                           <div class="product-thumb clearfix mb_30">
                              <div class="image product-imageblock"> <a href="productbycat.php?id=<?php echo $row['id']; ?>"> <img data-name="product_image" src="<?php echo "admin/scategory/" . $row['photo']; ?>"  alt="iPod Classic" title="<?php echo htmlspecialchars($row['scat_name'], ENT_QUOTES, 'UTF-8'); ?>" class="img-responsive pro" /> <img src="<?php echo "admin/scategory/" . $row['photo']; ?>" alt="iPod Classic" title="<?php echo htmlspecialchars($row['scat_name'], ENT_QUOTES, 'UTF-8'); ?>" class="img-responsive pro" /> </a> </div>
                                 <div class="caption product-detail text-left">
                                    <!-- <h2 data-name="product_name" class="product-name mt_20" style="text-align:center;font-size: 18px;">
                                             <a href="productbycat.php?id=<?php echo $row['id']; ?>" title="<?php echo htmlspecialchars($row['scat_name'], ENT_QUOTES, 'UTF-8'); ?>">
                                                <?php echo mb_strimwidth($row['scat_name'], 0, 25, "..."); ?>
                                             </a>
                                          </h2>   -->
                                          <h2 data-name="product_name" class="product-name mt_20" style="text-align:center; font-size:15px;">
                                             <a href="productbycat.php?id=<?php echo $row['id']; ?>" title="<?php echo htmlspecialchars($row['scat_name'], ENT_QUOTES, 'UTF-8'); ?>" class="hover-slide">
                                                <span class="text-slide"><?php echo mb_strimwidth($row['scat_name'], 0, 30, "..."); ?></span>
                                             </a>
                                          </h2>
                                 </div>
                           </div>
                        </div>
                     </div>
                     

                     </form>

                     <?php }} ?>


                    
                  </div>
                 
               </div>
             
            </div>
         </div>
         <!-- =====  CONTAINER END  ===== --> 
         <!-- =====  FOOTER START  ===== -->
         <?php require "inc/footer.php" ?>
         <!-- =====  FOOTER END  ===== --> 
      </div>
      <a id="scrollup">Scroll</a> 
      <script src="js/jQuery_v3.1.1.min.js"></script> 
      <script src="js/owl.carousel.min.js"></script> 
      <script src="js/bootsnav.js"></script> 
      <script src="js/bootstrap.min.js"></script> 
      <script src="js/jquery.magnific-popup.js"></script> 
      <script src="js/custom.js"></script> 
      <script src="js/jquery-ui.js"></script> 
      <script>
         $(function() {
           $("#slider-range").slider({
             range: true,
             min: 0,
             max: 500,
             values: [75, 300],
             slide: function(event, ui) {
               $("#amount").val("$" + ui.values[0] + " - $" + ui.values[1]);
             }
           });
           $("#amount").val("$" + $("#slider-range").slider("values", 0) +
             " - $" + $("#slider-range").slider("values", 1));
         });
      </script>
   </body>
</html>

MMCT - 2023