e744f91c29ec99f0e662c9177946c627

Edit file

File name : ajax-phone-cart.php

Content :

<?php 
include("../include/config.php");
include("../include/functions.php");

if($_REQUEST['action']=='searchuser'){
$phone=$_REQUEST['phone'];
$userArr=$obj->query("SELECT * FROM `tbl_user` WHERE status=1 AND mobile='$phone' AND user_type=0");

$number_of_rec=$obj->numRows($userArr);
 if($number_of_rec>0){
  while($resultUser=$obj->fetchNextObject($userArr)){?>
 <div class="usertop usertop<?php echo $resultUser->id;?>">
<ul class="row userone<?php echo $resultUser->id;?>">
<li class="col-sm-12 mb-3 mb-sm-0">
<p class="clsLabel"><strong>User Name:</strong> <span><?php echo $resultUser->fname;?></span> <strong> Email:</strong> <span><?php echo $resultUser->email;?></span></p>
</li>
</ul>

<ul class="row user<?php echo $resultUser->id;?>">
<li class="col-sm-3 mb-3 mb-sm-0">
<p class="clsLabel">Phone<span>*</span></p>
<input name="suserphone" class="form-control form-control-user phone" type="text" placeholder='Enter User Phone' value="<?php echo $resultUser->mobile;?>" required>
</li>
<li class="col-sm-3 mb-3 mb-sm-0 ">
<p class="clsLabel">Pincode<span>*</span></p>
<input name="suserzip" class="form-control form-control-user zipcode" type="text" placeholder='Enter User Zipcode' value="<?php echo $resultUser->pincode;?>" required>
</li>	
<li class="col-sm-3 mb-3 mb-sm-0">
<p class="clsLabel">&nbsp;<span></span></p>
<input name="suserslbtn" value="Select User" onclick="selectuser('usertop<?php echo $resultUser->id;?>','<?php echo $resultUser->id;?>');" class="form-control form-control-user  btn btn-primary btn-user" type="button" placeholder='Select User'>
</li>								
</ul>
</div>  
  
<?php }  } else {?>
<div class="usertop usertop0">
	<ul class="row user0">
<li class="col-sm-3 mb-3 mb-sm-0">
<p class="clsLabel">Phone<span>*</span></p>
<input name="suserphone" class="form-control form-control-user phone" type="text" placeholder='Enter User Phone' value="<?php echo $phone;?>" required>
</li>
<li class="col-sm-3 mb-3 mb-sm-0">
<p class="clsLabel">Pincode<span>*</span></p>
<input name="suserzip" class="form-control form-control-user zipcode" type="text" placeholder='Enter User Zipcode' value="" required>
</li>	
<li class="col-sm-3 mb-3 mb-sm-0">
<p class="clsLabel">&nbsp;<span></span></p>
<input name="suserslbtn" class="form-control form-control-user  btn btn-primary btn-user" onclick="selectuser('usertop0','0');" value="Select User" type="button" placeholder='Select User'>
</li>								
</ul>
</div>
<?php }  } elseif($_POST['action']=='savecart'){
	if(isset($_POST['jsonData']['CartGrocery']) || isset($_POST['jsonData']['CartFood'])) {
	
	$str_result = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';

// Shuffle the $str_result and returns substring
    // of specified length
	$uid=$_REQUEST['uid'];
	$postalcode=$_REQUEST['postalcode'];
	$phone=$_REQUEST['phone'];
	
	if($_POST['cartkey']!=''){
		$_SESSION['sess_msg']='Phone Cart Updated Successfully';
		$cartkey=$_POST['cartkey'];
		$carm=$obj->query("SELECT id FROM `tbl_cart_master` WHERE cart_key='$cartkey'");
		$resultcart=$obj->fetchNextObject($carm);
		$resultcartid=$resultcart->id;
		$obj->query("update tbl_cart_master set status='Cart Enable' where id='$resultcartid'");
		$obj->query("Delete FROM `tbl_cart_master_items` WHERE  cart_id='$resultcartid'");
	}  else {
	$_SESSION['sess_msg']='Phone Cart Added Successfully';
	$length_of_string=10;
    $cartkey=substr(str_shuffle($str_result),0, $length_of_string);
	$cartkeycheck=$obj->query("SELECT cart_key FROM `tbl_cart_master` WHERE cart_key='$cartkey'");
    $number_of_rec=$obj->numRows($cartkeycheck);
	$obj->query("insert into tbl_cart_master set user_id='$uid',phone='$phone',zipcode='$postalcode',cart_key='$cartkey',status='Cart Enable'");
	$resultcartid = $obj->lastInsertedId();
    if($number_of_rec>0){
		$cartkey=$cartkey+$resultcartid;
		$obj->query("update tbl_cart_master set cart_key='$cartkey',status='Cart Enable' where id='$resultcartid'");
	}
	 
	}  
	
	$jsonData = $_POST['jsonData'];
    $cart_grocery = $jsonData['CartGrocery'];
    $cart_food = $jsonData['CartFood'];
	foreach ($cart_grocery as $data) {
		
		$pid=$data['pid'];
		$psize=$obj->query("SELECT size,size_type FROM `tbl_productprice` WHERE product_id='$pid'");
		$resultpsize=$obj->fetchNextObject($psize);
		$size=$resultpsize->size;
		$sizetype=$resultpsize->size_type;
        $obj->query("insert into tbl_cart_master_items set cart_id='$resultcartid',product_id='".$data['pid']."',product_name='".mysqli_real_escape_string($GLOBALS['conn'],$data['name'])."',size='".$size."',size_type='".$sizetype."',storeid='".$data['sid']."',sellprice='".$data['price']."',mrprice='".$data['price']."',qty='".$data['qty']."',tax='".$data['baseTax']."',section=1");
        
    }
	foreach ($cart_food as $dataf) {
        $pid=$data['pid'];
		$psize=$obj->query("SELECT size,size_type FROM `tbl_productprice` WHERE product_id='$pid'");
		$resultpsize=$obj->fetchNextObject($psize);
		$size=$resultpsize->size;
		$sizetype=$resultpsize->size_type;
       
     $obj->query("insert into tbl_cart_master_items set cart_id='$resultcartid',product_id='".$dataf['pid']."',product_name='".mysqli_real_escape_string($GLOBALS['conn'],$dataf['name'])."',size='".$size."',size_type='".$sizetype."',storeid='".$dataf['sid']."',sellprice='".$dataf['price']."',mrprice='".$dataf['price']."',qty='".$dataf['qty']."',tax='".$dataf['baseTax']."',section=3");
       
    }
	}
}
?>

Gel4y Mini Shell

Edit file