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 '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'];
//$surname = $_SESSION['surname'];
//$firstname = $_SESSION['firstname'];
//$email = $_SESSION['email'];
//$phone = $_SESSION['phone'];
//echo $user_id;
$result = mysqli_query($conn,"SELECT * FROM scholarship WHERE user_id = '$user_id'");
$test = mysqli_fetch_array($result);
//if ($result)
if(mysqli_num_rows($result)>0)
{
$surname=$test['surname'] ;
$firstname= $test['firstname'] ;
$email=$test['email'] ;
$phone=$test['phone'] ;
$middle_name=$test['middle_name'] ;
$nin=$test['nin'] ;
$dob=$test['dob'] ;
$gender=$test['gender'] ;
$marital_status=$test['marital_status'] ;
$residence_address=$test['residence_address'] ;
$residence_city=$test['residence_city'] ;
$residence_state=$test['residence_state'] ;
$residence_country=$test['residence_country'] ;
$origin_country=$test['origin_country'] ;
$origin_state=$test['origin_state'] ;
$origin_lga=$test['origin_lga'] ;
$origin_town=$test['origin_town'] ;
//Query to retrieve select box data from the database for display
$sql5 = "SELECT gender, marital_status, residence_state, residence_country, origin_country, origin_state, origin_lga FROM scholarship WHERE user_id = '$user_id'";
$result5 = mysqli_query($conn, $sql5);
$row = mysqli_fetch_array($result5);
$gender = $row['gender'];
$marital_status = $row['marital_status'];
$residence_state = $row['residence_state'];
$residence_country = $row['residence_country'];
$origin_country = $row['origin_country'];
$origin_state = $row['origin_state'];
$origin_lga = $row['origin_lga'];
}
else
{
$result1 = mysqli_query($conn,"SELECT * FROM registration WHERE user_id = '$user_id'");
$test = mysqli_fetch_array($result1);
if(mysqli_num_rows($result1)>0)
//if ($result)
{
$surname=$test['surname'] ;
$firstname= $test['firstname'] ;
$email=$test['email'] ;
$phone=$test['phone'] ;
$middle_name=" ";
$nin=" ";
$dob=" ";
$gender="Select Sex";
$marital_status="Marital Status";
$residence_address=" ";
$residence_city=" ";
$residence_state="Residence State";
$residence_country="Residence Country";
$origin_country="Origin Country";
$origin_state="Origin State";
$origin_lga="Origin Lga";
$origin_town=" ";
$registered_date=" ";
$date_updated=date("Y-m-d H:i:s");
//$origin_town=" ";
//echo $user_id;
//echo $email;
$result2 = mysqli_query($conn,"SELECT * FROM scholarship WHERE user_id = '$user_id'");
$test2 = mysqli_fetch_array($result2);
//if (!$result2)
if(!mysqli_num_rows($result2)>0)
{
$query=mysqli_query($conn,"INSERT INTO `scholarship` (`id`, `user_id`, `nin`, `surname`, `firstname`, `middle_name`, `dob`, `gender`, `marital_status`, `email`, `phone`, `residence_address`, `residence_city`, `residence_state`, `residence_country`, `origin_country`, `origin_state`, `origin_lga`, `origin_town`, `nok_name`, `nok_phone`, `nok_relationship`, `academic_ref`, `ref_phone`, `ref_relationship`, `enjoy_scholarship_before`, `enjoy_scholarship_before_detail`, `any_disability`, `disability_detail`, `father_name`, `father_phone`, `father_occupation`, `mother_name`, `mother_phone`, `mother_occupation`, `parent_address`, `school_country`, `school_state`, `school_name`, `course_admitted_for`, `study_time`, `entry_mode`, `admission_year`, `mat_no`, `course_of_study`, `course_duration`, `current_level`, `cgpa_scale`, `current_cgpa`, `expected_graduation_year`, `photo`, `bank`, `account_name`, `account_number`, `registered_date`, `date_updated`, `completed`, `remark`) VALUES (NULL, '$user_id', '$nin', '$surname', '$firstname', '$middle_name', '$dob', '$gender', '$marital_status', '$email', '$phone', '$residence_address', '$residence_city', '$residence_state', '$residence_country', '$origin_country', '$origin_state', '$origin_lga', '$origin_town', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '$registered_date', '$date_updated', '0', NULL)");
//$row=mysqli_fetch_array($query);
}
}
}
?>
<!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
//$email = $row['email'];
//$firstname = $row['firstname'];
//$surname = $row['surname'];
//$phone = $row['phone'];
//$user_id = $row['user_id'];
echo $firstname . " " . $surname . " " . "[" . $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">
<!-- Panel -->
<div class="w3-quarter w3-padding">
<a href="dashboard_personal_data.php" style=" text-decoration:none"><div class="w3-row w3-padding w3-border-top w3-border-bottom w3-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-light-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>
<!-- eND pANEL -->
<!-- Form -->
<div class="w3-threequarter">
<form class="w3-container" method="POST" action="dashboard_personal_data_process.php">
<div class="w3-row w3-padding">
<h4><b>Personal Information </b><br> Provide basic personal information. Fields mark with <span style="color:#F60">*</span> are compulsory.</h4>
</div>
<div class="w3-row w3-padding">
<h4><b> Basic Biodata </b></h4>
</div>
<div class="w3-row w3-padding">
<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>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Surname </div>
<div class="w3-third w3-padding" ><input name="surname" class="w3-input w3-border w3-round" type="text" value="<?php echo $surname; ?>" readonly="readonly"></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">First Name</div>
<div class="w3-third w3-padding" ><input name="firstname" class="w3-input w3-border w3-round" type="text" value="<?php echo $firstname; ?>" readonly="readonly"></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">Middle Name</div>
<div class="w3-third w3-padding"><input name="middle_name" class="w3-input w3-border w3-round" type="text" value="<?php echo $middle_name; ?>"></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">Your NIN</div>
<div class="w3-third w3-padding"><input name="nin" class="w3-input w3-border w3-round" type="text" value="<?php echo $nin; ?>"></div>
<div class="w3-text w3-justify w3-padding">Visit <a href="http://ninenrol.gov.ng">http://ninenrol.gov.ng</a> to learn more about the National Identity</div>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Date of Birth</div>
<div class="w3-third w3-padding" ><input name="dob" class="w3-input w3-border w3-round tcal" type="date" value="<?php echo $dob; ?>"></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">Gender</div>
<div class="w3-third w3-padding" >
<?php include 'gender.php'; ?>
</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">Marital Status</div>
<div class="w3-third w3-padding" >
<?php include 'marital_status.php'; ?>
</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">Email</div>
<div class="w3-third w3-padding" ><input name="email" class="w3-input w3-border w3-round" type="text" value="<?php echo $email; ?>" readonly="readonly"></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">Phone Number</div>
<div class="w3-third w3-padding" ><input name="phone" class="w3-input w3-border w3-round" type="text" value="<?php echo $phone; ?>" readonly="readonly">
</div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row w3-padding">
<h4><b>Residential Details </b></h4>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Address</div>
<div class="w3-half w3-padding" ><textarea name="residence_address" class="w3-input w3-border w3-border-top w3-border-bottom w3-round"> <?php echo $residence_address; ?> </textarea>
</div>
<div class="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">City</div>
<div class="w3-third w3-padding" ><input name="residence_city" class="w3-input w3-border w3-border-top w3-border-bottom w3-round" type="text" value="<?php echo $residence_city;?>">
</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">State of Residence</div>
<div class="w3-third w3-padding" >
<?php include 'residence_state.php'; ?>
</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">Country of Residence</div>
<div class="w3-third w3-padding" >
<?php include 'residence_country.php'; ?>
</div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<div class="w3-row w3-padding">
<h4><b> Nationality Details </b></h4>
</div>
<div class="w3-row">
<div class="w3-third w3-padding" style="text-align:right; padding-right:100px">Country of Origin</div>
<div class="w3-third w3-padding" >
<?php include 'origin_country.php'; ?>
</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">State of Origin</div>
<div class="w3-third w3-padding" >
<?php include 'origin_state.php'; ?>
</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">LGA of Origin</div>
<div class="w3-third w3-padding" >
<?php include 'origin_lga.php'; ?>
</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">Town of Origin</div>
<div class="w3-third w3-padding" ><input name="origin_town" class="w3-select w3-round w3-border" type="text" value="<?php echo $origin_town; ?>"></div>
<div class="w3-third w3-padding"><span style="color:#F60">*</span></div>
</div>
<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" type="submit" name = "update">Update</button></div>
</div>
</form>
</div>
<!-- eND Form -->
</div>
<br>
</div>
</div>
<!-- end scholarship plan -->
<br>
<!-- form validation starts here-->
<!-- /form validation ends here-->
<!-- 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>