<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once 'controller/DB_Config.php';

$con = OpenCon();

$stmt = $con->prepare("SELECT page_url, name FROM `courses` LIMIT 5");
if ($stmt) {
    echo "Querying courses...<br>";
    if ($stmt->execute()) {
        $stmt->bind_result($purl, $name);
        while ($stmt->fetch()) {
            echo "Course: $name, URL: $purl <br>";
        }
    } else {
        echo "Execute failed: " . $stmt->error . "<br>";
    }
} else {
    echo "Prepare failed: " . $con->error . "<br>";
}

CloseCon($con);
?>