Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Date for Second Round Counsell...	39.43 KB	-rw-rw-r--
Documents for Admission for th...	1.23 MB	-rw-rw-r--
M.Com counselling dates.pdf	735.18 KB	-rw-rw-r--
MainPage.html	52.32 KB	-rw-rw-r--
add-course-payment.html	692 B	-rw-rw-r--
add-course.html	1.23 KB	-rw-rw-r--
app-status.html	3.39 KB	-rw-rw-r--
dat.json	5.03 KB	-rw-rw-r--
ent-application.html	87.4 KB	-rw-rw-r--
forgotPassword.html	5.11 KB	-rw-rw-r--
genRankPrio.php	894 B	-rw-rw-r--
index.html	14.57 KB	-rw-rw-r--
index_adm.html	5.42 KB	-rw-rw-r--
instruction.html	10.69 KB	-rw-rw-r--
login.html	6.95 KB	-rw-rw-r--
make-payment.html	452 B	-rw-rw-r--
merit_list.php	1.9 KB	-rw-rw-r--
merit_list_2.php	1.91 KB	-rw-rw-r--
mock-seat-allotment.html	608 B	-rw-rw-r--
option-entry.html	1.54 KB	-rw-rw-r--
pg-forgotPassword.html	4.1 KB	-rw-rw-r--
pg-sign-up.html	7.81 KB	-rw-rw-r--
pg_instruction.html	9.14 KB	-rw-rw-r--
pgadm.html	67.76 KB	-rw-rw-r--
seat-allotment.html	1.08 KB	-rw-rw-r--
seatAllot.php	6.75 KB	-rw-rw-r--
sign-up.html	7.96 KB	-rw-rw-r--
supernumerary quota merit list...	9.66 MB	-rw-rw-r--
support.html	4.76 KB	-rw-rw-r--
upload_file.php	787 B	-rw-rw-r--
upload_file_pg.php	746 B	-rw-rw-r--

Code Editor : merit_list.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_bcu";

$query  = "SELECT d.fdegree, d.fdescpn, CONCAT('https://bcu.ac.in/uploads/meritlist/',d.fdegree,'.pdf') AS link FROM {$db}.entdeg d
WHERE ifnull(d.fdeleted,'') <> 'T'
and ifnull(flock,'') = 'T'
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>Merit 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>Merit 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 Merit 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 : merit_list.php