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: index.php");
exit;
}
$res2=mysqli_query( $conn, "SELECT * FROM scholarship WHERE user_id=".$_SESSION['user_id']);
$userRow2=mysqli_fetch_array($res2);
$completed = $userRow2['completed'];
if($completed == 1){
header("Location: dashboard_overview.php");
}
// select loggedin users detail
$user_id = $_SESSION['user_id'];
$res1=mysqli_query( $conn, "SELECT * FROM registration WHERE user_id=".$_SESSION['user_id']);
$userRow1=mysqli_fetch_array($res1);
$res2=mysqli_query( $conn, "SELECT * FROM scholarship WHERE user_id=".$_SESSION['user_id']);
$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['surname']. ' '. $userRow1['firstname'] . ' [' .$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>Dashboard</h2>
</div>
<br>
<div class="w3-container">
<div class="w3-quarter w3-padding">
<div class="w3-row w3-padding w3-border-bottom w3-light-grey w3-hover-light-grey "> </div>
<a href="dashboard_personal_data.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey ">PERSONAL INFORMATION</div></a>
<a href="dashboard_additional_info.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">ADDITIONAL INFORMATION</div></a>
<a href="dashboard_passport_photograph.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">PASSPORT PHOTOGRAPH</div></a>
<a href="dashboard_undergraduate_detail.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-grey w3-hover-grey">UNDERGRADUATE LEVEL</div></a>
<a href="dashboard_document.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey ">DOCUMENTS</div></a>
<a href="dashboard_bank_detail.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-light-grey w3-hover-grey">BANK DETAILS</div></a>
</div>
<div class="w3-threequarter">
<form class="w3-container" method="post" action="process_undergraduate.php">
<div class="w3-row w3-padding">
<h3><b>Undergraduate Level </b><br> Details of your undergraduate education including entry details and current status</h3>
<h4>
<?php
if(isset($_SESSION['err_msg']))
{
?>
<div class="alert alert-danger">
<span><center>
<?php echo $_SESSION['err_msg'];
unset($_SESSION['err_msg']);
?>
</center></span>
</div>
<?php
} else
if(isset($_SESSION['success_msg']))
{
?>
<div class="alert alert-success">
<span><center>
<?php echo $_SESSION['success_msg'];
unset($_SESSION['success_msg']);
?>
</center></span>
</div>
<?php
}?></h4>
</div>
<br>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Name of Institution</div>
<div class="w3-third w3-padding" ><input name="school_name" class="w3-input w3-border w3-round" type="text" value="<?php if(isset($userRow2['school_name'])) echo $userRow2['school_name']; ?>">
</div>
<div class="w3-third w3-padding">Must be written correctly e.g. Adekunle Ajasin University. Visit <a href = "www.nuc.edu.ng"><strong>NUC </strong></a>site for correct name. <span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Location of Institution</div>
<div class="w3-third w3-padding" >
<select class="w3-select w3-round w3-border" name="school_country">
<option <?php if(isset($userRow2['school_country']) && $userRow2['school_country'] == "Nigeria" ) echo "selected"; ?> selected value="Nigeria">Nigeria</option>
<option <?php if(isset($userRow2['school_country']) && $userRow2['school_country'] == "Other Countries" ) echo "selected"; ?> value="Other Countries">Other Countries</option>
</select>
</div>
<div class="w3-third w3-padding"> <span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Institution State</div>
<div class="w3-third w3-padding" >
<select class="w3-select w3-round w3-border" name="school_state">
<option value="" >Select State...</option> <option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Abia" ) echo "selected"; ?> value="Abia">Abia</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Adamawa" ) echo "selected"; ?> value="Adamawa">Adamawa</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Akwa Ibom" ) echo "selected"; ?> value="Akwa Ibom">Akwa Ibom</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Anambra" ) echo "selected"; ?> value="Anambra">Anambra</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Bauchi" ) echo "selected"; ?> value="Bauchi">Bauchi</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Bayelsa" ) echo "selected"; ?> value="Bayelsa">Bayelsa</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Benue" ) echo "selected"; ?> value="Benue">Benue</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Borno" ) echo "selected"; ?> value="Borno">Borno</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Cross River" ) echo "selected"; ?> value="Cross River">Cross River</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Delta" ) echo "selected"; ?> value="Delta">Delta</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Ebonyi" ) echo "selected"; ?> value="Ebonyi">Ebonyi</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Edo" ) echo "selected"; ?> value="Edo">Edo</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Ekiti" ) echo "selected"; ?> value="Ekiti">Ekiti</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Enugu" ) echo "selected"; ?> value="Enugu">Enugu</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "FCT" ) echo "selected"; ?> value="FCT">FCT</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Gombe" ) echo "selected"; ?> value="Gombe">Gombe</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Abia" ) echo "selected"; ?> value="Abia">Imo</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Jigawa" ) echo "selected"; ?> value="Jigawa">Jigawa</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kaduna" ) echo "selected"; ?> value="Kaduna">Kaduna</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kano" ) echo "selected"; ?> value="Kano">Kano</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kastina" ) echo "selected"; ?> value="Kastina">Katsina</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kebbi" ) echo "selected"; ?> value="Kebbi">Kebbi</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kogi" ) echo "selected"; ?> value="Kogi">Kogi</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Kwara" ) echo "selected"; ?> value="Kwara">Kwara</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Lagos" ) echo "selected"; ?> value="Lagos">Lagos</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Nassarawa" ) echo "selected"; ?> value="Nassarawa">Nassarawa</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Niger" ) echo "selected"; ?> value="Niger">Niger</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Ogun" ) echo "selected"; ?> value="Ogun">Ogun</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Ondo" ) echo "selected"; ?> value="Ondo">Ondo</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Osun" ) echo "selected"; ?> value="Osun">Osun</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Oyo" ) echo "selected"; ?> value="Oyo">Oyo</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Plateau" ) echo "selected"; ?> value="Plateau">Plateau</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Rivers" ) echo "selected"; ?> value="Rivers">Rivers</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Sokoto" ) echo "selected"; ?> value="Sokoto">Sokoto</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Taraba" ) echo "selected"; ?> value="Taraba">Taraba</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Yobe" ) echo "selected"; ?> value="Yobe">Yobe</option>
<option <?php if(isset($userRow2['school_state']) && $userRow2['school_state'] == "Zamfara" ) echo "selected"; ?> value="Zamfara">Zamfara</option>
</select>
</div> <div class="w3-third w3-padding"> <span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Course Admitted For</div>
<div class="w3-third w3-padding" ><input name="course_admitted_for" class="w3-input w3-border w3-round" type="text" value="<?php if(isset($userRow2['course_admitted_for'])) echo $userRow2['course_admitted_for']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Study Time</div>
<div class="w3-third w3-padding" >
<select class="w3-select w3-round w3-border" name="study_time">
<option value="">Not Specified</option>
<option <?php if(isset($userRow2['study_time']) && $userRow2['study_time'] == "Full time" ) echo "selected";?> value="Full time">Full Time</option>
<option <?php if(isset($userRow2['study_time']) && $userRow2['study_time'] == "Part time" ) echo "selected";?> value="Part time">Part Time</option>
</select>
</div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Entry Mode</div>
<div class="w3-third w3-padding" >
<select class="w3-select w3-round w3-border" name="entry_time">
<option value="">Not Specified</option>
<option <?php if(isset($userRow2['entry_mode']) && $userRow2['entry_mode'] == "Jamb/Poly Jamb" ) echo "selected";?> value="Jamb/Poly Jamb">Jamb Or Poly Jamb</option>
<option <?php if(isset($userRow2['entry_mode']) && $userRow2['entry_mode'] == "Direct Entry/Pre-degree/NCE" ) echo "selected";?> value="Direct Entry/Pre-degree/NCE">Direct Entry Or Pre Degree Or NCE</option>
</select>
</div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Admission Year</div>
<div class="w3-third w3-padding" ><input name="admission_year" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['admission_year'])) echo $userRow2['admission_year']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Matric Number</div>
<div class="w3-third w3-padding" ><input name="mat_no" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['mat_no'])) echo $userRow2['mat_no']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Course of Study</div>
<div class="w3-third w3-padding" ><input name="course_of_study" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['course_of_study'])) echo $userRow2['course_of_study']; ?>"></div>
<div class="w3-third w3-padding">Write Medical for all medical related courses and Law for law related courses.<span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Duration of Course</div>
<div class="w3-third w3-padding" ><input name="course_duration" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['course_duration'])) echo $userRow2['course_duration']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span> e.g. 4</div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Current Level</div>
<div class="w3-third w3-padding" ><input name="current_level" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['current_level'])) echo $userRow2['current_level']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">CGPA Scale</div>
<div class="w3-third w3-padding" ><input name="cgpa_scale" class="w3-input w3-border w3-round " type="text" placeholder="E.g. 5 for University" value="<?php if(isset($userRow2['cgpa_scale'])) echo $userRow2['cgpa_scale']; ?>"></div>
<div class="w3-third w3-padding">5 for all Universities and 4 for Others or as applicable.<span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Current CGPA</div>
<div class="w3-third w3-padding" ><input name="current_cgpa" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['current_cgpa'])) echo $userRow2['current_cgpa']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Expected Graduation Year</div>
<div class="w3-third w3-padding" ><input name="expected_graduation_year" class="w3-input w3-border w3-round " type="text" value="<?php if(isset($userRow2['expected_graduation_year'])) echo $userRow2['expected_graduation_year']; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<br><br>
<div class="w3-row">
<div class="w3-third w3-padding"> </div>
<div class="w3-twothird w3-padding" style="text-align:right;"><button class="w3-btn w3-left w3-dark-grey w3-hover-grey" name="update">Update</button></div>
</div>
</form>
</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>Designed by <a href="www.sita.ondostate.gov.ng"><img src="images/sitaLogo.png" width="60" style="border-radius:10px"></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>