<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 06:01 PM
 */
session_start();
$matNo=$_SESSION['matNo'];
			  require('../connect.php');
$db=db_connect();
			  extract($_POST);
 $material=$_FILES['user_file1'];
$folder="image/";
$material_name=$_FILES['user_file1']['name'];
$material_type=$_FILES['user_file1']['type'];
$material_tmp=$_FILES['user_file1']['tmp_name'];
$material_size=$_FILES['user_file1']['size'];
$old=$_FILES['user_file1']['tmp_name'];
$new="../passport/Reg".$matNo.".jpg";
move_uploaded_file($old,$new);

//Retain Data
//`state` = '$txtstate', `lga` = '$lga',`dob` = '$dob',`gsm` = '$gsm',`sex` = '$sex',`address` = '$address',`email` = '$email',`gNames`='$gName',`gGSM`='$gGSM',`gAddress`='$gAddress',`homeTown`='$home'

if ($txtstate=='Select Option...')$txtstate=$hState;
if ($lga=='') $lga=$hlga;
if ($dob=='')$dob=$hdob;
if ($gsm=='') $gsm=$hgsm;
if ($sex=='') $sex=$hsex;
if ($address=='') $address=$haddress;
if ($email=='') $email=$hemail;
if ($gName=='') $gName=$hgNames;
if ($gGSM=='') $gGSM=$hgNames;
if ($gAddress=='') $gAddress=$hgAddress;
if ($home=='') $home=$hgAddress;

//End of data retain


$address=str_replace("'","''",$address);
$gAddress=str_replace("'","''",$gAddress);
 $aspoa="UPDATE `fedpoly`.`ace_realdata` SET `state` = '$txtstate', `lga` = '$lga',`dob` = '$dob',`gsm` = '$gsm',`sex` = '$sex',`address` = '$address',`email` = '$email',`gNames`='$gName',`gGSM`='$gGSM',`gAddress`='$gAddress',`homeTown`='$home' WHERE `ace_realdata`.`matNo` ='$matNo'";
//die();

			  $result=$db->query($aspoa);
			  if ($result){
                  header('location:'.'ace_pre_biodata.php?id=1');
              }else{
                  header('location:'.'ace_pre_biodata.php?id=2');
              }

?>