JezK

Edit File: get_questions.php

<?php
// Database connection
require_once 'db_connection.php';

// Function to fetch survey responses, questions, and suggestions
function fetchSurveyResponses($complaintId, $tableName, $questionTable, $suggestionsTable, $status) {
    global $conn;

// Fetch survey responses
    $sql_responses = "SELECT question_id, answer_option FROM $tableName WHERE complaint_id = $complaintId";
    $result_responses = $conn->query($sql_responses);

// Fetch suggestions
    $sql_suggestion = "SELECT suggestion FROM $suggestionsTable WHERE teacherId = $complaintId AND status = $status";
    $result_suggestion = $conn->query($sql_suggestion);
    $suggestion = ($result_suggestion->num_rows > 0) ? $result_suggestion->fetch_assoc()['suggestion'] : '';

if ($result_responses->num_rows > 0) {
        while ($row = $result_responses->fetch_assoc()) {
            $questionId = $row['question_id'];
            $answerOption = $row['answer_option'];
            
            // Fetch question text
            $sql_question = "SELECT question FROM $questionTable WHERE id = $questionId";
            $result_question = $conn->query($sql_question);
            if ($result_question->num_rows > 0) {
                $row_question = $result_question->fetch_assoc();
                $question = $row_question['question'];
                
                // Display question
                echo "<input type='hidden' name='question_ids[]' value='$questionId'>"; 
                echo "<p><strong>$question</strong></p>";
                
                // Display response options
                $options = explode(', ', $answerOption);
                foreach ($options as $option) {
                    echo "<input type='radio' name='answers[$questionId]' value='$option' ";
                    if ($option === $answerOption) {
                        echo "checked"; // Check the radio button if the option matches the answer
                    }
                    echo "> $option<br>";
                }
                echo "<hr>";
            } else {
                echo "Question not found for question_id: $questionId";
            }
        }
    } else {
        echo "No survey responses available for this complaint.";
    }

// Display suggestions textarea
    echo "<p><strong>Suggestions:</strong></p>";
    echo "<textarea name='suggestions' rows='4' cols='50'>$suggestion</textarea><br><br>";
}

// Check if complaint ID is set
if (isset($_GET['id']) && isset($_GET['type'])) {
    $complaintId = $_GET['id'];
    $complaintType = $_GET['type'];

// Define table names based on complaint type
    switch ($complaintType) {
        case 'student':
            $tableName = 'student_responses';
            $questionTable = 'student_questions';
            $suggestionsTable = 'suggestions';
            $status = 2;
            break;
        case 'teacher':
            $tableName = 'survey_responses';
            $questionTable = 'survey_questions';
            $suggestionsTable = 'suggestions';
            $status = 1;
            break;
        default:
            echo "Invalid complaint type";
            exit;
    }

// Fetch and display survey responses, questions, and suggestions
    fetchSurveyResponses($complaintId, $tableName, $questionTable, $suggestionsTable, $status);

} else {
    echo "Complaint ID or type not provided";
}

// Close database connection
$conn->close();
?>