Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.git	[ DIR ]	drwxrwxrwx
.vscode	[ DIR ]	drwxrwxrwx
PHPExcel	[ DIR ]	drwxrwxrwx
Paytm	[ DIR ]	drwxrwxrwx
acu-admin	[ DIR ]	drwxrwxr-x
admin-src	[ DIR ]	drwxrwxrwx
bcu	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxrwxrwx
dud	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxrwxrwx
img	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
libs	[ DIR ]	drwxrwxrwx
meritlist	[ DIR ]	drwxrwxrwx
pget_photos	[ DIR ]	drwxrwxrwx
pgetadm	[ DIR ]	drwxrwxrwx
plugins	[ DIR ]	drwxrwxrwx
razorpay	[ DIR ]	drwxrwxrwx
rcub	[ DIR ]	drwxrwxrwx
ru-admin_stop	[ DIR ]	drwxrwxr-x
ru_stop	[ DIR ]	drwxrwxrwx
seatallot	[ DIR ]	drwxrwxrwx
seatallot_1	[ DIR ]	drwxrwxrwx
seatallot_2	[ DIR ]	drwxrwxrwx
seatallot_3	[ DIR ]	drwxrwxrwx
seatallot_4	[ DIR ]	drwxrwxrwx
seatallot_5	[ DIR ]	drwxrwxrwx
seatallot_8	[ DIR ]	drwxrwxrwx
seatallot_or_1	[ DIR ]	drwxrwxrwx
seatallot_or_2	[ DIR ]	drwxrwxrwx
seatallot_or_3	[ DIR ]	drwxrwxrwx
seatallot_ou	[ DIR ]	drwxrwxrwx
seatallot_sn	[ DIR ]	drwxrwxrwx
seatallot_ss	[ DIR ]	drwxrwxrwx
seatallot_ss_1	[ DIR ]	drwxrwxrwx
seatstatus	[ DIR ]	drwxrwxr-x
src	[ DIR ]	drwxrwxrwx
tcpdf	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
vku-admin	[ DIR ]	drwxrwxrwx
vskub	[ DIR ]	drwxrwxrwx
.DS_Store	22 KB	-rwxrwxrwx
.gitignore	67 B	-rwxrwxrwx
AVAIL_SEATS_16112021.pdf	353.8 KB	-rw-rw-r--
app.php	498 B	-rwxrwxrwx
cconfig.php	1.78 KB	-rwxrwxrwx
consts.php	212 B	-rwxrwxrwx
database.php	583 B	-rwxrwxrwx
forgot-password.php	2.19 KB	-rwxrwxrwx
instruction_regn.html	4.45 KB	-rwxrwxrwx
login.php	317 B	-rwxrwxrwx
merit_list.php	2.72 KB	-rwxrwxrwx
merit_list1.php	1.86 KB	-rwxrwxrwx
merit_list_l.php	3.14 KB	-rw-rw-r--
merit_list_round_2.php	2.07 KB	-rwxrwxrwx
merit_list_wait.php	2.15 KB	-rwxrwxrwx
pgResponse.php	18.44 KB	-rwxrwxrwx
resetpassword.php	730 B	-rwxrwxrwx
rzp.csv	67 B	-rwxrwxrwx
seat_alloted_list.php	1.89 KB	-rwxrwxrwx
seat_alloted_list_1.php	2.05 KB	-rwxrwxrwx
seat_alloted_list_3.php	2.07 KB	-rwxrwxrwx
seat_alloted_list_4.php	2 KB	-rwxrwxrwx
seat_alloted_list_4_ou.php	1.99 KB	-rwxrwxrwx
seat_alloted_list_5.php	2 KB	-rwxrwxrwx
seat_alloted_list_or.php	1.98 KB	-rwxrwxrwx
seat_alloted_list_or_ou.php	2 KB	-rwxrwxrwx
seat_alloted_list_or_ss.php	2 KB	-rwxrwxrwx
seat_alloted_list_ou.php	2.07 KB	-rwxrwxrwx
seat_alloted_list_sn.php	1.93 KB	-rwxrwxrwx
seat_alloted_list_ss.php	1.99 KB	-rwxrwxrwx
seat_alloted_list_ss_1.php	2 KB	-rwxrwxrwx
seat_status.php	2.07 KB	-rw-rw-r--
sendGridMail.php	1.28 KB	-rwxrwxrwx
sendMobEmailOTP.php	3.55 KB	-rwxrwxrwx
sendsmsapi.php	814 B	-rwxrwxrwx
signin.php	973 B	-rwxrwxrwx
signup.php	1.22 KB	-rwxrwxrwx
some_excel_file.xlsx	6.6 KB	-rwxrwxrwx
student.php	13.52 KB	-rwxrwxrwx
test.php	16 B	-rwxrwxrwx
upload.php	415 B	-rwxrwxrwx
upload1.php	423 B	-rwxrwxrwx
upload_file.php	787 B	-rwxrwxrwx
upload_file_org.php	787 B	-rwxrwxrwx
upload_file_pg.php	740 B	-rwxrwxrwx
validateRegno.php	2.13 KB	-rwxrwxrwx
validateRegno_04092020.php	2.03 KB	-rwxrwxrwx
verify.php	12.85 KB	-rwxrwxrwx
vkurankupd.php	1.27 KB	-rw-rw-r--

Name

Size

Permission

Action

.git

[ DIR ]

drwxrwxrwx

.vscode

[ DIR ]

drwxrwxrwx

PHPExcel

[ DIR ]

drwxrwxrwx

Paytm

[ DIR ]

drwxrwxrwx

acu-admin

[ DIR ]

drwxrwxr-x

admin-src

[ DIR ]

drwxrwxrwx

bcu

[ DIR ]

drwxrwxrwx

css

[ DIR ]

drwxrwxrwx

docs

[ DIR ]

drwxrwxrwx

dud

[ DIR ]

drwxrwxrwx

images

[ DIR ]

drwxrwxrwx

img

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxrwxrwx

libs

[ DIR ]

drwxrwxrwx

meritlist

[ DIR ]

drwxrwxrwx

pget_photos

[ DIR ]

drwxrwxrwx

pgetadm

[ DIR ]

drwxrwxrwx

plugins

[ DIR ]

drwxrwxrwx

razorpay

[ DIR ]

drwxrwxrwx

rcub

[ DIR ]

drwxrwxrwx

ru-admin_stop

[ DIR ]

drwxrwxr-x

ru_stop

[ DIR ]

drwxrwxrwx

seatallot

[ DIR ]

drwxrwxrwx

seatallot_1

[ DIR ]

drwxrwxrwx

seatallot_2

[ DIR ]

drwxrwxrwx

seatallot_3

[ DIR ]

drwxrwxrwx

seatallot_4

[ DIR ]

drwxrwxrwx

seatallot_5

[ DIR ]

drwxrwxrwx

seatallot_8

[ DIR ]

drwxrwxrwx

seatallot_or_1

[ DIR ]

drwxrwxrwx

seatallot_or_2

[ DIR ]

drwxrwxrwx

seatallot_or_3

[ DIR ]

drwxrwxrwx

seatallot_ou

[ DIR ]

drwxrwxrwx

seatallot_sn

[ DIR ]

drwxrwxrwx

seatallot_ss

[ DIR ]

drwxrwxrwx

seatallot_ss_1

[ DIR ]

drwxrwxrwx

seatstatus

[ DIR ]

drwxrwxr-x

src

[ DIR ]

drwxrwxrwx

tcpdf

[ DIR ]

drwxrwxrwx

upload

[ DIR ]

drwxrwxrwx

vku-admin

[ DIR ]

drwxrwxrwx

vskub

[ DIR ]

drwxrwxrwx

.DS_Store

22 KB

-rwxrwxrwx

.gitignore

67 B

-rwxrwxrwx

AVAIL_SEATS_16112021.pdf

353.8 KB

-rw-rw-r--

app.php

498 B

-rwxrwxrwx

cconfig.php

1.78 KB

-rwxrwxrwx

consts.php

212 B

-rwxrwxrwx

database.php

583 B

-rwxrwxrwx

forgot-password.php

2.19 KB

-rwxrwxrwx

instruction_regn.html

4.45 KB

-rwxrwxrwx

317 B

-rwxrwxrwx

merit_list.php

2.72 KB

-rwxrwxrwx

merit_list1.php

1.86 KB

-rwxrwxrwx

merit_list_l.php

3.14 KB

-rw-rw-r--

merit_list_round_2.php

2.07 KB

-rwxrwxrwx

merit_list_wait.php

2.15 KB

-rwxrwxrwx

pgResponse.php

18.44 KB

-rwxrwxrwx

resetpassword.php

730 B

-rwxrwxrwx

rzp.csv

67 B

-rwxrwxrwx

seat_alloted_list.php

1.89 KB

-rwxrwxrwx

seat_alloted_list_1.php

2.05 KB

-rwxrwxrwx

seat_alloted_list_3.php

2.07 KB

-rwxrwxrwx

seat_alloted_list_4.php

2 KB

-rwxrwxrwx

seat_alloted_list_4_ou.php

1.99 KB

-rwxrwxrwx

seat_alloted_list_5.php

2 KB

-rwxrwxrwx

seat_alloted_list_or.php

1.98 KB

-rwxrwxrwx

seat_alloted_list_or_ou.php

2 KB

-rwxrwxrwx

seat_alloted_list_or_ss.php

2 KB

-rwxrwxrwx

seat_alloted_list_ou.php

2.07 KB

-rwxrwxrwx

seat_alloted_list_sn.php

1.93 KB

-rwxrwxrwx

seat_alloted_list_ss.php

1.99 KB

-rwxrwxrwx

seat_alloted_list_ss_1.php

2 KB

-rwxrwxrwx

seat_status.php

2.07 KB

-rw-rw-r--

sendGridMail.php

1.28 KB

-rwxrwxrwx

sendMobEmailOTP.php

3.55 KB

-rwxrwxrwx

sendsmsapi.php

814 B

-rwxrwxrwx

signin.php

973 B

-rwxrwxrwx

signup.php

1.22 KB

-rwxrwxrwx

some_excel_file.xlsx

6.6 KB

-rwxrwxrwx

student.php

13.52 KB

-rwxrwxrwx

test.php

16 B

-rwxrwxrwx

upload.php

415 B

-rwxrwxrwx

upload1.php

423 B

-rwxrwxrwx

upload_file.php

787 B

-rwxrwxrwx

upload_file_org.php

787 B

-rwxrwxrwx

upload_file_pg.php

740 B

-rwxrwxrwx

validateRegno.php

2.13 KB

-rwxrwxrwx

validateRegno_04092020.php

2.03 KB

-rwxrwxrwx

verify.php

12.85 KB

-rwxrwxrwx

vkurankupd.php

1.27 KB

-rw-rw-r--

Code Editor : seat_alloted_list_sn.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_vku";

$query  = "SELECT d.fdegree, d.fdescpn, CONCAT('seatallot_sn/vskub/',d.fdegree,'.pdf') AS link FROM {$db}.entdeg d
WHERE ifnull(d.fdeleted,'') <> 'T'
and fdegree in('MAHS',
'MCOM',
'MSCH',
'MSMT',
'MSZL')
order by forder,d.fdescpn";

$result = mysqli_query($conn, $query);
$count = mysqli_num_rows($result);

$query1 = "select funivname, date_format(now(), '%d/%m/%Y %r') as fdate from {$db}.control"; 
// var_dump(expression)
$result1 = mysqli_query($conn, $query1);
$row1 = mysqli_fetch_assoc($result1);

$table = '<center><h1>'.$row1['funivname'].'</h1>
<h2>Supernumerary Seat Allotment List</h2>
<center>
    <table style="margin-left:2px;text-align: left;width: 60%;font-size:14px;margin: auto;" align-self="middle" cellspacing="1" cellpadding="5" border="0" align="center" bgcolor="#505151">
			<thead> 
			<tr style = "background-color:#8acc51">
			 <th width="8%"><center>Sl. No.</center></th>
             <th width="15%"><center>Degree code</center></th>
             <th><center>Degree Name</center></th>
			 <th width="25%"><center>Seat Allot List</center></th>
			</tr>
		</thead>';	
$i = 0;

if($count > 0)
{
    while($row = mysqli_fetch_assoc($result))
    {
        $table .= "<tr bgcolor='#ffffff' >";
        $table .= "<td><center>".++$i."</center></td>";
        $table .= "<td><center>".$row['fdegree']."</center></td>";
        $table .= "<td>".$row['fdescpn']."</td>";
        $table .= "<td><a href='".$row['link']."' target = 'blank'>Click here for Seat Alloted List</a></td>";
        $table .= "</tr>";
    }
}
else
{
    $table .= "<tr bgcolor='#ffffff' >";
    $table .= "<td colspan='4'><center>Merit List Not yet Announced</center></td>";
}

echo $table;

${this.title}

Code Editor : seat_alloted_list_sn.php