HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
File: /var/www/content-sp/work-sp/nqb_master_wise_questions_subject_wise.php
<?php

$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_EDITORS = 'csp_editors';
$SP_QUESTION = 'csp_sp_question';

echo $masterId = $_REQUEST['masterId'];
echo $mediumId = $_REQUEST['mediumId'];

echo $getQnQuery = "select q.subject_id, count(q.question_id) as qcnt from $SP_QUESTION as q where q.subject_id='$masterId' and q.medium_id='$mediumId' group by q.subject_id order by q.master_id";
$getQnData = $conn->query($getQnQuery);

?>