/home/u775757334/domains/civicwelllife.com/public_html
Edit: /home/u775757334/domains/civicwelllife.com/public_html/booking-process.php (2149B)
$order_id,
'razorpay_payment_id' => $payment_id,
'razorpay_signature' => $signature
];
try {
/* Verify Payment */
$api->utility->verifyPaymentSignature($attributes);
/* Get last slip number of selected date */
$getSlip = mysqli_query($conn, "
SELECT MAX(slip_no) as lastSlip
FROM tbl_booking
WHERE appointment_date='$appointment_date'
");
$row = mysqli_fetch_assoc($getSlip);
$slip_no = ($row['lastSlip']) ? $row['lastSlip'] + 1 : 1;
$sys_order = "DOC" . time();
/* Insert booking */
mysqli_query($conn, "INSERT INTO tbl_booking SET
order_id='$sys_order',
doctor_id='$doctor_id',
patient_name='$name',
patient_phone='$phone',
patient_email='$email',
city='$city',
appointment_date='$appointment_date',
date_time='$date_time',
slip_no='$slip_no',
payment_status='1',
payment_mode='Razorpay',
payment_razor_id='$payment_id',
payment_razor_order_id='$order_id',
date='$created_datetime'
");
echo json_encode([
"status" => "success",
"order_id" => $sys_order,
"slip_no" => $slip_no
]);
} catch (SignatureVerificationError $e) {
echo json_encode([
"status" => "error",
"msg" => "Payment verification failed"
]);
}