<?php
define('IBVTE_ACCESS', true);
require 'config.php';
require 'includes/db.php';
try {
    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USERNAME, DB_PASSWORD);
    $stmt = $pdo->query("SELECT id, name, is_active FROM course_categories");
    print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
    $stmt = $pdo->query("SELECT id, course_code, category_id, is_active FROM courses WHERE is_active=1 AND id < 120");
    print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
} catch (Exception $e) {}