File Explorer

<?php include("includes/css.php");
if (isset($_POST['update_address'])) {
extract($_POST);
  $user_id=$_SESSION['staff_id'];
$sql1 ="UPDATE  staff_address  SET state='$state',city='$city',address='$address',pincode='$pincode',permanent_state='$permanent_state',permanent_city='$permanent_city',permanent_address='$permanent_address',permanent_pincode='$permanent_pincode'  WHERE staff_id='".$user_id."'"; 
$res=mysqli_query($conn,$sql1) or die(mysqli_error());
}
?>
<body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">
        <?php include("includes/header.php")?>
        <?php include("includes/sidebar.php")?>
        
        <div class="content-wrapper">
            
            
            <section class="content">
                <div class="row">
                    <div class="col-md-12">
                        <div class="box box-primary">
                            <div class="box-header with-border">
							  <div class="col-md-7">
                                    <h3 class="box-title">Staff Address Details:</h3>
                                </div>
                            </div>
                            <div class="box-header with-border">
                                <?php include("includes/staff-profile-menu.php")?>
                            </div>
                             <?php $id=$_SESSION['staff_id'];
							$sql_addr="select * from staff_address where staff_id=".$id;
									$result_addr = mysqli_query($conn, $sql_addr);
									$res_addr= mysqli_fetch_array($result_addr);?>
							
                            
                            <div class="box-body">
								<div class="row">
                                  <form class="form-horizontal" action="" method="post"> 
                                    <div class="col-md-6">
										 <h3 class="box-title mt-5 pl-20">Current Address:</h3> 
										 <div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">Address</label>
												<div class="col-md-8">
													<textarea class="form-control" name="address" rows="3" type="text"><?php echo $res_addr['address']; ?> </textarea>
												</div>
											</div>
										 </div>
										 <div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">State</label>
												<div class="col-md-8">
													 <select class="form-control" name="state">
														<option value="<?php echo $res_addr['state']; ?>"><?php echo $res_addr['state']; ?></option>
														<option >Delhi</option>
														<option >Telangana</option>  
													</select>										 
												</div> 
											</div>
										</div>
										<div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">City</label>
												<div class="col-md-8">
													 <select class="form-control" name="city">
														<option value="<?php echo $res_addr['city']; ?>"><?php echo $res_addr['city']; ?></option>
														<option >Anand Vihar</option>
														<option >Hyderabad</option> 
													</select>										 
												</div> 
											</div>
										</div>
										 <div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">Zip Code</label>
												<div class="col-md-8">
													<input class="form-control" name="pincode" value="<?php echo $res_addr['pincode']; ?>" type="text"> 
												</div>
											</div>
										 </div> 
									</div> 
                                      <div class="col-md-6">
										<h3 class="box-title mt-5 pl-20">Permanent Address:  </h3> 
										 <div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">Address</label>
												<div class="col-md-8">
													<textarea class="form-control" name="permanent_address" rows="3" type="text"> <?php echo $res_addr['permanent_address']; ?></textarea>
												</div>
											</div>
										 </div>
										<div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">State</label>
												<div class="col-md-8">
													 <select class="form-control" name="permanent_state">
														<option value="<?php echo $res_addr['permanent_state']; ?>" ><?php echo $res_addr['permanent_state']; ?></option>
														<option >Delhi</option>
														<option >Telangana</option>  
													</select>										 
												</div> 
											</div>
										</div>
										<div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">City</label>
												<div class="col-md-8">
													 <select class="form-control" name="permanent_city">
														<option value="<?php echo $res_addr['permanent_city']; ?>" ><?php echo $res_addr['permanent_city']; ?></option>
														<option >Anand Vihar</option>
														<option >Hyderabad</option> 
													</select>										 
												</div> 
											</div>
										</div>
										 <div class="col-md-12">
											<div class="form-group">
												<label class="control-label col-md-4">Zip Code</label>
												<div class="col-md-8">
													<input class="form-control" name="permanent_pincode" value="<?php echo $res_addr['permanent_pincode']; ?>" type="text"> 
												</div>
											</div>
										 </div> 
									</div> 
                                     
									<div class="col-md-offset-1 col-md-3">
										<button type="submit" class="btn btn-success btn-lg mt-20" name="update_address"><i class="fa fa-check"></i> Update</button> 
									</div>
								</form>
							</div> 
						</div>
					</div>
				</div> 
			</div>
		</section>
    </div>
	<?php include("includes/footer.php")?>
	</div>
	<?php include("includes/js.php")?>
</body>

</html>

Editing File: staff-address-details.php