<?php
ini_set('display_errors', 1);
require_once 'controller/DB_Config.php';
$con = OpenCon();

echo "<h2>Categories and Courses</h2>";

// Fetch Categories
$sql_cats = "SELECT id, name FROM `courses` WHERE `parent_course_id` IS NULL AND delete_status = 'N' ORDER BY sort_order ASC";
$result_cats = mysqli_query($con, $sql_cats);

if ($result_cats) {
    while ($cat = mysqli_fetch_assoc($result_cats)) {
        echo "<h3>" . $cat['name'] . " (ID: " . $cat['id'] . ")</h3><ul>";
        
        // Fetch Courses for this Category
        $cat_id = $cat['id'];
        $sql_courses = "SELECT name, page_url FROM `courses` WHERE `parent_course_id` = $cat_id AND delete_status = 'N' ORDER BY sort_order ASC";
        $result_courses = mysqli_query($con, $sql_courses);
        
        if ($result_courses && mysqli_num_rows($result_courses) > 0) {
            while ($course = mysqli_fetch_assoc($result_courses)) {
                echo "<li><a href='course/" . $course['page_url'] . ".php'>" . $course['name'] . "</a></li>";
            }
        } else {
            echo "<li>No courses found.</li>";
        }
        echo "</ul>";
    }
} else {
    echo "Error fetching categories: " . mysqli_error($con);
}

CloseCon($con);
?>