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)){?>
User Name:fname;?> Email:email;?>
Phone*
Pincode*
Phone*
Pincode*
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");
}
}
}
?>