File Explorer

<?php 
session_start();
include("includes/db_config.php");
?>
<!DOCTYPE html> 
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content=" ">
    <meta name="author" content="">
   <title>Dr.Sadia Formulations</title>
    <?php include("includes/css.php");?>
</head>

<div class="page-title-wrap">
        <div class="page-title-wrap-inner" style="background-image: url(https://www.drsadiaformulations.com/img/pg-title.jpg);">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 text-center">
                        <div class="breadcrumb text-center">
                            <ul>
                                <li><a href="https://www.drsadiaformulations.com/">Home</a> </li>
                                <li><span class="mdi mdi-chevron-right"></span></li>
                                <li><a href="#">Products</a></li> 
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <section class="shop-list section-padding">
        <div class="container">
            <div class="row">
                <?php
if (isset($_GET['martsearch'])) {
 $martsearch =($_GET['martsearch']); 
$sql="select sub_category.sub_category_name,sub_category.id as scid,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.id as ss_id,sub_sub_category.sub_sub_cat_banner,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
$result = mysqli_query($conn, $sql);
$res_prdd= mysqli_fetch_array($result);
?> 
                <div class="col-md-2" style="padding-right:0;">
                    <div id="accordion" class="shop-filters ">
                        
                       <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <button class="btn btn-link collapsed">
                                    <?php echo $res_prdd['sub_sub_cat_name']; ?> <span class="mdi mdi-chevron-down float-right"></span> </button>
                                </h5>
                            </div> 
                                <div class="card-body card-shop-filters">
                                    <ul id="f1" class="checkboxes_list">
                                    <?php $ssc_id=$res_prdd['ss_id'];
                                           $sc_id=$res_prdd['scid'];
                                    $sql_scat="select sub_sub_category.* from sub_sub_category where sub_sub_category.id !='".$ssc_id."' and sub_category_id='".$sc_id."'";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){ ?>
                                         <a href="product.php?id=<?php echo $res_scat['id']; ?>"> <li class="custom-control">
                                            <label><?php echo $res_scat['sub_sub_cat_name']; ?></label>
                                        </li></a>
                                    <?php } ?>
                                       
                                    </ul>
                                </div>
                            </div>
                    </div>
                </div>

<div class="col-md-10"> 
                    <div class="shop-head mb-3">
                       
                        <h5 class="mb-3"><?php echo $res_prdd['sub_sub_cat_name']; ?></h5>
                    </div>
                    <div class="row no-gutters" >
                        <?php $martsearch =($_GET['martsearch']); 
                        $sql_prd="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.sub_sub_cat_banner,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
                            $result_prd = mysqli_query($conn, $sql_prd);
                           while($res_prd= mysqli_fetch_array($result_prd)){ ?>
                            <?php $cat_name=$res_prd['cat_name']; 
                                  $scat_name=$res_prd['sub_category_name']; 
                                  $sub_sub_cat_name=$res_prd['sub_sub_cat_name']; 
                                  $prod_name=$res_prd['prod_name']; 
                                  $category = strtolower(str_replace(" ", "-", $cat_name));
                                  $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                                  $ssub_category = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                                  $product_name = strtolower(str_replace(" ", "-", $prod_name));?>   
                        <div class="col-md-4 col-6 product">
                            <div class="container">
                                <div class="product-header">
                                <?php $prd_id=$res_prd['id'];
                                    $sql_pd="SELECT * from product_detail where prod_id='$prd_id'";
                                    $exe_pd=mysqli_query($conn,$sql_pd);
                                    $res_pd=mysqli_fetch_array($exe_pd); ?>
                                    <input name="prd_id" id="prod_id" value="<?php echo $res_prd['id']; ?>" class="prd_id" type="hidden">
                                     <input name="prd_name" id="name" class="name" value="<?php echo $res_prd['prod_name']; ?>" type="hidden">
                                     <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <?php if(!empty($res_pd['prod_discount'])){ ?>
                                    <span class="badge badge-success"><?php echo $res_pd['prod_discount']; ?>% OFF</span>
                                <?php } ?>
                                    <img class="img-fluid" src="admin/product/<?php echo $res_prd['prod_img1'];?>" alt="<?php echo $res_prd['prod_name']; ?>"></a>
                                    <?php if($res_prd['prod_test_type']==="Veg"){ ?>
                                        <span class="veg text-success mdi mdi-circle"></span>
                                    <?php }else if($res_prd['prod_test_type']==="Non-Veg") { ?>
                                        <span class="non-veg text-danger mdi mdi-circle"></span>
                                    <?php } ?>
                                </div>
                                <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <div class="product-body">
                                        <h5><?php echo $res_prd['prod_name']; ?> - <?php echo $pricesss =$res_pd['prod_quantity'].$res_pd['prod_quantity_type']; ?></h5>
                                    </div>
                                </a>
                               
                                <div class="product-footer">
                                    <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>" > 
                                    <button type="submit" class="btn btn-sm" style="border:0px;background-color:#ec3237; color:#fff;float: right;color: #fff;padding: 2px 4px; border-radius: 6px;"><i class="mdi mdi-cart-outline"></i>Add to cart </button>
                                 </a>
                                    <p class="offer-price mb-0 mt-1"><span class="mrp-txt">mrp</span>
                    <span class="main-prize"><strike><i class="fa fa-inr"></i>&nbsp;<span id="divShowHide"><?php echo $res_pd['prod_cross_price']; ?></span><span id="prod_cross_price"></span></strike></span>
                    <span class="discounted-prize">
                      <i class="fa fa-inr"></i>&nbsp;<span id="divShowHide1"><?php echo $res_pd['prod_price']; ?></span><span id="prod_price"></span></span></p>
                                </div>
                            </div>
                        </div>
                    <?php } ?>
                    </div> 
                </div>
            <?php } 
if (isset($_POST['martsearch'])) {
 $martsearch =($_POST['martsearch']); 
$sql="select sub_category.sub_category_name,sub_category.id as scid,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.id as ss_id,sub_sub_category.sub_sub_cat_banner,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.prod_name like '$martsearch' or category.cat_name like '$martsearch' or sub_category.sub_category_name like '$martsearch' or sub_sub_category.sub_sub_cat_name like '$martsearch'";
$result = mysqli_query($conn, $sql);
$res_prdd= mysqli_fetch_array($result);
?> 
                <div class="col-md-2" style="padding-right:0;">
                    <div id="accordion" class="shop-filters ">
                        
                       <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">
                                    <button class="btn btn-link collapsed">
                                    <?php echo $res_prdd['sub_sub_cat_name']; ?> <span class="mdi mdi-chevron-down float-right"></span> </button>
                                </h5>
                            </div> 
                                <div class="card-body card-shop-filters">
                                    <ul id="f1" class="checkboxes_list">
                                    <?php $ssc_id=$res_prdd['ss_id'];
                                           $sc_id=$res_prdd['scid'];
                                    $sql_scat="select sub_sub_category.* from sub_sub_category where sub_sub_category.id !='".$ssc_id."' and sub_category_id='".$sc_id."'";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){ ?>
                                         <a href="product.php?id=<?php echo $res_scat['id']; ?>"> <li class="custom-control">
                                            <label><?php echo $res_scat['sub_sub_cat_name']; ?></label>
                                        </li></a>
                                    <?php } ?>
                                       
                                    </ul>
                                </div>
                            </div>
                    </div>
                </div>

<div class="col-md-10"> 
                    <div class="shop-head mb-3">
                       
                        <h5 class="mb-3"><?php echo $res_prdd['sub_sub_cat_name']; ?></h5>
                    </div>
                    <div class="row no-gutters" >
                        <?php $martsearch =($_POST['martsearch']); 
                        $sql_prd="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.sub_sub_cat_banner,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
                            $result_prd = mysqli_query($conn, $sql_prd);
                           while($res_prd= mysqli_fetch_array($result_prd)){ ?>
                             <?php $cat_name=$res_prd['cat_name']; 
                                  $scat_name=$res_prd['sub_category_name']; 
                                  $sub_sub_cat_name=$res_prd['sub_sub_cat_name']; 
                                  $prod_name=$res_prd['prod_name']; 
                                  $category = strtolower(str_replace(" ", "-", $cat_name));
                                  $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                                  $ssub_category = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                                  $product_name = strtolower(str_replace(" ", "-", $prod_name));?> 
                        <div class="col-md-3 col-12 product">
                            <div class="container">
                                <div class="product-header">
                                <?php $prd_id=$res_prd['id'];
                                    $sql_pd="SELECT * from product_detail where prod_id='$prd_id'";
                                    $exe_pd=mysqli_query($conn,$sql_pd);
                                    $res_pd=mysqli_fetch_array($exe_pd); ?>
                                    <input name="prd_id" id="prod_id" value="<?php echo $res_prd['id']; ?>" class="prd_id" type="hidden">
                                     <input name="prd_name" id="name" class="name" value="<?php echo $res_prd['prod_name']; ?>" type="hidden">
                                     <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <span class="badge badge-success"><?php echo $res_pd['prod_discount']; ?>% OFF</span>
                                    <img class="img-fluid" src="https://www.drsadiaformulations.com/admin/product/<?php echo $res_prd['prod_img1'];?>" alt="<?php echo $res_prd['prod_name']; ?>"></a>
                                    <?php if($res_prd['prod_test_type']==="Veg"){ ?>
                                        <span class="veg text-success mdi mdi-circle"></span>
                                    <?php }else if($res_prd['prod_test_type']==="Non-Veg") { ?>
                                        <span class="non-veg text-danger mdi mdi-circle"></span>
                                    <?php } ?>
                                </div> 
                                <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <div class="product-body">
                                        <h5><?php echo $res_prd['prod_name']; ?> - <?php echo $pricess =$res_pd['prod_quantity'].$res_pd['prod_quantity_type']; ?></h5>
                                    </div>
                                </a>
                                
                                <div class="product-footer">
                                <a href="https://www.drsadiaformulations.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>"> 
                                   <button type="submit" class="btn btn-sm" style="border:0px;background-color:#ec3237; color:#fff;float: right;color: #fff;padding: 2px 4px; border-radius: 6px;"><i class="mdi mdi-cart-outline"></i>Add to cart </button>
                                 </a>
                                    <p class="offer-price mb-0 mt-1">&#x20B9;<span id="divShowHide"><?php echo $res_pd['prod_price']; ?></span><span id ="prod_price"> </span><i class="mdi mdi-tag-outline"></i>
                                        <br><span class="regular-price"> &#x20B9;<span id="divShowHide1"><?php echo $res_pd['prod_cross_price']; ?></span> <span id ="prod_cross_price"> </span></span></p>
                                </div>
                            </div>
                        </div>
                    <?php } ?>
                    </div>
                </div>
            <?php } ?>
            </div>
        </div>
    </section>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
    <script type="text/javascript">
$(function() {
    $(document.body).on('change',"#prod_quanttity",function (e) {
        var qid = $(this).val();
        //var qid = $('#prod_quanttity').val();
        //alert(qid);
        $.ajax({
            method: "POST",
            url: "ajax_prd_price.php",
            data:'qid='+qid,
            dataType:'JSON',
            success: function(data){
                $('#prod_price').text(data.prod_price);
                $('#prod_cross_price').text(data.prod_cross_price);
                $('#prod_discount').text(data.prod_discount);
                console.log(data);
            }
        });
    });
});
   $(function(){
$('body').on('change', '#prod_quanttity', function(){    
//$(document).ready(function(){
   // $('#prod_quanttity').on('change', function() {
      if ( this.value == '0')
      {
        $("#divShowHide").show();
        $("#divShowHide1").show();
      }
      else
      {
         $("#divShowHide").hide();
        $("#divShowHide1").hide();
      }
    });
});
    
</script>
<script>
    $(function(){
$('body').on('click', '#butsave', function(){
    var $container = $(this).closest(".container");
    //var prodcut_name = $('#name' + container).val();
    //var prod_id = $('#prd_id' + container).val();
     var prd_name = $container.find("#name").val();
     var prod_id = $container.find("#prod_id").val();
     var prod_quanttity = $container.find("#prod_quanttity").val();
        //$("#butsave").attr("disabled", "disabled");
        //var prd_name = $('#name').val();
        //var prod_id = $('#prod_id').val();
       // var prod_quanttity = $('#prod_quanttity').val();
       
        if(prd_name!="" && prod_id!="" && prod_quanttity!="" ){
            $.ajax({
                url: "insert_tocart.php",
                type: "POST",
                data: {
                    prd_name: prd_name,
                    prod_id: prod_id,
                    prod_quanttity: prod_quanttity
                },
                cache: false,
                success: function(dataResult){
                    var dataResult = JSON.parse(dataResult);
                    if(dataResult.statusCode==200){
                    window.location.href = 'cart.php';
                    //alert("Data added successfully !");
                    }
                    else if(dataResult.statusCode==201){
                       alert("Error occured !");
                    }
                    
                }
            });
        }
        else{
            alert('Please fill all the field !');
        }
    });
});
</script>
</body>
</html>

Editing File: item-search.php