fetchOne("SELECT id, name FROM course_categories WHERE slug=?", [$catSlug]);
if (!$cat) {
echo "
Category not found
";
include 'includes/footer.php';
exit;
}
if (!$type) {
$allTypes = [
'Vocational Course',
'Diploma Course',
'Short Term Course',
'Certificate Course',
'Other Course'
];
$types = [];
$isLiveSchema = false;
try {
$db->fetchOne("SELECT category_id FROM courses LIMIT 1");
$isLiveSchema = true;
} catch (Exception $e) {}
foreach ($allTypes as $t) {
$matchType = str_replace(' Course', '', $t);
$matchCat = str_replace([' Education', ' Courses'], '', $cat['name']);
if ($isLiveSchema) {
$where = "category_id = {$cat['id']} AND (course_type LIKE ? OR course_type LIKE ?) AND is_active=1";
$params = ['%' . $matchType . '%', '%' . $t . '%'];
if ($t === 'Other Course') {
$where = "category_id = {$cat['id']} AND is_active=1 AND course_type NOT LIKE '%Vocational%' AND course_type NOT LIKE '%Diploma%' AND course_type NOT LIKE '%Short Term%' AND course_type NOT LIKE '%Certificate%'";
$params = [];
}
} else {
$where = "short_name LIKE ? AND category LIKE ? AND is_active=1";
$params = ['%' . $matchCat . '%', '%' . $t . '%'];
if ($t === 'Other Course') {
$where = "short_name LIKE ? AND is_active=1 AND category NOT LIKE '%Vocational%' AND category NOT LIKE '%Diploma%' AND category NOT LIKE '%Short Term%' AND category NOT LIKE '%Certificate%'";
$params = ['%' . $matchCat . '%'];
}
}
$count = $db->fetchOne("SELECT COUNT(id) as cnt FROM courses WHERE $where", $params);
if ($count && $count['cnt'] > 0) {
$types[] = $t;
}
}
?>
fetchOne("SELECT category_id FROM courses LIMIT 1");
$isLiveSchema = true;
} catch (Exception $e) {
$isLiveSchema = false;
}
if ($isLiveSchema) {
$where = "c.category_id = {$cat['id']} AND (c.course_type LIKE ? OR c.course_type LIKE ?) AND c.is_active=1";
$params = ['%' . $matchType . '%', '%' . $type . '%'];
if ($type === 'Other Course') {
$where = "c.category_id = {$cat['id']} AND c.is_active=1 AND c.course_type NOT LIKE '%Vocational%' AND c.course_type NOT LIKE '%Diploma%' AND c.course_type NOT LIKE '%Short Term%' AND c.course_type NOT LIKE '%Certificate%'";
$params = [];
}
} else {
$where = "c.short_name LIKE ? AND c.category LIKE ? AND c.is_active=1";
$params = ['%' . $matchCat . '%', '%' . $type . '%'];
if ($type === 'Other Course') {
$where = "c.short_name LIKE ? AND c.is_active=1 AND c.category NOT LIKE '%Vocational%' AND c.category NOT LIKE '%Diploma%' AND c.category NOT LIKE '%Short Term%' AND c.category NOT LIKE '%Certificate%'";
$params = ['%' . $matchCat . '%'];
}
}
// Remove LEFT JOIN course_sub_categories since it doesn't exist, to prevent SQL errors
$courses = $db->fetchAll("SELECT c.*, cf.total_fee
FROM courses c
LEFT JOIN course_fees cf ON c.id = cf.course_id AND cf.user_type='college'
WHERE $where
ORDER BY c.display_order, c.course_name", $params);
?>
fetchOne("SELECT category_id FROM courses LIMIT 1"); $isLive = true; } catch(Exception $e) {}
if ($isLive) {
$categories = $db->fetchAll("SELECT * FROM course_categories WHERE is_active=1 AND EXISTS (SELECT 1 FROM courses c WHERE c.category_id = course_categories.id AND c.is_active = 1) ORDER BY display_order, name");
} else {
$categories = $db->fetchAll("SELECT * FROM course_categories WHERE is_active=1 AND EXISTS (SELECT 1 FROM courses c WHERE c.short_name COLLATE utf8mb4_unicode_ci = course_categories.name COLLATE utf8mb4_unicode_ci AND c.is_active = 1) ORDER BY display_order, name");
}
?>