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();
//include 'personal_info_validate.php';
// if session is not set this will redirect to login page
if( !isset($_SESSION['user_id']) ) {
header("Location: index.php");
exit;
}
if($_POST['middle_name'] == '')
{
$_SESSION['err_msg'] = "Enter your middle name";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['dob'] == '' OR $_POST['dob'] == 'Select...')
{
$_SESSION['err_msg'] = "Select your date of birth";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['gender'] == '')
{
$_SESSION['err_msg'] = "Select your gender";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['marital_status'] == '')
{
$_SESSION['err_msg'] = "Select your marital status";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['residence_address'] == '')
{
$_SESSION['err_msg'] = "Enter your residential address";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['residence_city'] == '')
{
$_SESSION['err_msg'] = "Enter your city of residence";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['residence_state'] == '')
{
$_SESSION['err_msg'] = "Enter your state of residence";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['residence_country'] == '')
{
$_SESSION['err_msg'] = "Enter your country of residence";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['origin_country'] == '')
{
$_SESSION['err_msg'] = "Enter your country of origin";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['origin_state'] == '')
{
$_SESSION['err_msg'] = "Enter your state of origin";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['origin_lga'] == '')
{
$_SESSION['err_msg'] = "Enter your local govt. of origin";
header('location:dashboard_personal_data.php');
exit;
}
if($_POST['origin_town'] == '')
{
$_SESSION['err_msg'] = "Enter your town of origin";
header('location:dashboard_personal_data.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'];
if( isset($_POST['update']) )
{
function check_input($data)
{
$data=trim($data);
$data=stripslashes($data);
$data=htmlspecialchars($data);
return $data;
}
//$email=check_input($_POST['email']);
$user_id = $_SESSION['user_id'];
//$email=check_input($_POST['email']);
$nin=check_input($_POST['nin']);
$middle_name=check_input($_POST['middle_name']);
$dob=check_input($_POST['dob']);
$gender=check_input($_POST['gender']);
$marital_status=check_input($_POST['marital_status']);
$residence_address=check_input($_POST['residence_address']);
$residence_city=check_input($_POST['residence_city']);
$residence_state=check_input($_POST['residence_state']);
$residence_country=check_input($_POST['residence_country']);
$origin_country=check_input($_POST['origin_country']);
$origin_state=check_input($_POST['origin_state']);
$origin_lga=check_input($_POST['origin_lga']);
$origin_town=check_input($_POST['origin_town']);
//$firstname=check_input($_POST['firstname']);
//$surname=check_input($_POST['surname']);
//$phone=check_input($_POST['phone']);
mysqli_query($conn,"UPDATE scholarship
SET nin='$nin'
, middle_name = '$middle_name'
, dob = '$dob'
, gender = '$gender'
, marital_status = '$marital_status'
, residence_address = '$residence_address'
, residence_city = '$residence_city'
, residence_state = '$residence_state'
, residence_country = '$residence_country'
, origin_country = '$origin_country'
, origin_state = '$origin_state'
, origin_lga = '$origin_lga'
, origin_town = '$origin_town'
WHERE user_id='$user_id'");
//or die(mysqli_error());
//header("refresh:0");
//echo $_SERVER['PHP_SELF'];
//header("Location:dashboard_personal_data.php");
//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'];
$result = mysqli_query($conn,"SELECT * FROM scholarship WHERE user_id = '$user_id'");
$test = mysqli_fetch_array($result);
if (!$result)
{
die("Error: Data not found... for scholarship");
}
$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'] ;
//$registered_date=" ";
//$date_updated=" ";
//$origin_town=" ";
$_SESSION['success_msg'] = "Successfully Updated!";
}
?>
<!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="<?=$_SERVER['PHP_SELF']?>">
<div class="w3-row w3-padding">
<h3><b>Personal Information </b><br> Provide basic personal information</h3>
</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"> </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"> </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>
<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="text" value="<?php echo $dob; ?>"></div>
<div class="w3-third w3-padding"> </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_update.php'; ?>
</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_update.php'; ?>
</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"> </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"> </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>
<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>
<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_update.php'; ?>
</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_update.php'; ?>
</div>
<div class="w3-third w3-padding"> </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_update.php'; ?>
</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_update.php'; ?>
</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_update.php'; ?>
</div>
<div class="w3-third w3-padding"> </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-input w3-border w3-round" type="text" value="<?php echo $origin_town; ?>"></div>
<div class="w3-third w3-padding"> </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>
<!-- 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>