real_escape_string($_GET['search']); $sql .= " AND (patient_name LIKE '%$search%' OR phone LIKE '%$search%')"; } if (!empty($_GET['doctor'])) { $doctor = $conn->real_escape_string($_GET['doctor']); $sql .= " AND doctor = '$doctor'"; } if (!empty($_GET['from_date']) && !empty($_GET['to_date'])) { $from_date = $_GET['from_date']; $to_date = $_GET['to_date']; $sql .= " AND visit_date BETWEEN '$from_date' AND '$to_date'"; } } $sql .= " ORDER BY id DESC"; $result = $conn->query($sql); ?> Patient History | Reception

🔍 Filter & Search Records

Reset

Total Records Found: num_rows; ?>

num_rows > 0) { while($row = $result->fetch_assoc()) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } } else { echo ''; } ?>
Date Receipt # Patient Name Phone Doctor Fee Receipt
' . date('d-M-Y', strtotime($row['visit_date'])) . '' . $row['id'] . '' . $row['patient_name'] . '' . $row['phone'] . '' . $row['doctor'] . '₹' . $row['consultation_fee'] . ''; if(!empty($row['pdf_file'])) { echo 'PDF'; } else { echo 'N/A'; } echo '
No records found for the selected filters.