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(isset($_SESSION['user_id'])){
$user_id = $_SESSION['user_id'];
}
//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 ";
if (isset($_POST['submit']))
{
function check_input($data)
{
$data=trim($data);
$data=stripslashes($data);
$data=htmlspecialchars($data);
return $data;
}
$origin_town=check_input($_POST['origin_town']);
$query = "SELECT * FROM scholarship WHERE origin_town = '$origin_town'";
}
//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>
<div class="w3-row w3-padding">
<div class="row">
<div class="col-md-12">
<ul class="list-group">
<li class="list-group-item">
<div class="table-responsive">
<?php $origin_town = $_POST['origin_town'];
//echo $origin_town;
$_SESSION['origin_town'] = $_POST['origin_town'];
?>
<div class="w3-row w3-padding font-weight-bold text-dark w3-blue w3-hover-light-grey"><a href = "export_town.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 no.</th>";
echo "<th>Res. Address</th>";
echo "<th>Res. City</th>";
echo "<th>Origin town</th>";
echo "<th>Father name</th>";
echo "<th>Mother name</th>";
echo "<th>Parent add.</th>";
echo "<th>School</th>";
echo "<th>CGPA</th>";
echo "<th>Level</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]['residence_address']; ?></td>
<td><?php echo $results->data[$i]['residence_city']; ?></td>
<td><?php echo $results->data[$i]['origin_town']; ?></td>
<td><?php echo $results->data[$i]['father_name']; ?></td>
<td><?php echo $results->data[$i]['mother_name']; ?></td>
<td><?php echo $results->data[$i]['parent_address']; ?></td>
<td><?php echo $results->data[$i]['school_name']; ?></td>
<td><?php echo $results->data[$i]['current_cgpa']; ?></td>
<td><?php echo $results->data[$i]['current_level']; ?></td>
</tr>
<?php }
} ?>
</tbody>
</table>
<p><?php echo $Paginator->createLinks( $links, $class="pagination"); ?></p>
</div>
<!-- /.table-responsive -->
<!-- footer -->
<!-- end footer -->
</li>
</ul>
</div>
</div>
</div>
<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>