fetchOne("SELECT category_id FROM courses LIMIT 1");
$isLiveSchema = true;
} catch(Exception $e) {}
if ($isLiveSchema) {
$course = $db->fetchOne("
SELECT c.*, cat.name as cat_name, sub.name as sub_name
FROM courses c
LEFT JOIN course_categories cat ON c.category_id = cat.id
LEFT JOIN course_sub_categories sub ON c.sub_category_id = sub.id
WHERE c.id = ? AND c.is_active = 1
", [$id]);
} else {
$course = $db->fetchOne("
SELECT c.*, c.short_name as cat_name, c.category as sub_name
FROM courses c
WHERE c.id = ? AND c.is_active = 1
", [$id]);
}
if (!$course) {
header('Location: all-courses.php');
exit;
}
// Fetch fee for college
$fee = $db->fetchOne("SELECT total_fee FROM course_fees WHERE course_id = ? AND user_type='college'", [$id]);
$totalFee = $fee ? floatval($fee['total_fee']) : 0;
// Visual metadata
$cat = $course['cat_name'] ?? 'General';
$bannerImg = 'https://images.unsplash.com/photo-1523240795612-9a054b0db644?w=1600';
if (stripos($cat, 'Computer') !== false) $bannerImg = 'https://images.unsplash.com/photo-1517694712202-14dd9538aa97?w=1600';
if (stripos($cat, 'Automobile') !== false) $bannerImg = 'https://images.unsplash.com/photo-1492144534655-ae79c964c9d7?w=1600';
if (stripos($cat, 'Aviation') !== false) $bannerImg = 'https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=1600';
if (stripos($cat, 'Medical') !== false || stripos($cat, 'Ayurveda') !== false || stripos($cat, 'Health') !== false) $bannerImg = 'https://images.unsplash.com/photo-1512069772995-ec65ed45afd6?w=1600';
if (stripos($cat, 'Civil') !== false) $bannerImg = 'https://images.unsplash.com/photo-1503387762-592deb58ef4e?w=1600';
if (!empty($course['image'])) {
$bannerImg = $course['image'];
}
$courseName = $course['course_name'];
$pageTitle = htmlspecialchars($courseName) . ' Course Details, Duration & Fee structure | IBVTE';
$pageDesc = 'Get details about ' . htmlspecialchars($courseName) . ' in the ' . htmlspecialchars($cat) . ' department at IBVTE. View eligibility, course duration, total fees, and syllabus details.';
include 'includes/header.php';
?>
Course Highlights
Course Overview
Modern Curriculum
Expert Faculty
Industry Internship
Placement Assistance