0) {
$doc_row = mysqli_fetch_assoc($doc_query);
$current_doctor_name = $doc_row['dr_name'];
} else {
// If doctor not found, use the default doctor name
$current_doctor_name = $default_doctor_name;
}
}
?>
S.No
Receipt No
Name
Booked Date
Mobile No
Appointment Date
Doctor
= '2021-12-17'
$doctor_filter
ORDER BY appointment_date ASC";
$get_arr = $DB->query($get_split);
if(mysql_num_rows($get_arr) > 0):
while($get_split_row = mysql_fetch_array($get_arr)):
$si = 0;
?>
0):
while($row = mysql_fetch_array($result)):
$si++;
$appointment_id = $row['id'];
$member_id = $row['mem_id'];
$upd_sta = $row['update_status'];
$appointment_date = date('Y-m-d', strtotime($row["appointment_date"]));
$current_date = date('Y-m-d');
// Check for duplicate phone numbers
$phone_check = mysql_query("SELECT * FROM tbl_appointment_office
WHERE status = 1
AND mobile_no = '".$row['mobile_no']."'
AND appointment_date = '{$get_split_row['app_date']}'");
$num_check = mysql_num_rows($phone_check);
$highlight = $num_check > 1 ? 1 : 0;
// Get doctor name dynamically from database
$doctor_name = $default_doctor_name; // Default to doctor ID=1 name
if(!empty($row['doctor'])) {
$doc_query = mysql_query("SELECT dr_name FROM tbl_doctors WHERE id = '{$row['doctor']}'");
if(mysql_num_rows($doc_query) > 0) {
$doc_row = mysql_fetch_array($doc_query);
$doctor_name = $doc_row['dr_name'];
}
}
?>