$_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'].'
Whatsapp '.$_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').'
'; send_mail($subject_to_verify, $msg_to_verify); $message = "Hi ".$req_name." payment received for ".$vid_name." video. Click below link, enter your mobile number to view it https://drganbuganapathi.com/direct -Energy Foods"; //enter Your Message $message = urlencode($message); $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$req_whatsapp.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', )); $response = curl_exec($curl); curl_close($curl); } header('Location: ../payment_success.php?ref_no='.$razorpay_payment_id); }else{ header('Location: ../payment_error.php?error='.$error); } ?>