prepare($sql); $stmt->bind_param("i", $bookingId); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); $stmt->close(); if (!$row) { die("Booking not found."); } // HTML content (same as email body) $htmlContent = '

Sai Baba Temple Booking Confirmation

Dear ' . htmlspecialchars($row['name']) . ',
Thank you for your booking. Below are the details:

Name:' . $row['name'] . '
Mobile:' . $row['mobile'] . '
Email:' . $row['email'] . '
Gender:' . $row['gender'] . '
Age:' . $row['age'] . '
Aadhar No:' . $row['aadhar'] . '
Puja Type:' . $row['puja_type'] . '
Booking Date:' . $row['booking_date'] . '
Gotra:' . $row['gotra'] . '
Address:' . $row['address'] . ', ' . $row['city'] . ', ' . $row['state'] . ', ' . $row['country'] . ' - ' . $row['zip_code'] . '
Purpose:' . $row['purpose'] . '
'; //echo($htmlContent);exit; // ✨ Generate PDF using TCPDF $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); $pdf->SetCreator('Sai Baba Temple'); $pdf->SetAuthor('Temple Admin'); $pdf->SetTitle('Puja Booking Confirmation'); $pdf->SetMargins(15, 20, 15); $pdf->AddPage(); $pdf->writeHTML($htmlContent, true, false, true, false, ''); ///$pdfFile = __DIR__ . '/temp_pdfs/puja_booking_' . $bookingId . '.pdf'; $savePath = __DIR__ . '/temp_pdfs/'; if (!is_dir($savePath)) { mkdir($savePath, 0755, true); // Create folder if not exists } $pdfFile = $savePath . 'puja_booking_' . $bookingId . '.pdf'; $pdf->Output($pdfFile, 'F'); // Save PDF to file // 📨 Send Email with PHPMailer $mail = new PHPMailer(true); try { $mail->isSMTP(); $mail->Host = 'v22437909.sin01.serveradd.com'; $mail->SMTPAuth = true; $mail->Username = 'admin@aiss.org.in'; $mail->Password = 'Oo(hKvdR.52E'; $mail->SMTPSecure = 'ssl'; $mail->Port = 465; $mail->setFrom('admin@aiss.org.in', 'Sai Baba Temple'); // Add customer email only if it exists and is valid if (!empty($row['email']) && filter_var($row['email'], FILTER_VALIDATE_EMAIL)) { $mail->addAddress($row['email'], $row['name']); // Customer } $mail->addAddress('kavintechsolutions@gmail.com'); // Internal team $mail->addBCC($row['email'], $row['name']); $mail->addReplyTo($row['email'], $row['name']); // Optional $mail->isHTML(true); $mail->Subject = "Sai Baba Puja Booking Confirmation"; $mail->Body = $htmlContent; // 📎 Attach the generated PDF $mail->addAttachment($pdfFile); $mail->send(); // 🧹 Clean up the file after sending unlink($pdfFile); echo ""; } catch (Exception $e) { echo "Email could not be sent. Mailer Error: {$mail->ErrorInfo}"; } unlink($pdfFile); ?>