3456, 'amount' => $price * 100, // 2000 rupees in paise 'currency' => 'INR', 'payment_capture' => 1, // auto capture ]; $razorpayOrder = $api->order->create($orderData); $razorpayOrderId = $razorpayOrder['id']; $_SESSION['razorpay_order_id'] = $razorpayOrderId; $browsessionid=session_id(); $Updatecart = mysql_query("UPDATE shop_cart SET `trans`='$razorpayOrderId' WHERE `session_id`='$browsessionid' "); $displayAmount = $amount = $orderData['amount']; //prepare email $get_user = mysqli_query($conn, "select * from shop_cart where session_id = '$browsessionid' order by id desc limit 1"); $get_user = mysqli_fetch_array($get_user); $get_a = mysqli_query($conn, "select * from shop_user where user_id = '".$get_user['user_id']."'"); $get_age = mysqli_fetch_array($get_a, MYSQLI_ASSOC); $msg_to_verify = '
Name '.$get_user['dif_name'].'
Age '.$get_age['dob'].'
Address '.$get_user['del_address'].'
City '.$get_user['del_city'].'
State '.$get_user['del_state'].'
Pin Code '.$get_user['del_inp'].'
Country '.$get_user['del_country'].'
Phone '.$get_user['dif_phone'].'
Razorpay Order Id '.$razorpayOrderId.'
Session ID '.$browsessionid.'
'."\n\n"; $user_met = array("cust_name"=>$get_user['dif_name'], "dob"=>$get_age['dob'], "address"=>$get_user['del_address'], "city"=>$get_user['del_city'], "state"=>$get_user['del_state'], "pincode"=>$get_user['del_inp'], "country"=>$get_user['del_country'], "phone"=>$get_user['dif_phone'], "session_id"=>$browsessionid, "raz_id"=>$razorpayOrderId, "user_id"=>$get_user['user_id'], "shipping"=>$shipping, "order_date"=>date('Y-m-d H:i:s')); $user_meta = json_encode($user_met); $msg_to_verify .= ''; $shop_c = mysqli_query($conn, "select sc.productid, sc.price, sp.name, sp.product_url, sc.qty, sc.totprice from shop_cart sc inner join shop_product sp on sc.productid = sp.product_id where sc.session_id = '$browsessionid'"); while ($shop_cart = mysqli_fetch_array($shop_c, MYSQLI_ASSOC)){ $msg_to_verify.= ''; $cart_amount = $cart_amount + $shop_cart['totprice']; $product_met[] = array("product_id"=>$shop_cart['productid'], "qty"=>$shop_cart['qty'], "price"=>$shop_cart['price'], "tot_price"=>$shop_cart['totprice']); } $product_meta = json_encode($product_met); $insert_missed="INSERT INTO tbl_online_sales_missed_log (user_meta, product_meta, pay_status, order_id, order_date_time) VALUES('$user_meta', '$product_meta', 'pre-order', '$razorpayOrderId', '$date');"; mysqli_query($conn, $insert_missed); $_SESSION['user_meta']=$user_meta; $_SESSION['product_meta']=$product_meta; $msg_to_verify.='
Product Name Product Variant Qty Total Price
'.$shop_cart['name'].' '.$shop_cart['product_url'].' '.$shop_cart['qty'].' '.$shop_cart['totprice'].'
Cart Total '.$cart_amount.'
Shipping Amount '.$shipping.'
Grand Total '.$price.'
'; $subject_to_verify = 'Order Details for '.$get_user['dif_name'].' / '.$get_user['dif_phone'].' / '.$razorpayOrderId; $_SESSION['msg_to_verify'] = $msg_to_verify; $_SESSION['subject_to_verify'] = $subject_to_verify; send_mail($subject_to_verify, $msg_to_verify); if ($displayCurrency !== 'INR') { $url = "https://api.fixer.io/latest?symbols=$displayCurrency&base=INR"; $exchange = json_decode(file_get_contents($url), true); $displayAmount = $exchange['rates'][$displayCurrency] * $amount / 100; } $data = [ "key" => $keyId, "amount" => $amount, "name" => "ENERGY FOODS", "description" => "Dr. G.ANBUGANAPATHI", "image" => "http://drganbuganapathi.com/default/img/anbuganapathi.jpg", "prefill" => [ "name" => $customer, "email" => $email, "contact" => $contact, ], "notes" => [ "address" => "Hello World", "merchant_order_id" => "12312321", ], "theme" => [ "color" => "#F37254", ], "order_id" => $razorpayOrderId, ]; if ($displayCurrency !== 'INR') { $data['display_currency'] = $displayCurrency; $data['display_amount'] = $displayAmount; } $json = json_encode($data); ?>
Your payment is being submitted. Please do not close this window or click the Back button on your browser.