$_POST['razorpay_order_id'], 'razorpay_payment_id' => $_POST['razorpay_payment_id'], 'razorpay_signature' => $_POST['razorpay_signature'] ); $api->utility->verifyPaymentSignature($attributes); } catch(SignatureVerificationError $e) { $success = false; $error = 'Razorpay Error : ' . $e->getMessage(); } } if ($success === true) { $sql2="SELECT * FROM userregistration WHERE MobileNo =".$_POST['MobileNo']." and `member`= 1"; //print_r($sql2); $result1 = mysqli_query($conn,$sql2); if(mysqli_num_rows($result1)) { $result1 = mysqli_query($conn,$sql2); $row=mysqli_fetch_assoc($result1); // echo $row['userid']; $q1="INSERT INTO `cart`(`userid`, `testname`, `unitamount`, `totalamount`, `payment`, `mobileno`) VALUES ('".$row['userid']."','".$_POST['testname']."','".$_POST['unit']."','".$_POST['amount']."','".$_POST['payment']."','".$_POST['MobileNo']."')"; // print_r($q1); $res=mysqli_query($conn,$q1); } if($_POST['member']==0) { $q1="INSERT INTO `cart`(`userid`, `testname`, `unitamount`, `totalamount`, `payment`, `mobileno`) VALUES ('".$_POST['userid']."','".$_POST['testname']."','".$_POST['unit']."','".$_POST['amount']."','".$_POST['payment']."','".$_POST['MobileNo']."')"; // print_r($q1); $res=mysqli_query($conn,$q1); $query11 = "UPDATE `userregistration` SET `member`=".$_POST['member']." WHERE MobileNo =".$_POST['MobileNo']; // print_r($query11); $result12=mysqli_query($conn,$query11); } elseif($_POST['member']==1) { $date=date("Y-m-d"); $expiryDate=date('Y-m-d', strtotime('+1 year', strtotime($date))); $q1="INSERT INTO `cart`(`userid`, `testname`, `unitamount`, `totalamount`, `payment`, `mobileno`) VALUES ('".$_POST['userid']."','".$_POST['testname']."','".$_POST['unit']."','".$_POST['amount']."','".$_POST['payment']."','".$_SESSION['MobileNo']."')"; // print_r($q1); $res=mysqli_query($conn,$q1); $query11 = "UPDATE `userregistration` SET `member`= ".$_POST['member'].",rdate='".$date."',vdate='".$expiryDate."' WHERE MobileNo =".$_POST['MobileNo']; // print_r($query11); $result12=mysqli_query($conn,$query11); } $html = "
Your payment was successful
Payment ID: {$_POST['razorpay_payment_id']}
"; } else { $html = "Your payment failed
{$error}
"; } echo $html;