YOUR ORDER HAS BEEN RECEIVED
Your Payment TXN ID # is:
Click Continue to Shop More...
CONTINUE ✅ Payment Verified Successfully!"; $txnid = $razorpay_payment_id; $order_id = $_SESSION['razorpay_order_id'] ?? $razorpay_order_id; $conn = getDBConnection(); // ✅ OLD + NEW DATABASE FIELDS (EXACTLY LIKE OLD SITE) $stmt = $conn->prepare(" UPDATE bookings SET payment_status = 'success', razorpay_payment_id = ?, payment_verified = 'verified', payment_method = 'razorpay', order_status = 'Success', tracking_id = ? WHERE razorpay_order_id = ? "); $stmt->bind_param("sss", $txnid, $txnid, $order_id); $stmt->execute(); $affected_rows = $stmt->affected_rows; $stmt->close(); // Get booking details $stmt = $conn->prepare(" SELECT b.*, s.title as service_title, s.price as service_price FROM bookings b JOIN services s ON s.id = b.service_id WHERE b.razorpay_order_id = ? "); $stmt->bind_param("s", $order_id); $stmt->execute(); $result = $stmt->get_result(); $rowu = $result->fetch_assoc(); $stmt->close(); $conn->close(); if ($rowu && $affected_rows > 0) { // ✅ EXACT SAME 4 EMAILS AS OLD SITE $to = 'support@askmanisha.com'; // Primary admin $tob = 'amkorders09@gmail.com'; // Backup admin 1 $toc = 'webgennie5@gmail.com'; // Backup admin 2 $toa = $rowu['email']; // Customer $subject = 'New Order Information'; $headers = "From: " . strip_tags('support@askmanisha.com') . "\r\n"; $headers .= "Reply-To: ". strip_tags('support@askmanisha.com') . "\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=UTF-8\r\n"; $currencySymbol = getCurrencySymbol($rowu['currency']); $message = 'New Booking Confirmation
Payment Information
Transaction ID : '.$txnid.'
Amount Paid : '.$currencySymbol.number_format($rowu['amount_paid'], 2).' ('.$rowu['currency'].')
Payment Status : Success
Service Details
Service Name : '.htmlspecialchars($rowu['service_title']).'
Customer Information
Name : '.htmlspecialchars($rowu['first_name'].' '.$rowu['last_name']).'
Email : '.htmlspecialchars($rowu['email']).'
Mobile : '.htmlspecialchars($rowu['telephone']).'
Address Details
Address : '.htmlspecialchars($rowu['address']).'
City : '.htmlspecialchars($rowu['city']).'
Zip Code : '.htmlspecialchars($rowu['zip']).'
Country : '.htmlspecialchars($rowu['country']).'
Birth Details
Date Of Birth : '.date('M d, Y', strtotime($rowu['dob'])).'
Birth Time : '.date('h:i A', strtotime($rowu['birth_time'])).'
Birth Place : '.htmlspecialchars($rowu['birth_place']).'
Consultation Schedule
Consultation Date : '.date('l, F d, Y', strtotime($rowu['consult_date'])).'
Consultation Time : '.date('h:i A', strtotime($rowu['consult_time'])).'
Terms & Conditions
- The amount paid for this order is NOT Refundable.
- The date & time for the telephonic appointment will be fixed as per the mutual convenience.
- You would need to make a call at our office numbers for your appointment to be executed at the scheduled time.
- You would need to inform us a day prior in case you wish to reschedule your appointment.
- Only Telephonic Orders marked as "Express Service" can be executed within 3 business days. Refer to the timelines for other orders as mentioned along with them.
For any queries, please contact us at support@askmanisha.com
'; // ✅ SEND ALL 4 EMAILS (EXACTLY LIKE OLD SITE) $mail = sendEmail($to, $subject, $message, $headers); // Primary admin $maila = sendEmail($toa, $subject, $message, $headers); // Customer $mailb = sendEmail($tob, $subject, $message, $headers); // Backup 1 $mailc = sendEmail($toc, $subject, $message, $headers); // Backup 2 if($mail || $maila || $mailb || $mailc) { echo "✅ Confirmation emails sent successfully to all 4 recipients!
"; } else { echo "⚠️ Email delivery issue (IP blocked). Contact support@askmanisha.com
"; } echo "DB Updated: {$affected_rows} rows | Order ID: {$order_id}
"; } else { echo "❌ Booking not found or DB update failed.
"; } } else { echo "❌ Payment verification failed: " . htmlspecialchars($error) . "
"; } ?>