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($_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);
}
}
$user_id =$_REQUEST['user_id'];
$sel_query="Select * from registration WHERE user_id = '$user_id'";
$result = mysqli_query($conn,$sel_query);
while($test = mysqli_fetch_assoc($result)){
$surname = $test['surname'];
$phone = $test['phone'];
$firstname = $test['firstname'];
}
?>
<div class="row">
<div class="col-md-12">
<ul class="list-group">
<li class="list-group-item">
<div class="outer-w3-agile mt-3">
<h3>Biodata</h2>
<form action="#" method="post">
<div class="form-row">
<div class = "w3-row">
<div class="form-group col-md-4">
Full name
<input disabled class="form-control" value="<?php $test['surname']." ".$test['firstname']." ".$test['middle_name'];?>">
</div>
<div class="form-group col-md-1">
Gender
<input disabled class="form-control" value="<?php echo $test['gender'];?>">
</div>
<div class="form-group col-md-2">
Email
<input disabled class="form-control" value="<?php echo $test['email'];?>" >
</div>
<div class="form-group col-md-2">
Phone No
<input disabled class="form-control" value="<?php echo $test['phone'];?>" >
</div>
<div class="form-group col-md-2">
Ref Phone
<input disabled class="form-control" value="<?php echo $test['ref_phone'];?>" >
</div>
</div>
<div class = "w3-row">
<div class="form-group col-md-1">
Disability
<input disabled class="form-control" value="<?php echo $test['any_disability'];?>" >
</div>
<div class="form-group col-md-6">
Residence Address
<input disabled class="form-control" value="<?php echo $test['residence_address'];?>">
</div>
<div class="form-group col-md-2">
Origin State
<input disabled class="form-control" value="<?php echo $test['origin_state'];?>">
</div>
<div class="form-group col-md-2">
Origin Lga
<input disabled class="form-control" value="<?php echo $test['origin_lga'];?>" >
</div>
</div>
<div class = "w3-row">
<div class="form-group col-md-1">
Town
<input disabled class="form-control" value="<?php echo $test['origin_town'];?>" >
</div>
<div class="form-group col-md-2">
NOK Phone
<input disabled class="form-control" value="<?php echo $test['nok_phone'];?>" >
</div>
<div class="form-group col-md-2">
Father Name
<input disabled class="form-control" value="<?php echo $test['father_name'];?>" >
</div>
<div class="form-row">
<div class="form-group col-md-2">
Mother Name
<input disabled class="form-control" value="<?php echo $test['mother_name'];?>">
</div>
<div class="form-group col-md-4">
Parent Address
<input disabled class="form-control" value="<?php echo $test['parent_address'];?>">
</div>
</div>
</form>
</div>
<div class="outer-w3-agile mt-3">
<h3>School Details</h2>
<form action="#" method="post">
<div class = "w3-row">
<div class="form-row">
<div class="form-group col-md-6">
School Name
<input disabled class="form-control" value="<?php echo $test['school_name'];?>">
</div>
<div class="form-group col-md-5">
Course of Study
<input disabled 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 disabled class="form-control" value="<?php echo $test['mat_no'];?>">
</div>
<div class="form-group col-md-4">
Current Level
<input disabled class="form-control" value="<?php echo $test['current_level'];?>" >
</div>
<div class="form-group col-md-4">
Current CGPA
<input disabled class="form-control" value="<?php echo $test['current_cgpa'] ."/". $test['cgpa_scale'] ;?>" >
</div>
</div>
</div>
</form>
</div>
<div class="outer-w3-agile mt-3">
<h3>Bank Details</h2>
<form action="#" method="post">
<div class="form-row">
<div class = "w3-row">
<div class="form-group col-md-4">
Bank Name
<input disabled class="form-control" value="<?php echo $test['bank'];?>">
</div>
<div class="form-group col-md-4">
Account Name
<input disabled class="form-control" value="<?php echo $test['account_name'];?>" >
</div>
<div class="form-group col-md-3">
Account No
<input disabled class="form-control" value="<?php echo $test['mat_no'];?>">
</div>
</div>
</div>
</form>
</div>
<table class="w3-table w3-striped w3-hover w3-border form-group col-md-6">
<h3>Documents Submitted</h2>
<tr>
<th>S/N</th>
<th>Document Name</th>
<th>View Document</th>
</tr>
<?php
$user_id = $test['user_id'];
$res2=mysqli_query( $conn, "SELECT * FROM uploaded_documents WHERE user_id='$user_id '");
$userRow2=mysqli_fetch_array($res2);
$sn=1;
while($row = mysqli_fetch_assoc($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 class="inner-sec pt-md-6">
<h3>Photo Uploaded</h2>
<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="300" width="300" alt="Photo Sample">
</div>
</a>
</div>
</div>
</div>
</li>
</ul>
</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>