$_SESSION['razorpay_order_id'], 'razorpay_payment_id' => $_REQUEST['razorpay_payment_id'], 'razorpay_signature' => $_REQUEST['razorpay_signature'], ); $api->utility->verifyPaymentSignature($attributes); } catch (SignatureVerificationError $e) { $success = false; $error = 'Razorpay Error : ' . $e->getMessage(); } } if ($success === true) { $vid_name=''; $razorpay_order_id = $_SESSION['razorpay_order_id']; $razorpay_payment_id = $_REQUEST['razorpay_payment_id']; $req_name = $_REQUEST['req_name']; $req_country = $_REQUEST['req_country']; $req_whatsapp = $_REQUEST['req_whatsapp']; $amount = $_REQUEST['amount']; $req_videos = explode(",",$_REQUEST['req_videos']); $req_pay = $_REQUEST['req_pay']; $dealer_id = $_SESSION['dealer_id']; $user = array("dealer_id"=>$_SESSION['dealer_id'], "cust_name"=>$_REQUEST['req_name'], "whatsapp"=>$_REQUEST['req_whatsapp'], "amount"=>$_REQUEST['amount'], "country"=>$_REQUEST['req_country'], "video"=>$_REQUEST['req_videos'], "payment_type"=>$_REQUEST['req_pay'], "order_id"=>$razorpay_payment_id, "order_date_time"=>date('d-m-Y H:i:s') ); $user_meta = json_encode($user); $insert_meta = "INSERT INTO drganbug_medine.tbl_missed_dealer_yoga_video_log (user_meta, pay_status, order_id, order_date_time) VALUES('$user_meta', 'post-order', '$razorpay_payment_id', '".date('d-m-Y H:i:s')."');"; mysqli_query($conn, $insert_meta); $sql = "insert into tbl_yoga_video_request(`name`,`country`, `whatsapp`, `payment_type`, `status`, `payment_id`, `dealer_id`) values ('$req_name', '$req_country', '$req_whatsapp', '$req_pay', '0', '$razorpay_payment_id', '$dealer_id')"; if(mysqli_query($conn, $sql)){ $last = mysqli_insert_id($conn); foreach($req_videos as $video){ $get_c = mysqli_query($conn, "select price from shop_product where product_id = '$video'"); $get_cost = mysqli_fetch_array($get_c, MYSQLI_ASSOC); $vid_name.=$get_cost['name'].' '; $exp = "insert into tbl_yoga_video_request_explained(`ref_id`, `product_id`, `price`) values ( '$last', '$video', '$get_cost[price]')"; if(mysqli_query($conn, $exp)){ $i=$i+1; }else{ $i=0; } } $subject_to_verify = 'Dealer Yoga Video Request Submitted by the dealer : '.$_SESSION['name'].' for the Customer '.$_REQUEST['req_name'].' / '.$_REQUEST['req_whatsapp'].' / '.$razorpay_payment_id; $msg_to_verify = '
Dealer Name | '.$_SESSION['dealer_id'].' : '.$_SESSION['name'].' |
---|---|
Name | '.$_REQUEST['req_name'].' |
'.$_REQUEST['req_whatsapp'].' | |
Amount | '.$_REQUEST['amount'].' |
Country | '.$_REQUEST['req_country'].' |
Video Names | '.$vid_name.' |
Payment Type | '.$_REQUEST['req_pay'].' |
Razorpay Order Id | '.$razorpay_order_id.' |
Razorpay Payment Id | '.$razorpay_payment_id.' |
Date & Time | '.date('d-m-Y H:i:s').' |