<?php
ob_start();
$aa="<h3><a href='biodata.php'>Update Biodata</a></h3>";
require_once('headMain.php');
require_once('../connect.php');
  $xk=$_SESSION['sex'];
$db=db_connect();
$sql=$db->query("select * from realdata where matNo='$matNo' and graduated<>'Yes' and matNo not in (select matNo from room_allocation)");
if ($sql->rowCount()==1){

    $sql_fetch=$sql->fetch(PDO::FETCH_ASSOC);
      $genda=$sql_fetch['sex'];
        $aspoaLink="hostel_process.php?id_type=".$xk;
    echo "<h3 style='color: red'>Are you a ". $genda."?, If No, Kindly refill you Bio-data before you proceed.</h3>".$aa."<br>";

    echo ' <h3 class="widget-thumb-heading"><a href='.$aspoaLink.'> Book for Accommodation</a></h3>';
//echo "am here";
//    echo $xk;
}else{
    $kk=$db->query("select * from room_allocation where matNo='$matNo' and status=0 ");
    $kk_count=$kk->rowCount();
    $check_fetch=$kk->fetch(PDO::FETCH_ASSOC);
    $check_sn=$check_fetch['sn'];
    if ($kk_count==1){
        echo "<h2>You have been Previously Allocated to a Bed Space </h2>";
        echo '<h2><a href="index_pay_accomodation?ID='.$check_sn.'">Click Here to Pay</a> </h2>';
    }else{
        echo '<h2>You are not Qualify to apply for Hostel or You have Been Allocated Before. Thank you</h2>';
        echo '<div style="text-align: right"><a href="javascript:history.go(-1)"> Go to Previous page</a></div>';
    }



}
?>
<?php
include('footMain.php');
ob_end_flush();
?>
</div>