Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Excel_Writer	[ DIR ]	drwxr-xr-x
Excel_reader	[ DIR ]	drwxr-xr-x
JQGrid3.5	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxrwxr-x
Report_details	[ DIR ]	drwxr-xr-x
Report_details03.05.2016	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxrwxrwx
copodoc	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxr-xr-x
css_old	[ DIR ]	drwxr-xr-x
cssold	[ DIR ]	drwxr-xr-x
custom_js	[ DIR ]	drwxrwxr-x
custom_js_old_21082021	[ DIR ]	drwxr-xr-x
custom_src	[ DIR ]	drwxrwxr-x
custom_src_old_21082021	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
grid_display_files	[ DIR ]	drwxr-xr-x
halltickets	[ DIR ]	drwxrwxrwx
html_modules	[ DIR ]	drwxr-xr-x
html_modules03.05.2016	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
imported_files	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxr-xr-x
js03.05.2016	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
misc_files	[ DIR ]	drwxrwxrwx
schema	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
src03.05.2016	[ DIR ]	drwxr-xr-x
student_photos	[ DIR ]	drwxrwxrwx
tarka_pdf	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
tmpphotos	[ DIR ]	drwxrwxrwx
user_images	[ DIR ]	drwxr-xr-x
validation_files	[ DIR ]	drwxr-xr-x
.htaccess	602 B	-rwxr-xr-x
Annexure 1 Process for IA mark...	933.28 KB	-rw-rw-r--
Annexure 2_Guidelines for Crea...	1.23 MB	-rw-rw-r--
Annexure 3_Guidelines for Stud...	1.04 MB	-rw-rw-r--
Demo_Of_Exam_Automation.mp4	92.39 MB	-rwxr-xr-x
IA Schedule - 2021-22 - Revise...	274.86 KB	-rw-rw-r--
MainPage.html	15.98 KB	-rwxr-xr-x
MainPage03.05.2016.html	11.04 KB	-rwxr-xr-x
MainPage20092016.html	12.3 KB	-rwxr-xr-x
MainPagepopup.html	7.05 KB	-rwxr-xr-x
MainPagepopup03.05.2016.html	7.05 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	919 B	-rwxr-xr-x
collegeInfoPopup.html	3.76 KB	-rwxr-xr-x
docverify.php	818 B	-rwxr-xr-x
enableht.php	2.56 KB	-rwxr-xr-x
getQPdet.php	5.34 KB	-rwxr-xr-x
getQPdet_dud.php	7.14 KB	-rwxr-xr-x
homepage.html	3.05 KB	-rwxr-xr-x
homepage03.05.2016.html	2.76 KB	-rwxr-xr-x
homepage20092016.html	3.35 KB	-rwxr-xr-x
index.html	7.06 KB	-rwxr-xr-x
index03.05.2016.html	5.12 KB	-rwxr-xr-x
index20092016.html	5.88 KB	-rwxr-xr-x
indexlatest.html	5.16 KB	-rwxr-xr-x
indexlogin.html	5.75 KB	-rwxr-xr-x
indexlogin20092016.html	5.81 KB	-rwxr-xr-x
indexold.html	5.19 KB	-rwxr-xr-x
mainpage.htm	31.7 KB	-rwxr-xr-x
paytm_res.php	6.48 KB	-rwxr-xr-x
reva_api.php	2.2 KB	-rwxr-xr-x
sumreport.xls	77.75 KB	-rwxr-xr-x
valdet.php	12.01 KB	-rwxr-xr-x
valdet_dud.php	10 KB	-rwxr-xr-x

Name

Size

Permission

Action

Excel_Writer

[ DIR ]

drwxr-xr-x

Excel_reader

[ DIR ]

drwxr-xr-x

JQGrid3.5

[ DIR ]

drwxr-xr-x

PHPExcel

[ DIR ]

drwxrwxr-x

Report_details

[ DIR ]

drwxr-xr-x

Report_details03.05.2016

[ DIR ]

drwxr-xr-x

backup

[ DIR ]

drwxrwxrwx

copodoc

[ DIR ]

drwxrwxrwx

css

[ DIR ]

drwxr-xr-x

css_old

[ DIR ]

drwxr-xr-x

cssold

[ DIR ]

drwxr-xr-x

custom_js

[ DIR ]

drwxrwxr-x

custom_js_old_21082021

[ DIR ]

drwxr-xr-x

custom_src

[ DIR ]

drwxrwxr-x

custom_src_old_21082021

[ DIR ]

drwxr-xr-x

easy_zip

[ DIR ]

drwxr-xr-x

grid_display_files

[ DIR ]

drwxr-xr-x

halltickets

[ DIR ]

drwxrwxrwx

html_modules

[ DIR ]

drwxr-xr-x

html_modules03.05.2016

[ DIR ]

drwxr-xr-x

images

[ DIR ]

drwxr-xr-x

img

[ DIR ]

drwxr-xr-x

imported_files

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxr-xr-x

js03.05.2016

[ DIR ]

drwxr-xr-x

libs

[ DIR ]

drwxr-xr-x

maya-pdf

[ DIR ]

drwxr-xr-x

misc_files

[ DIR ]

drwxrwxrwx

schema

[ DIR ]

drwxr-xr-x

src

[ DIR ]

drwxr-xr-x

src03.05.2016

[ DIR ]

drwxr-xr-x

student_photos

[ DIR ]

drwxrwxrwx

tarka_pdf

[ DIR ]

drwxr-xr-x

tarka_pdf_latest

[ DIR ]

drwxr-xr-x

tcpdf

[ DIR ]

drwxr-xr-x

tmpphotos

[ DIR ]

drwxrwxrwx

user_images

[ DIR ]

drwxr-xr-x

validation_files

[ DIR ]

drwxr-xr-x

.htaccess

602 B

-rwxr-xr-x

Annexure 1 Process for IA mark...

933.28 KB

-rw-rw-r--

Annexure 2_Guidelines for Crea...

1.23 MB

-rw-rw-r--

Annexure 3_Guidelines for Stud...

1.04 MB

-rw-rw-r--

Demo_Of_Exam_Automation.mp4

92.39 MB

-rwxr-xr-x

IA Schedule - 2021-22 - Revise...

274.86 KB

-rw-rw-r--

MainPage.html

15.98 KB

-rwxr-xr-x

MainPage03.05.2016.html

11.04 KB

-rwxr-xr-x

MainPage20092016.html

12.3 KB

-rwxr-xr-x

MainPagepopup.html

7.05 KB

-rwxr-xr-x

MainPagepopup03.05.2016.html

7.05 KB

-rwxr-xr-x

app.php

416 B

-rwxr-xr-x

cconfig.php

919 B

-rwxr-xr-x

collegeInfoPopup.html

3.76 KB

-rwxr-xr-x

docverify.php

818 B

-rwxr-xr-x

enableht.php

2.56 KB

-rwxr-xr-x

getQPdet.php

5.34 KB

-rwxr-xr-x

getQPdet_dud.php

7.14 KB

-rwxr-xr-x

homepage.html

3.05 KB

-rwxr-xr-x

homepage03.05.2016.html

2.76 KB

-rwxr-xr-x

homepage20092016.html

3.35 KB

-rwxr-xr-x

index.html

7.06 KB

-rwxr-xr-x

index03.05.2016.html

5.12 KB

-rwxr-xr-x

index20092016.html

5.88 KB

-rwxr-xr-x

indexlatest.html

5.16 KB

-rwxr-xr-x

indexlogin.html

5.75 KB

-rwxr-xr-x

indexlogin20092016.html

5.81 KB

-rwxr-xr-x

indexold.html

5.19 KB

-rwxr-xr-x

mainpage.htm

31.7 KB

-rwxr-xr-x

paytm_res.php

6.48 KB

-rwxr-xr-x

reva_api.php

2.2 KB

-rwxr-xr-x

sumreport.xls

77.75 KB

-rwxr-xr-x

valdet.php

12.01 KB

-rwxr-xr-x

valdet_dud.php

10 KB

-rwxr-xr-x

Code Editor : reva_api.php

<?php

ini_set('display_errors', 'On');
error_reporting(E_ALL);
ini_set('max_execution_time', 300);
ini_set("memory_limit", "500M");
header("Content-Type: text/html");

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

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

$fregno = $_GET['regno'];
$option = $_GET['option'];

if ($fregno == '') {
    echo "Please enter Reg. No.";
    return;
    die();
}

if ($option == '') {
    echo "Please enter Option";
    return;
    die();
}

$update = "update student set fbatch1 = '{$option}' 
    where fregno = '{$fregno}'";

$result = $conn->query($update);

if ($option == 1) {
    $update = "update canddet set fpresent = 'P' 
        where fregno = '{$fregno}'
        and ifnull(fpassmth,'') = ''
        and fpresent = 'X'";
    $result1 = $conn->query($update);
} else {
    $update = "update canddet set fpresent = 'X' 
        where fregno = '{$fregno}'
        and ifnull(fpassmth,'') = ''
        and fpresent = 'P'";
    $result1 = $conn->query($update);
}
$query = "SELECT s.fdegree, s.fregno, s.fname, s.fcollcode, s.fbatch1,
    (case when c.ftotalfee>'0' then 'Fee Paid' else 'Not Paid' end) as Status FROM student s
    inner join candsum c on s.fdegree= c.fdegree and s.fregno =c.fregno
    and s.fcollcode = c.fcollcode 
      where s.fregno = '{$fregno}'";
$result2 = $conn->query($query);
echo '<table border="2" style="background-color: white; color: Green; margin: 0 auto;">
    <thead>
        <tr>
            <th>Degree</th>
            <th>Register_No</th>
            <th>Student_Name</th>
            <th>College Code</th>
            <th>Option</th>
            <th>Status</th>

</tr>
    </thead>

<tbody>';

while ($row = mysqli_fetch_assoc($result2)) {
    echo
        "<tr>
			  <td>{$row['fdegree']}</td>
              <td>{$row['fregno']}</td>
              <td>{$row['fname']}</td>
              <td>{$row['fcollcode']}</td>
              <td>{$row['fbatch1']}</td>
              <td>{$row['Status']}</td>
            </tr>\n";
}
?>
</tbody>
</table>

</body>

</html>

${this.title}

Code Editor : reva_api.php