query($sql); return ($result) ? ($result->fetch_assoc()['count'] ?? 0) : 0; } $wait_count = get_count($conn, "SELECT COUNT(*) as count FROM patient_entries WHERE visit_date = '$today' AND doctor = '$current_doctor' AND status = 'Waiting'"); $done_count = get_count($conn, "SELECT COUNT(*) as count FROM patient_entries WHERE visit_date = '$today' AND doctor = '$current_doctor' AND status = 'Completed'"); ?> <?php echo $current_doctor; ?>'s Desk

Waiting Now

Checked Today

Today's Date

📅 IST

⏳ Patient Queue Live Updates

query($sql); if ($result && $result->num_rows > 0) { while($row = $result->fetch_assoc()) { ?>

📱

Token #
Start Checkup
☕

No patients waiting in queue.

All clear, $current_doctor!

"; } ?>

✅ Completed Consultations (Today)

query($done_sql); if ($done_res && $done_res->num_rows > 0) { while($row = $done_res->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } ?>
Patient Name Diagnosis Action
{$row['patient_name']}{$row['diagnosis']} View Rx
No completed cases yet.