debug_tool_quiz.php

<?php
require_once("includes/config.php");

$tool_id = 'TESTIN';
$course_id = 'CVBG';

echo "Checking for quizzes with course_id=$course_id and tool_id=$tool_id\n\n";

try {
    // Check if tool exists
    $tool_query = $con->prepare("SELECT * FROM tools_master WHERE tool_id=? AND course_id=?");
    $tool_query->execute([$tool_id, $course_id]);
    $tool_result = $tool_query->fetch(PDO::FETCH_ASSOC);

    echo "Tool exists: " . ($tool_result ? "YES" : "NO") . "\n";
    if($tool_result) {
        echo "Tool details: ";
        print_r($tool_result);
    }
    echo "\n";

    // Check quizzes
    $quiz_query = $con->prepare("SELECT * FROM course_tool_quiz_master WHERE course_id=? AND tool_id=?");
    $quiz_query->execute([$course_id, $tool_id]);
    $quizzes = $quiz_query->fetchAll(PDO::FETCH_ASSOC);

    echo "Found " . count($quizzes) . " quizzes\n";
    if(count($quizzes) > 0) {
        print_r($quizzes);
    }

    // Check all tools for this course
    echo "\n\nAll tools in course $course_id:\n";
    $all_tools = $con->prepare("SELECT tool_id, tool_name FROM tools_master WHERE course_id=?");
    $all_tools->execute([$course_id]);
    $all_tools_result = $all_tools->fetchAll(PDO::FETCH_ASSOC);
    print_r($all_tools_result);

} catch(Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
?>