File Explorer

<?php session_start();
include("db_config.php"); 
if (isset($_POST['addto_cart'])) {
$json_string=$_SESSION['Prd_price'];
$array_data = json_decode($json_string, TRUE);
extract($_POST);
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d H:i:s');
$prod_id= $_POST['prod_id'];
$prd_name= $_POST['prd_name'];
$sql_qrr="select * from product where id='".$prod_id."'";
$res_qrr = mysqli_query($conn, $sql_qrr);
$data_qrr= mysqli_fetch_array($res_qrr);
if(empty($array_data)){  
$prod_idd= $_POST['prod_quanttity']; 
}else{
echo $prod_idd=$array_data[0];
}
$sql1="select * from product_detail where id='$prod_idd'";
$res1 = mysqli_query($conn, $sql1);
$data= mysqli_fetch_array($res1);
$prod_size=$data['prod_quantity'].$data['prod_quantity_type'];
$price=$data['prod_price'];
$prd_details=$data['id'];
$quantity="1";
$session=$_SESSION['prd_session_id'];
if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) {
$user_id=$_SESSION['id']; }else{ $user_id =""; }
$sql="INSERT into addto_cart(prod_details_id,prod_id,session_id,user_id,prod_name,prod_size,quantity,price,created_date) values ('$prd_details','$prod_id','$session','$user_id','$prd_name','$prod_size','$quantity','$price','$date')";
//echo $sql; exit();
if(mysqli_query($conn, $sql))
{
unset($_SESSION['Prd_price']);
header("location:https://orangegroceries.com/cart.php");
}
}
?>
<?php if (isset($_POST['wishlist'])) {
$json_string=$_SESSION['Prd_price'];
$array_data = json_decode($json_string, TRUE);
//var_dump($_POST); 
extract($_POST);
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d H:i:s');
$prd_id= $_POST['prod_id'];
$prd_name= $_POST['prd_name'];
if(empty($array_data)){
$prod_idd= $_POST['prod_quanttity']; 
}
else{
echo $prod_idd=$array_data[0];
}
$sql1="select * from product_detail where id='$prod_idd'";
$res1 = mysqli_query($conn, $sql1);
$data= mysqli_fetch_array($res1);
$prod_size=$data['prod_quantity'].$data['prod_quantity_type'];
$price=$data['prod_price'];
$prd_details=$data['id'];
$quantity="1";
$user_id=$_SESSION['id'];
$sql="INSERT into wishlist(prod_details_id,prod_id,user_id,prod_name,prod_size,quantity,price,created_date) values ('$prd_details','$prod_id','$user_id','$prd_name','$prod_size','$quantity','$price','$date')";
//echo $sql; exit();
if(mysqli_query($conn, $sql))
{
unset($_SESSION['Prd_price']);
//echo "<script>window.location.href='product-detail.php'</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<?php $page_name = str_replace(".php", "", basename($_SERVER['PHP_SELF']));
    $Current_URL = basename(dirname(__FILE__));
    $findid = (mysqli_query($conn, "SELECT * FROM product"));
    while ($res2=mysqli_fetch_array($findid)) {
        if(strtolower(str_replace(" ", "-", $res2["prod_name"])) == $page_name){
            $pid = $res2["id"];
        }
    } 
?>    
<head>
	<?php $pid=$pid;
$sql_prdss="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,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.id='$pid'";
$result_prdss = mysqli_query($conn, $sql_prdss);
$res_prdss= mysqli_fetch_array($result_prdss);  ?>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	 <?php echo $res_prdss['meta_keyword']; ?>
    <title><?php echo $res_prdss['title']; ?></title>
	<?php include("css.php");?>
</head>

</div>
							<div id="sync1" class="owl-carousel">
								<div class="item"><img alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img1']; ?>" class="img-fluid img-center"></div>
							<?php $extension2 = end(explode(".", $res_prd["prod_img2"]));
                                    if(!empty($extension2)){ ?>
								<div class="item"><img alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img2']; ?>" class="img-fluid img-center"></div>
								<?php }  $extension3 = end(explode(".", $res_prd["prod_img3"]));
                                if(!empty($extension3)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img3']; ?>" class="img-fluid img-center"></div>
								 <?php } $extension4 = end(explode(".", $res_prd["prod_img4"]));
                                     if(!empty($extension4)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img4']; ?>" class="img-fluid img-center"></div>
								<?php } $extension5 = end(explode(".", $res_prd["prod_img5"]));
                                     if(!empty($extension5)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img5']; ?>" class="img-fluid img-center"></div><?php } ?>
							</div>
							<div id="sync2" class="owl-carousel">
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img1']; ?>" class="img-fluid img-center"></div>
								<?php $extension2 = end(explode(".", $res_prd["prod_img2"]));
                                    if(!empty($extension2)){ ?>
								<div class="item"><img alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img2']; ?>" class="img-fluid img-center"></div>
								<?php }  $extension3 = end(explode(".", $res_prd["prod_img3"]));
                                if(!empty($extension3)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img3']; ?>" class="img-fluid img-center"></div>
								 <?php } $extension4 = end(explode(".", $res_prd["prod_img4"]));
                                     if(!empty($extension4)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img4']; ?>" class="img-fluid img-center"></div>
								<?php } $extension5 = end(explode(".", $res_prd["prod_img5"]));
                                     if(!empty($extension5)){ ?>
								<div class="item"><img  alt="<?php echo $res_prd['prod_name']; ?>" title="<?php echo $res_prd['prod_name']; ?>" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img5']; ?>" class="img-fluid img-center"></div><?php } ?>
							</div>
						</div>
					</div>
				</div>

<div class="col-md-7">
					<div class="shop-detail-right">
						<h2><?php echo $res_prd['prod_name']; ?></h2>
						<div class="product-header"> </div>
						<div class="row">
							<div class="col-md-12 product-prize">
								<span class="mrp-txt">mrp</span>
								<span class="main-prize"><strike><i class="fa fa-inr"></i>&nbsp;<span id="divShowHide"><?php echo $res_prdd['prod_cross_price']; ?></span><span id="prod_cross"></span></strike></span>
								<span class="discounted-prize">
									Price: <i class="fa fa-inr"></i>&nbsp; <span id="divShowHide1" class="text-success">  <?php echo $res_prdd['prod_price']; ?></span><span id="prod_price"></span> </span>
							</div>
						</div>
						<input name="prod_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">
                         <input type="hidden" id="prod_idd" name="prod_quanttity" value="<?php echo $res_prdd['id']; ?>">
						<div class="row col-md-12">
							<h6 class="float-left mt-10"><b>Availability:</b>
							 <?php if($res_prd['status'] == "Available"){ ?> <span class="badge badge-success">In Stock </span>
							  <?php } else if($res_prd['status'] == "Out_Of_Stock") { ?><span class="badge badge-success">Out Of Stock </span>  <?php }else{ ?> <span class="badge badge-dengar">In Stock </span><?php } ?> </h6>
						</div>
						<div class="clearfix"></div>
						<div class="row">
							<div class="col-md-3 mt-10 text-black">
								<h6><b>Select Quantity: </b></h6>
							</div>
							<div class="col-md-9 product-add-to-cart-btn mt-10">
								<p>
									<?php  $prd_id=$res_prd['id'];
                                    $sql2="SELECT * from product_detail where prod_id='$prd_id'";
                                    $exe2=mysqli_query($conn,$sql2);
                                    while ($res21=mysqli_fetch_array($exe2)){
                                    ?>
									<button id="btnShowHide" type="button" value="<?php echo $res21['id'];?>" class="product-variant-btn-active"><?php echo $res21['prod_quantity']." ".$res21['prod_quantity_type'];?></button><?php } ?>
								</p>
							</div>
						</div>

<div class="row mt-20">
							<div class="col-md-4 product_details_box product-add-to-cart-btn"><?php $prd_idd=$res_prdd['id'];
                $sql_qry=mysqli_query($conn,"select count(quantity) as prd from addto_cart where prod_details_id='".$prd_idd."' and invoice_id='0'");
                $res_data= mysqli_fetch_assoc($sql_qry);
                $tprd=(int)$res_data['prd'];
                $sql_pdd=mysqli_query($conn,"SELECT * from product_detail where id='$prd_idd'");
                $res_pdd=mysqli_fetch_array($sql_pdd);
                $left=$res_pdd['total_no_prod_quantity'] - $tprd; ?>
								 <?php if($res_prd['status'] == "Available") {	
				                	if($left > 0){ ?>
									<button type="submit" name="addto_cart" id="cartsave"  class="btn btn-sm" style="border:0px;background-color:#007848; color:#fff;color: #fff;padding: 2px 4px;border-radius: 6px;"><i class="mdi mdi-cart-outline" aria-hidden="true"></i> Add To Cart</button>
									 <?php }else if($left == 0){ ?>
									 <button type="button" id="cartsave"  class="btn btn-secondary" style="border:0px;background-color:#007848; color:#fff;color: #fff;padding: 2px 4px;border-radius: 6px;"><i class="mdi mdi-cart-outline" aria-hidden="true"></i> Out Of Stock</button>
									 <?php } }else if($res_prd['status'] == "Out_Of_Stock"){ ?>
									 	<button type="button" id="cartsave"  class="btn btn-secondary" style="border:0px;background-color:#007848; color:#fff;color: #fff;padding: 2px 4px;border-radius: 6px;"><i class="mdi mdi-cart-outline" aria-hidden="true"></i> Out Of Stock</button>
									 <?php } ?>
							</div>
							<div class="col-md-3"> <?php if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) { ?>
                            <button type="button" name="wishlist" id="add_to_wishlist" class="btn btn-secondary btn-lg add_to_wishlist"  ><i class="mdi mdi-cart-outline"></i> Wishlist</button> <?php }else{ ?>
                                 <a href="https://orangegroceries.com/login.php"> <button type="button"  class="btn btn-secondary btn-lg"  ><i class="mdi mdi-cart-outline"></i> Wishlist</button></a><?php } ?>
							</div>
						</div>
					</div>
				</div>
			</div>
		    </form>
		</div>
	</section>
	<section class="shop-single section-padding pb-20">
		<div class="container">
			<div class="col-xs-12">
				<div class="card-body">
					<div class="accordion" id="accordionExample">
						<div class="card mb-0">
							<div class="card-header" id="headingOne">
								<h6 class="mb-0">
									<a href="#" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
										<i class="mdi mdi-arrow-all"></i> Product Specification
									</a>
								</h6>
							</div>
							<div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordionExample">
								<div class="card-body text-black">
									<?php echo $res_prd['prod_desp']; ?>
								</div>
							</div>
							<div class="card-header" id="headingTwo">
								<h6 class="mb-0">
									<a href="#" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">
										<i class="mdi mdi-arrow-all"></i> Product Features
									</a>
								</h6>
							</div>
							<div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionExample">
								<div class="card-body text-black">
									<?php echo $res_prd['features']; ?>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div> 
	</section>

<section class="product-items-slider bg-white section-padding">
		<div class="container">
			<div class="section-header">
				<h5 class="heading-design-h5">Best Offers Products <span class="badge badge-info"></span>
				</h5>
			</div>
			<div class="owl-carousel owl-carousel-featured">
                <?php 
                $sql_ret="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,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 best_product='1'";
                    $result_ret= mysqli_query($conn, $sql_ret);
                   while($res_ret= mysqli_fetch_array($result_ret)){ ?>
                   	 <?php   $prd_id=$res_ret['id']; 
                        $sql_pod="SELECT * from product_detail where prod_id='$prd_id'";
                        $exe_pod=mysqli_query($conn,$sql_pod);
                        $res_pod=mysqli_fetch_array($exe_pod);
                        $cat_name=$res_ret['cat_name']; 
                      $scat_name=$res_ret['sub_category_name']; 
                      $sub_sub_cat_name=$res_ret['sub_sub_cat_name']; 
                      $prods_name=$res_ret['prod_name']; 
                      $cat = strtolower(str_replace(" ", "-", $cat_name));
                      $sub_cat = strtolower(str_replace(" ", "-", $scat_name));
                      $ssub_cat = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                      $product_names = strtolower(str_replace(" ", "-", $prods_name)); ?>
				<div class="item">
					<div class="products-wrapper">
						<div class="product-image">
							<a href="https://orangegroceries.com/<?php echo "$cat/$sub_cat/$ssub_cat/$product_names.php"; ?>" > 
						    <img src="https://orangegroceries.com/admin/product/<?php echo $res_ret['prod_img1'];?>" />
							</a>
						</div>
						<div class="product-other-info">
							<div class="product-name">
								<a href="https://orangegroceries.com/<?php echo "$cat/$sub_cat/$ssub_cat/$product_names.php"; ?>" > <?php echo $res_ret['prod_name']; ?></a>
							</div>
							<div class="product-add-to-cart-btn">
								<span class="mrp-txt">mrp</span>
							<span class="main-prize"><strike><i class="fa fa-inr"></i>&nbsp;<?php echo $res_pod['prod_cross_price']; ?></strike></span>
							<span class="discounted-prize">
								<i class="fa fa-inr"></i>&nbsp;<?php echo $res_pod['prod_price']; ?> </span>
								<a href="https://orangegroceries.com/<?php echo "$cat/$sub_cat/$ssub_cat/$product_names.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>
								</a>
							</div>

</div>
					</div>
				</div>
               <?php } ?>
				
			</div>
		</div>
	</section>
	<?php include("orderwhatsapp.php");?>
	<?php include("footer.php");?>
	<?php include("js.php");?>
</body>
<script type="text/javascript">
$(document).ready(function() {
$('.product-variant-btn-active').click(function() {
var getid = $(this).val();
if (getid) {
$.ajax({
    type: 'POST',
    url: 'https://orangegroceries.com/ajax_prd_get_price.php',
    data: 'getid=' + getid,
    dataType: 'JSON',
    success: function(data) {
       // var prod_id = data[0];
       // var prod_price = data[1];
       // var prod_cross_price = data[2];
       // $('#prod_idd').html("<b> </b>" + prod_id);
       // $('#prod_price').html("<b> </b>" + prod_price);
       // $('#prod_price1').html("<b> </b>" + prod_price);
       // $('#prod_cross').html("<b> </b>" + prod_cross_price);
        $('#prod_idd').text(data.id);
        $('#prod_price').text(data.prod_price);
        $('#prod_price1').text(data.prod_price);
        $('#prod_cross').text(data.prod_cross_price);
        $('#prod_discount').text(data.prod_discount);
        console.log(data);
    }
});
}
});
});

$(function(){
$('body').on('click', '#btnShowHide', function(){    
    var getid = $(this).val();
  if (this.value == '0')
  {
    $("#divShowHide").show();
    $("#divShowHide1").show();
  }
  else
  {
     $("#divShowHide").hide();
    $("#divShowHide1").hide();
  }
});
});
$(function(){
$('body').on('click', '.add_to_wishlist', function(){
  var $container = $(this).closest(".container");
     var product_name = $container.find("#name").val();
     var prod_id = $container.find("#prod_id").val();
     var prod_idd = $container.find("#prod_idd").val();
    var action = "add";
       $.ajax({
       url:"https://orangegroceries.com/insert_towishlist.php",
       method:"POST",
       data:{
         prd_name: product_name,
         prod_id: prod_id,
         prod_quanttity: prod_idd,
          action:action
        },
        success:function(dataResult)
        { 
            console.log(dataResult);
            var dataResult = JSON.parse(dataResult);
            if(dataResult.statusCode==200){
            alert("added successfully !");
            }
            else if(dataResult.statusCode==201){
               //alert("Error occured !");
            }
        }
    });
 
  });
  });
    </script>
</html>

Editing File: no-1..php