<?php

<h2>Sample JSON Response</h2>

<pre>
{
    "status": true,
    "message": "Questions retrieved successfully",
    "data": [
        {
            "id": 1,
            "set_name": "SET 1",
            "section_name": "SECTION 1: LISTENING TEST",
            "part_name": "Part 1: Listening to Problem Solving",
            "question": "Where is the recreation centre located?",
            "options": [
                "(A) Oak Street and First Avenue",
                "(B) Oak Street and Third Avenue",
                "(C) Third Avenue and Maple Street",
                "(D) Riverside Drive and Oak Street"
            ],
            "answer": "B"
        }
    ]
}
</pre>


<h2>Database Table Structure</h2>

<pre>
CREATE TABLE celpip_questions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    set_name VARCHAR(255),
    section_name VARCHAR(255),
    part_name VARCHAR(255),
    question TEXT,
    options JSON,
    answer VARCHAR(10)
);
</pre>


<h2>Media Directories</h2>

<p><strong>Images:</strong></p>
<pre>
https://oddroadmin.moneycardwave.com/questionbank/images/
</pre>

<p><strong>Audio:</strong></p>
<pre>
https://oddroadmin.moneycardwave.com/questionbank/audio/
</pre>


<h2>Recommended Security Improvements</h2>

<ul>
    <li>Use HTTPS only</li>
    <li>Rotate API keys periodically</li>
    <li>Restrict API by IP address if possible</li>
    <li>Add JWT authentication for advanced deployments</li>
    <li>Add request rate limiting</li>
</ul>

</div>

</body>
</html>