Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
backup	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxr-sr-x
halltickets	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxr-sr-x
img	[ DIR ]	drwxr-sr-x
imported_files	[ DIR ]	drwxrwsrwx
misc_files	[ DIR ]	drwxrwsrwx
notifications	[ DIR ]	drwxrwxrwx
student_photos	[ DIR ]	drwxrwsrwx
study_material	[ DIR ]	drwxrwsrwx
teacher_photos	[ DIR ]	drwxrwsrwx
tmpphotos	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
MainPage.html	21.65 KB	-rwxr-xr-x
collegeInfoPopup.html	4.35 KB	-rwxr-xr-x
docverify.php	818 B	-rw-rw-r--
flash.html	2.23 KB	-rwxr-xr-x
forgotpassword.html	3.38 KB	-rwxr-xr-x
getAppdet.php	8 KB	-rw-rw-r--
gtransapi.js	212.95 KB	-rw-r--r--
homepage.html	3.35 KB	-rwxr-xr-x
index.php	5.08 KB	-rwxr-xr-x
index_old.html	6.23 KB	-rwxr-xr-x
indexlogin.html	6.18 KB	-rwxr-xr-x
pgadm.php	13.76 KB	-rw-rw-r--
quiz_upd.php	13.19 KB	-rwxr-xr-x
quiz_view.php	7.3 KB	-rwxr-xr-x
saveQuiz.php	2.72 KB	-rwxr-xr-x
test.html	854 B	-rw-r--r--
upload_qz.php	581 B	-rwxr-xr-x
upload_studymat_bcu.php	621 B	-rwxr-xr-x

Code Editor : saveQuiz.php

<?php

$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "Logisys2104";

$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$db = "logisys3_dud";

$type = $_POST['type'];

if($type == 'loadsub')
{

$degree = $_POST['degree'];
    $sem = $_POST['sem'];

$Query = "select distinct s.fsubcode, s.fsubname FROM {$db}.subject s
    where fintass = 'F'  and fdegree = '{$degree}'
    and fexamno = '{$sem}'";
    //var_dump($Query);
	$result = mysqli_query($conn, $Query);
	$i=0;
	while($row = mysqli_fetch_assoc($result))
	{
		$row1[$i] = $row;
		$i++;
	}

echo json_encode($row1);
	return;
} else if($type == 'study')
{
  
    $topic = $_POST['topic'];
    $name = $_POST['name'];
    $mob = $_POST['mob'];
    $coll = $_POST['coll'];
    $path = $_POST['path'];
    $email = $_POST['email'];

$query = "insert into {$db}.qztran(fid,fname,fmobileno,fcollege,fpath,femail)
         values('{$topic}','{$name}','{$mob}','{$coll}','{$path}','{$email}')";
    $result = mysqli_query($conn, $query);
    $id = $conn->insert_id;
    
    if($result)
    {
        $data = "Uploaded Successfully. Your Application No is : ".$id;

echo json_encode($data);
        return;
    }else
    {
        $data = "Upload failure. Please try after some time!";
        echo json_encode($data);
        return;
    }   
} else if($type == 'studyappr')
{

$status = $_POST['status'];
    $cnd = "and q.fid = '{$status}'";
    if($status == 'All')
    {
        $cnd = "";
    }

$Query = "select t.fdescpn,fname,fmobileno,fcollege,femail,fpath,date_format(fcreated,'%d/%m%Y %h:%m %p') as fcreated,fappno
     from {$db}.qztran q inner join {$db}.qztopic t on q.fid = t.fid
    where ifnull(t.fdeleted,'') <> 'T'
    $cnd
    order by fcreated desc";
    //var_dump($Query);
	$result = mysqli_query($conn, $Query);
	$i=0;
	while($row = mysqli_fetch_assoc($result))
	{
		$row1[$i] = $row;
		$i++;
    }

if($result)
    {
        $arr['data'] = $row1;
        $arr['error_code'] = 0;
        echo json_encode($arr);
        return;
    }else
    {
        $arr['data'] = "No Data Found!";
        $arr['error_code'] = -1;
        echo json_encode($arr);
        return;
    }   
    
}else if($type =='appstudymat')
{
    $id = $_POST['id'];
    $update = "update {$db}.osmmain set FAPPRSTATUS = 'approved', FAPPRDATE = now()
    where FOSMID = '{$id}'"; 
    $result = mysqli_query($conn, $update);

if($result)
    {
        $arr = "Approved Successfully";
        echo json_encode($arr);
        return;
    }else
    {
        $arr = "Approve Failed. Please try again";
        echo json_encode($arr);
        return;
    }

}

${this.title}

Code Editor : saveQuiz.php