<?php
try {
    require 'config.php';
    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USERNAME, DB_PASSWORD);
    
    $courses = $pdo->query("SELECT id, course_name, short_name, course_type, category_id, sub_category_id FROM courses ORDER BY id DESC LIMIT 15")->fetchAll(PDO::FETCH_ASSOC);
    print_r($courses);
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}