alert(' Password does NOT match to Accomodation ID');
";
}
else{
$query3="SELECT * FROM tblnewaccom where AccomIden='$r'";
$result3 = mysql_query($query3);
$flag3=0;
while ($row3=mysql_fetch_array($result3))
{
$flag3=$flag3+1;
}
if($flag3>0){
$query="SELECT * FROM tblrooms where Accom='$r' and roomnumber='$s'";
$result = mysql_query($query);
$flag=0;
while ($row=mysql_fetch_array($result))
{
$flag=$flag+1;
}
if($flag==0){
$sql="INSERT INTO tblrooms (Accom, roomnumber, Available,Month,Year,Day)
VALUES
('$_POST[addRoom]','$_POST[room]','available','$month','$year','$day')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
}
}
else{
echo "";
}
}
}
else{
$day=date("d");
$month=date("F");
$year=date("Y");
$r=$_POST["addRoom"];
$s=$_POST["room"];
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$pass=$_POST["pass"];
$query5="SELECT * FROM tblnewaccom where AccomIden='$r' and Password='$pass'";
$result5 = mysql_query($query5);
$flag5=0;
while ($row5=mysql_fetch_array($result5))
{
$flag5=$flag5+1;
}
if ($r=='' or $s='') {
header('Location: AddRoom.php');
}
mysql_select_db("tcems", $con);
if ($flag5==0) {
echo "";
}
else{
$query3="SELECT * FROM tblnewaccom where AccomIden='$r'";
$result3 = mysql_query($query3);
$flag3=0;
while($row3=mysql_fetch_array($result3))
{
$flag3=$flag3+1;
}
if($flag3>0){
$query="SELECT * FROM tblrooms where Accom='$r' and roomnumber='$s'";
$result = mysql_query($query);
$flag=0;
while ($row=mysql_fetch_array($result))
{
$flag=$flag+1;
}
if($flag==0){
$sql="INSERT INTO tblrooms (Accom, roomnumber, Available,Month,Year,Day)
VALUES
('$_POST[addRoom]','$_POST[room]','available','$month','$year','$day')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
}
}
else{
echo "";
}
}
}
mysql_close($con);
?>
Add Room