<?php
require_once 'controller/DB_Config.php';

// Allow from any origin if needed, or stick to same origin
header('Content-Type: application/json');

$con = OpenCon();

$search = isset($_GET['q']) ? trim($_GET['q']) : '';

if(empty($search)) {
    echo json_encode([]);
    CloseCon($con);
    exit;
}

// We only want courses that have a parent_course_id (meaning they are actual courses, not categories)
$sql = "SELECT id, name, page_url FROM courses WHERE delete_status = 'N' AND parent_course_id IS NOT NULL AND (name LIKE ? OR title LIKE ?) LIMIT 8";
$stmt = $con->prepare($sql);

$like_search = "%" . $search . "%";
$stmt->bind_param("ss", $like_search, $like_search);
$stmt->execute();
$result = $stmt->get_result();

$courses = [];
while($row = $result->fetch_assoc()) {
    $courses[] = [
        'id' => $row['id'],
        'name' => $row['name'],
        'url' => 'course/' . $row['page_url'] . '.php'
    ];
}

$stmt->close();
CloseCon($con);

echo json_encode($courses);
?>