MMCT TEAM
Server IP : 2a02:4780:3:1493:0:3736:a38e:7  /  Your IP : 216.73.216.139
Web Server : LiteSpeed
System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64
User : u926327694 ( 926327694)
PHP Version : 7.4.33
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u926327694/domains/smsoft.in/public_html/mda/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u926327694/domains/smsoft.in/public_html/mda/fetch_subjects.php
<?php
include('db.php');
if(isset($_SESSION['userData']))
{
	if(isset($_POST['exam_id']))
	{
		$examArray = mysqli_real_escape_string($con, $_POST["exam_id"]);
		$examEx = explode('~',$examArray);
		$exam_id = $examEx[0];
        $query = "SELECT sub.Subject_ID, sub.Subject_Name FROM DimExam_Table as ex inner join DimSubject_Table as sub on sub.Subject_ID = ex.Subject_ID WHERE Exam_id = '$exam_id' group by sub.Subject_ID";
        $result = mysqli_query($con, $query);
    
        while($row = mysqli_fetch_assoc($result)) {
            echo '<option value="'.$row['Subject_ID'].'~'.$row['Subject_Name'].'">'.$row['Subject_Name'].' ('.$row['Subject_ID'].')</option>';
        }
	}
}
?>

MMCT - 2023