<?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);
			  //$result=$db->query("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'");
$result=$db->prepare("UPDATE `fedpoly`.`ace_realdata` SET `state` = ?, `lga` = ?,`dob` = ?,`gsm` =? ,`sex` =? ,`address` =? ,`email` =? ,`gNames`=?,`gGSM`=?,`gAddress`=?,`homeTown`=?, `jambNo`=? WHERE `ace_realdata`.`matNo` =?");
$result->execute([$txtstate,$lga,$dob,$gsm,$sex,$address,$email,$gName,$gGSM,$gAddress,$home,$jambNo,$matNo]);
			  if ($result){
                  header('location:'.'biodata.php?id=1');
              }else{
                  header('location:'.'biodata.php?id=2');
              }

?>