Server : Apache System : Linux 122.228.205.92.host.secureserver.net 5.14.0-362.18.1.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jan 29 07:05:48 EST 2024 x86_64 User : ondostategov ( 1002) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/ondostategov/public_html/scholarshipboardondostate/ossms/ |
<?php
include('conn.php');
include('Pagination.class.php');
session_start();
// if session is not set this will redirect to login page
if( !isset($_SESSION['user_id']) ) {
header("Location: back_login.php");
exit;
}
// select loggedin users detail
$user_id = $_SESSION['user_id'];
$res1=mysqli_query( $conn, "SELECT * FROM admin WHERE user_id=".$_SESSION['user_id']);
$userRow1=mysqli_fetch_array($res1);
//DEFINE LIMIT for PER PAGE now 25 is page limit
$limit = ( isset( $_GET['limit'] ) ) ? $_GET['limit'] : 25;
//DEFAULT PAGE NUMBER if No page in url
$page = ( isset( $_GET['page'] ) ) ? $_GET['page'] : 1;
//Number of frequency links to show at one time ;
$links = ( isset( $_GET['links'] ) ) ? $_GET['links'] : 7;
//your query here in query varriable
$query = "Select * from scholarship";
//create a paging class object with connection and query parameters
$Paginator = new Paginator( $conn, $query );
//get the results from paginator class
$results = $Paginator->getData( $limit, $page );
//echo $user_id;
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Ondo State Scholarship Board</title>
<style><!--
body{
font-family:Arial, Helvetica, sans-serif;
}
h1{
font-family:'Georgia', Times New Roman, Times, serif;
}
--></style>
<!-- Custom-Files -->
<link type="text/css" rel="stylesheet" href="bootstrap-3.2.0-dist/css/bootstrap.css">
<link href="images/ondologo.png" rel="icon" type="image/jpg"/>
<link href="css/w3.css" rel="stylesheet" type="text/css">
<link href="date/tcal.css" rel="stylesheet" type="text/css">
<link href="css/w3colors.css" rel="stylesheet" type="text/css">
<link href="css/custom.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="date/tcal.js"></script>
<!-- Web-Fonts -->
<link href="//fonts.googleapis.com/css?family=Roboto+Condensed:300,300i,400,400i,700,700i&subset=cyrillic,cyrillic-ext,greek,greek-ext,latin-ext,vietnamese"
rel="stylesheet">
<link href="//fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i" rel="stylesheet">
<!-- //Web-Fonts -->
</head>
<body class="w3-container">
<!--header div -->
<div class="w3-container ">
<div class="w3-container w3-card w3-text-black w3-dark-grey">
<div class="w3-half">
<h1 class="w3-container w3-text-black" style=" font-style:italic; font-weight:bold; font-size:40px"><img src="images/ondologo.PNG" alt="Ondo State Logo" width="100" style="border-radius:10px"> OSSMS</h1>
<h6 class="w3-container">Ondo State Scholarship Management System</h6>
</div>
<div class="w3-half" style="padding-top:73px">
<h6 class="w3-right w3-container">
<?php
echo "[".$userRow1['email']."]";
?>
</h6>
</div>
</div>
<div class="w3-container w3-card w3-grey" >
<div class="w3-left w3-hide-small">
<a href="back_dashboard.php" class="w3-bar-item w3-button">HOME</a>
</div>
<div class="w3-bar-item w3-right">
<a href="logout.php" class="w3-button" >LOGOUT</a>
</div>
</div>
</div>
<!-- end header div-->
<br>
<!-- scholarship plan -->
<div class="w3-container ">
<div class="w3-card-4">
<div class="w3-container w3-light-grey">
<h2>Admin Dashboard</h2>
</div>
<br>
<div class="w3-container">
<div class="w3-quarter w3-padding">
<a href="all.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-grey w3-hover-grey">All Records</div></a>
<a href="back_dashboard.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Decision-Making</div></a>
<a href="admin.dashboard_origin_lga.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Search by LGA</div></a>
<a href="search_origin_town.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Search by Town</div></a>
<a href="search_school_name.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey ">Search School</div></a>
<a href="export_disability.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualify Disability</div></a>
<a href="qualify_scholarship.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualify for scholarship</div></a>
<a href="export_bursary.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualify for bursary</div></a>
<a href="export_medical.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualify Medical Students</div></a>
<a href="export_law.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualify Law Students</div></a>
<a href="export_completed.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Completed Applications</div></a>
<a href="export_remark.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">Qualified Applicants</div></a>
</div>
<div class="w3-threequarter">
<div class="w3-row w3-padding">
<div class="w3-row w3-padding font-weight-bold text-dark w3-blue w3-hover-light-grey"><a href = "export_all.php"><strong>[Export to Excel]</strong></a></div>
<table class="table table-striped">
<?php
echo "<thead>";
echo "<thead>";
echo "<th>".$origin_town."</th>";
echo "<th>Fullname</th>";
echo "<th>Gender</th>";
echo "<th>Phone</th>";
echo "<th>School</th>";
echo "<th>Mat_No</th>";
echo "<th>CGPA</th>";
echo "<th>Lga</th>";
echo "<th>Town</th>";
echo "</tr>";
echo "</thead>";
?>
<tbody>
<?php
if(isset($results) && count( $results->data ) > 0){
for( $i = 0; $i < count( $results->data ); $i++ ) { ?>
<tr>
<td><?php echo $results->data[$i]['id']; ?></td>
<td><a href ="name_search.php?user_id=<?php echo $results->data[$i]['user_id']; ?>"><?php echo $results->data[$i]['surname']." ".$results->data[$i]['firstname']." ".$results->data[$i]['middle_name']; ?></a></td>
<td><?php echo $results->data[$i]['gender']; ?></td>
<td><?php echo $results->data[$i]['phone']; ?></td>
<td><?php echo $results->data[$i]['school_name']; ?></td>
<td><?php echo $results->data[$i]['mat_no']; ?></td>
<td><?php echo $results->data[$i]['current_cgpa']."/".$results->data[$i]['cgpa_scale']; ?></td>
<td><?php echo $results->data[$i]['origin_lga']; ?></td>
<td><?php echo $results->data[$i]['origin_town']; ?></td>
</tr>
<?php }
} ?>
</tbody>
</table>
<p><?php echo $Paginator->createLinks( $links, $class="pagination"); ?></p>
</div>
</div>
</div>
<br>
</div>
</div>
<!-- end scholarship plan -->
<br>
<!-- end footer -->
<div class="w3-container">
<div class="w3-container w3-dark-grey w3-topbar w3-border-grey " >
<div class="w3-row">
<div class=" w3-third">
<p>© 2018 OSSMS</p>
</div>
<div class="w3-third w3-center">
<p>A product of <a href=""><img src="images/sitaLogo.png" width="60" alt="SITA" style="border-radius:10px" ></a>
</div>
<div class="w3-third w3-right w3-hide-small" style="padding-top:15px; padding-left: 100px">
<a href="index.php" class="w3-bar-item">Terms</a>
<a href="about.php" class="w3-bar-item">Privacy</a>
<a href="faq.php" class="w3-bar-item">Contact Us</a>
</div>
</div>
</div>
</div>
<!-- end footer -->
<script>
function myFunction(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
</body>
</html>