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');
session_start();
if(isset($_SESSION['user_id'])){
$user_id = $_SESSION['user_id'];
}
//echo $user_id;
if (isset($_POST['submit']))
{
function check_input($data)
{
$data=trim($data);
$data=stripslashes($data);
$data=htmlspecialchars($data);
return $data;
}
$search=check_input($_POST['search']);
//echo $search;
$sql = "SELECT * FROM scholarship WHERE email = '$search' OR mat_no = '$search' OR phone = '$search' OR id = '$search' OR firstname = '$search'";
$result = mysqli_query($conn, $sql);
$test = mysqli_fetch_array($result);
if(mysqli_num_rows($result)>0)
{
$surname=$test['surname'];
$firstname= $test['firstname'];
$email=$test['email'];
$phone=$test['phone'];
//echo $surname;
}
else
{
$_SESSION['err_msg'] = "Wrong Searching Criteria Entered";
header('location:back_dashboard.php');
exit;
}
}
if(isset($_REQUEST['link'])){
$document_id = $_REQUEST['link'];
$res=mysqli_query( $conn, "SELECT * FROM uploaded_documents WHERE document_id=".$document_id);
$row=mysqli_fetch_array($res);
$document_path = $row['document_path'];
$res1=mysqli_query( $conn, "DELETE FROM uploaded_documents WHERE document_id=".$document_id);
if($document_path)
{
unlink($document_path);
}
}
?>
<!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 id = "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 $userRow2['surname']. ' '. $userRow2['firstname'] . ' [' .$userRow2['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>
<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="outer-w3-agile mt-3">
<div class="w3-row w3-padding"><h3>Biodata</h2></div>
<form action="#" method="post">
<div class="form-row">
<div class = "w3-row">
<div class="form-group col-md-4">
Full name
<input readonly="readonly" class="form-control" value="<?php echo $test['surname']." ".$test['firstname']." ".$test['middle_name'];?>">
</div>
<div class="form-group col-md-1">
Gender
<input readonly="readonly" class="form-control" value="<?php echo $test['gender'];?>">
</div>
<div class="form-group col-md-2">
Email
<input readonly="readonly" class="form-control" value="<?php echo $test['email'];?>" >
</div>
<div class="form-group col-md-2">
Phone No
<input readonly="readonly" class="form-control" value="<?php echo $test['phone'];?>" >
</div>
<div class="form-group col-md-2">
Ref Phone
<input readonly="readonly" class="form-control" value="<?php echo $test['ref_phone'];?>" >
</div>
</div>
<div class = "w3-row">
<div class="form-group col-md-1">
Disability
<input readonly="readonly" class="form-control" value="<?php echo $test['any_disability'];?>" >
</div>
<div class="form-group col-md-6">
Residence Address
<input readonly="readonly" class="form-control" value="<?php echo $test['residence_address'];?>">
</div>
<div class="form-group col-md-2">
Origin State
<input readonly="readonly" class="form-control" value="<?php echo $test['origin_state'];?>">
</div>
<div class="form-group col-md-2">
Origin Lga
<input readonly="readonly" class="form-control" value="<?php echo $test['origin_lga'];?>" >
</div>
</div>
<div class = "w3-row">
<div class="form-group col-md-1">
Town
<input readonly="readonly" class="form-control" value="<?php echo $test['origin_town'];?>" >
</div>
<div class="form-group col-md-2">
NOK Phone
<input readonly="readonly" class="form-control" value="<?php echo $test['nok_phone'];?>" >
</div>
<div class="form-group col-md-2">
Father Name
<input readonly="readonly" class="form-control" value="<?php echo $test['father_name'];?>" >
</div>
<div class="form-row">
<div class="form-group col-md-2">
Mother Name
<input readonly="readonly" class="form-control" value="<?php echo $test['mother_name'];?>">
</div>
<div class="form-group col-md-4">
Parent Address
<input readonly="readonly" class="form-control" value="<?php echo $test['parent_address'];?>">
</div>
</div>
</form>
</div>
<div class="outer-w3-agile mt-3">
<div class="w3-row w3-padding"><h3>School Details</h2></div>
<form action="#" method="post">
<div class = "w3-row">
<div class="form-row">
<div class="form-group col-md-6">
School Name
<input readonly="readonly" class="form-control" value="<?php echo $test['school_name'];?>">
</div>
<div class="form-group col-md-5">
Course of Study
<input readonly="readonly" class="form-control" value="<?php echo $test['course_of_study'];?>" >
</div>
</div>
<div class = "w3-row">
<div class="form-group col-md-3">
Matric No
<input readonly="readonly" class="form-control" value="<?php echo $test['mat_no'];?>">
</div>
<div class="form-group col-md-4">
Current Level
<input readonly="readonly" class="form-control" value="<?php echo $test['current_level'];?>" >
</div>
<div class="form-group col-md-4">
Current CGPA
<input readonly="readonly" class="form-control" value="<?php echo $test['current_cgpa'] ."/". $test['cgpa_scale'] ;?>" >
</div>
</div>
</div>
</form>
</div>
<div class="outer-w3-agile mt-3">
<div class="w3-row w3-padding"><h3>Bank Details</h2></div>
<form action="#" method="post">
<div class="form-row">
<div class = "w3-row">
<div class="form-group col-md-4">
Bank Name
<input readonly="readonly" class="form-control" value="<?php echo $test['bank'];?>">
</div>
<div class="form-group col-md-4">
Account Name
<input readonly="readonly" class="form-control" value="<?php echo $test['account_name'];?>" >
</div>
<div class="form-group col-md-3">
Account No
<input readonly="readonly" class="form-control" value="<?php echo $test['account_number'];?>">
</div>
</div>
</div>
</form>
</div>
<div class="outer-w3-agile mt-3">
<div class="w3-row w3-padding"><h3>Application Status</h3></div>
<form action="#" method="post">
<div class = "w3-row">
<div class="form-row">
<div class="form-group col-md-6">
Application Submitted
<input readonly="readonly" class="form-control" value="
<?php if ($test['completed'] == '1')
{echo "Application Submitted!";}
else{echo "Application NOT submitted!";}
?>
">
</div>
<div class="form-group col-md-5">
Qualify/Not Qualify?
<input readonly="readonly" class="form-control" value="
<?php if ($test['remark'] == '1')
{echo "Applicant Qualify!";}
else{
if ($test['remark'] == '0')
{echo "NOT Qualify!";}
else
{echo "No Decision Yet!";}
}
?>
">
</div>
</div>
</div>
</form>
</div>
<div class="w3-row w3-padding">
<table class="w3-table w3-striped w3-hover w3-border form-group col-md-4">
<div class="w3-row w3-padding"><h3>Documents Submitted</h2></div>
<tr>
<th>S/N</th>
<th>Document Name</th>
<th>View Document</th>
</tr>
<?php
$res2=mysqli_query( $conn, "SELECT * FROM uploaded_documents WHERE user_id=".$_SESSION['user_id']);
$sn=1;
while($row = mysqli_fetch_array($res2)){
$document_id= $row['document_id'] ;
$document_path=$row['document_path'] ;
$res=mysqli_query( $conn, "SELECT * FROM documents WHERE id= '$document_id' ");
$row=mysqli_fetch_array($res);
$document_name = $row['document_name'];
echo "<tr>
<td>$sn</td>
<td>$document_name</td>
<td><a href='$document_path' target='_blank'>View</a></td>
<td><a href='dashboard_document.php?link=$document_id' onclick='return verifyDelete()'>Delete</a></td>
</tr>";
$sn++;
}
?>
</table>
</div>
<div class="inner-sec pt-md-6">
<div class="w3-row w3-padding"><h3>Photo Uploaded</h2></div>
<div class="w3-row w3-padding">
<div class="row proj_gallery_grid">
<div class="col-sm-4 section_1_gallery_grid">
<a href="#">
<div class="section_1_gallery_grid1">
<img src="<?php if(isset($test['photo']))
{echo $test['photo'];}
else
{echo "uploads/".$test['photo']."jpg";} ?>" class="img-polaroid" height="200" width="200" alt="Photo">
</div>
</a>
</div>
</div>
<br>
<center>
<?php $_SESSION['user_id'] = $test['user_id']; ?>
<form method = "POST" action = "process_qualify.php">
<div class="w3-third w3-padding" style="text-align:right;"><button class="w3-btn w3-left w3-dark-grey w3-hover-grey" name="qualify" type = "submit">Qualify</button></div>
<div class="w3-third w3-padding" style="text-align:right;"><button class="w3-btn w3-left w3-dark-grey w3-hover-grey" name="nqualify" type = "submit">Not Qualify</button></div>
</form>
</center>
</div>
</div>
</li>
</ul>
</div>
</div>
</div>
<!-- end footer -->
<script>
function printContent(el)
{
var restorepage = document.body.innerHTML;
var printcontent = document.getElementById(el).innerHTML;
document.body.innerHTML = printcontent;
window.print();
document.body.innerHTML = restorepage;
}
</script>
<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>