AddPage(); // Header $pdf->SetFont('Arial','B',16); $pdf->Cell(190,10,'Aastha Padghan Hospital',0,1,'C'); $pdf->SetFont('Arial','',10); $pdf->Cell(190,5,'Padghan Surgical Hospital, Chikhli',0,1,'C'); $pdf->Cell(190,5,'Phone: +91 9922346009',0,1,'C'); $pdf->Line(10, 30, 200, 30); // Receipt Details $pdf->Ln(10); $pdf->SetFont('Arial','B',14); $pdf->Cell(190,10,'OPD RECEIPT',0,1,'C'); $pdf->Ln(5); $pdf->SetFont('Arial','',12); $pdf->Cell(50,10,'Receipt No:',0,0); $pdf->Cell(100,10,$receipt_no,0,1); $pdf->Cell(50,10,'Date:',0,0); $pdf->Cell(100,10,$date,0,1); $pdf->Cell(50,10,'Patient Name:',0,0); $pdf->Cell(100,10,$name,0,1); $pdf->Cell(50,10,'Mobile:',0,0); $pdf->Cell(100,10,$phone,0,1); $pdf->Cell(50,10,'Doctor:',0,0); $pdf->Cell(100,10,$doctor,0,1); // Fees Box $pdf->Ln(10); $pdf->SetFillColor(230,230,230); $pdf->Cell(140,10,'Description',1,0,'C',true); $pdf->Cell(50,10,'Amount (INR)',1,1,'C',true); $pdf->Cell(140,10,'Consultation Fees',1,0); $pdf->Cell(50,10,$fee . '/-',1,1,'R'); $pdf->SetFont('Arial','B',12); $pdf->Cell(140,10,'Total Paid',1,0,'R'); $pdf->Cell(50,10,$fee . '/-',1,1,'R'); // Footer $pdf->Ln(20); $pdf->SetFont('Arial','I',10); $pdf->Cell(190,10,'(This is a computer generated receipt)',0,1,'C'); // Save to Server $pdf->Output('F', $filepath); // 3. Insert into Database $stmt = $conn->prepare("INSERT INTO patient_entries (patient_name, phone, email, doctor, visit_date, consultation_fee, pdf_file) VALUES (?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param("sssssis", $name, $phone, $email, $doctor, $date, $fee, $filename); if ($stmt->execute()) { // 4. Send Email if(!empty($email)) { $subject = "Your OPD Receipt - Aastha Hospital"; $message = "Dear $name,\n\nThank you for visiting Aastha Padghan Medical.\n\nYour appointment with $doctor is confirmed.\n\nYou can download your receipt here:\n$webpath\n\nRegards,\nAastha Hospital Team"; $headers = "From: no-reply@aasthapadghanhospital.com"; mail($email, $subject, $message, $headers); $msg = "Entry Saved, PDF Generated & Email Sent!"; } else { $msg = "Entry Saved & PDF Generated (No Email provided)."; } } else { $msg = "Error: " . $conn->error; } } ?> Patient Entry

🏥 New Patient Entry

$msg

"; ?>

Recent Entries

query("SELECT * FROM patient_entries ORDER BY id DESC LIMIT 10"); while($row = $res->fetch_assoc()) { echo '
'; echo '
'; echo '

' . $row['patient_name'] . '

'; echo '

' . $row['doctor'] . ' | ' . $row['visit_date'] . '

'; echo '
'; echo '
'; echo 'View PDF'; echo '
'; echo '
'; } ?>