39 lines
1.3 KiB
PHP
39 lines
1.3 KiB
PHP
<?php
|
|
$conn = new mysqli($GLOBALS['host'], $GLOBALS['user'], $GLOBALS['pass'], $GLOBALS['db']);
|
|
$list= urldecode($_GET['list']);
|
|
$stream= urldecode($_GET['stream']);
|
|
$sql = "SELECT * FROM `scc_pg_19` WHERE `PAY_FORM` LIKE 'PAID' AND `MERIT_LIST`= '".$list."' AND `H_NM` LIKE '%".$stream."%'" ."ORDER BY AGGREGATE DESC";
|
|
$result = mysqli_query($conn, $sql);
|
|
if (mysqli_num_rows($result) > 0) {
|
|
echo'<div class="table-responsive text-center text-uppercase">
|
|
<h1>'.$stream.' Merit List</h1><hr>
|
|
<table class="table table-bordered table-striped table-hover">
|
|
<tr>
|
|
<th>SL</th>
|
|
<th>STUDENT ID</th>
|
|
<th>STUDENT NAME</th>
|
|
<th>AGGREGATE MARKS</th>
|
|
<th>MERIT LIST</th>
|
|
</tr>';
|
|
$i=0;
|
|
while($row = mysqli_fetch_assoc($result)){
|
|
$i++;
|
|
$id = $row["ID"];
|
|
$STUDENT_NAME = $row["NAME"];
|
|
$MOBILE = $row["MOBILE"];
|
|
$Aggregate = $row["AGGREGATE"];
|
|
$GEN_HONOURS = $row["H_NM"];
|
|
$MERIT_LIST = $row["MERIT_LIST"];
|
|
echo '
|
|
<tr>
|
|
<td>'.$i.'</td>
|
|
<td>SCC19PG'.$id.'</td>
|
|
<td>'.$STUDENT_NAME.'</td>
|
|
<td>'.$Aggregate.'</td>
|
|
<td>'.$MERIT_LIST.'</td>
|
|
</tr>';
|
|
|
|
|
|
}echo ' </table></div>';
|
|
} else { echo "<div class='container text-center'><h2>No students for this Stream!</h2></div>";}
|
|
?>
|