<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("tcems", $con);

if($_POST["AccomIden"]=='' OR $_POST["AccomName"]=='' OR $_POST["AccomPword"]=='' OR $_POST["NumRooms"]=='' OR $_POST["type"]==''){
include("header.php");
echo "
<div id=all>
    <fieldset style=text-align:center>
  <table align=center class=prompt>
  <tr>
  <td class=imggoback rowspan=2>&nbsp</td>
  <td class=norecord>
    Please, fill up text boxes!
  </td>
  </tr>

  <tr>
  <td class=goback>
  <a class=goback href='NewAccomh.php'>Go Back</a>
  </td>
  </tr>
  </table>
  </fieldset>
  </div>
";

}
else{
 $verify=$_POST["verify"];
 $accom=$_POST["AccomPword"];
$query="SELECT * FROM tblVerify where AccomIden='$_POST[AccomIden]'";
$result = mysql_query($query);
 $flag=0;
 while ($row=mysql_fetch_array($result))
{
   $flag=$flag+1;
  }
if($flag==0){
         if ($verify==$accom) {
         $sql="INSERT INTO tblVerify (AccomIden, NameAccom, Password, NumRooms, Classification, Type)
VALUES
('$_POST[AccomIden]','$_POST[AccomName]','$_POST[AccomPword]','$_POST[NumRooms]','$_POST[classification]','$_POST[type]')";

    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    else
    {
        include ("main.php");     //if all boxes filled
      echo "<script type='text/javascript'>
  alert('Successfully saved. Waiting for verification.');
  </script>";
    }
         } else {
   include("header.php");
  echo "<script type='text/javascript'>
  alert('Accomodation Password and Verify Password not match.');
  </script>";

  echo"
  <div id=all>
    <fieldset style=text-align:center>
<table class=prompt align=center>

<tr>
    <td class=imggoback>.</td>
    <td class=goback><a class=goback href=NewAccomh.php>GO BACK</a></td>
</tr>

</table>
</fieldset>
</div>
  ";
         }

}
else
{
  include("header.php");
  echo "<script type='text/javascript'>
  alert('Accomodation Id already exists.');
  </script>";

  echo"
  <div id=all>
    <fieldset style=text-align:center>
<table class=prompt align=center>

<tr>
    <td class=imggoback>.</td>
    <td class=goback><a class=goback href=NewAccomh.php>GO BACK</a></td>
</tr>

</table>
</fieldset>
</div>
  ";

   //wrong admin password  //flag is not equal to zero or accom id existing
}

 }


mysql_close($con);


?>