???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................query($sql); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $admissions[] = $row; } } // Summary counts $total_admissions_overall = 0; $resCount = $conn->query("SELECT COUNT(*) AS cnt FROM admission"); if ($resCount) { $total_admissions_overall = (int)$resCount->fetch_assoc()['cnt']; } $course_admissions_count = null; // null means no course selected if (!empty($selected_course)) { $resCourseCnt = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE course='" . $selected_course . "'"); if ($resCourseCnt) { $course_admissions_count = (int)$resCourseCnt->fetch_assoc()['cnt']; } } $matching_results_count = count($admissions); // Courses for dropdown $courses = []; $csql = "SELECT course FROM course ORDER BY course ASC"; $cres = $conn->query($csql); if ($cres && $cres->num_rows > 0) { while ($r = $cres->fetch_assoc()) { if (!empty($r['course'])) { $courses[] = $r['course']; } } } // Remove duplicates just in case $courses = array_values(array_unique($courses)); // Admissions Today $today_admissions = 0; $resToday = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE DATE(created_at) = CURDATE()"); if ($resToday) { $today_admissions = (int)$resToday->fetch_assoc()['cnt']; } // Admissions in Last 7 Days (including today) $last7_admissions = 0; $res7 = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)"); if ($res7) { $last7_admissions = (int)$res7->fetch_assoc()['cnt']; } // Admissions in Last 30 Days $last30_admissions = 0; $res30 = $conn->query("SELECT COUNT(*) AS cnt FROM admission WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)"); if ($res30) { $last30_admissions = (int)$res30->fetch_assoc()['cnt']; } $a = 0; ?> Admission Report |Xcel Training Institute

Admission Report

Total Admissions (All)
Admissions Today
Last 7 Days
Last 30 Days
Admissions in Selected Course

Clear
S.No. Admission No Student Name Course Duration Payable Amount Added By Contact Date Action
No admissions found
₹