/home/techb158/workloadmatch.com/Manager
Edit:
prepare("
SELECT tp.Teacher_ID, CONCAT(tp.First_Name, ' ', tp.Last_Name) AS name, tp.User_Img, tp.Profile_Status,
(SELECT COUNT(*) FROM chat_messages WHERE receiver_id = ? AND receiver_type = 'manager' AND sender_id = tp.Teacher_ID AND is_read = 0) AS unread
FROM Teacher_Profile tp
WHERE tp.Manager_ID = ?
ORDER BY tp.First_Name ASC
");
$stmt->bind_param("is", $manager_id, $manager_id);
$stmt->execute();
$res = $stmt->get_result();
while ($row = $res->fetch_assoc()) {
$teachers[] = $row;
}
$stmt->close();
$totalUnread = 0;
foreach ($teachers as $t) { $totalUnread += (int)$t['unread']; }
?>
/home/techb158/workloadmatch.com/Manager/chat_bak.php.disabled (10265B)
Teachers 0): ?>
; ?>)
0): ?>
Select a teacher to start chatting