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
//ob_start();
session_start();
require_once 'conn.php';
// 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);
//$res2=mysqli_query($conn, "SELECT * FROM scholarship WHERE email = '$search' OR mat_no = '$search'");
//$userRow2=mysqli_fetch_array($res2);
?>
<!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="index.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">
<?php
function check_input($data)
{
$data=trim($data);
$data=stripslashes($data);
$data=htmlspecialchars($data);
return $data;
}
$search=check_input($_POST['search']);
if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * $results_per_page;
$sql = "SELECT * FROM ".$datatable." ORDER BY user_id ASC LIMIT $start_from, ".$results_per_page;
$rs_result = $conn->query($sql);
?>
<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 border="1" cellpadding="4">
<tr>
<td bgcolor="#CCCCCC" width = "22%"><strong>Fullname</strong></td>
<td bgcolor="#CCCCCC" width = "3%"><strong>Phone</strong></td>
<td bgcolor="#CCCCCC" width = "20%"><strong>School</strong></td>
<td bgcolor="#CCCCCC" width = "5%"><strong>Matric_No</strong></td>
<td bgcolor="#CCCCCC" width = "5%"><strong>CGPA</strong></td>
<td bgcolor="#CCCCCC" width = "8%"><strong>Lga</strong></td>
<td bgcolor="#CCCCCC" width = "8%"><strong>Town</strong></td>
</tr>
<?php
while($row = $rs_result->fetch_assoc()) {
//$user_id = $row['user_id'];
?>
<tr>
<td align = "center"><a href ="name_search.php?user_id=<?php echo $row["user_id"]; ?>"><?php echo $row["surname"]." ".$row["firstname"]?></a></td>
<td align = "center"><?php echo $row["phone"]; ?></td>
<td align = "center"><?php echo $row["school_name"]; ?></td>
<td align = "center"><?php echo $row["mat_no"]; ?></td>
<td align = "center"><?php echo $row["current_cgpa"]."/".$row["cgpa_scale"]; ?></td>
<td align = "center"><?php echo $row["origin_lga"]; ?></td>
<td align = "center"><?php echo $row["origin_town"]; ?></td>
</tr>
<?php
};
?>
</table>
<?php
$sql = "SELECT COUNT(user_id) AS total FROM ".$datatable;
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$total_pages = ceil($row["total"] / $results_per_page); // calculate total pages with results
for ($i=1; $i<=$total_pages; $i++) { // print links for all pages
echo "<font color = 'red'>"."<a href='all.php?page=".$i."'";
if ($i==$page) echo " class='curPage'";
echo ">".$i."</a>"."</font>";
};
echo "<p>"."<font color = 'blue'>"."Total Record:"." "."[".ceil($row["total"])."]"."</font>";
?>
</div>
</div>
</div>
<br>
</div>
</div>
<!-- end scholarship plan -->
<br>
<!-- 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>