Checking Availability Script

uniboy86 · December 24, 2007

I am building a Letting and Maintenance managment system for my final year project. I have got a script to check avavailability and a table that displays the results but the loop I have displays the results before a query as been performed. And in a column in table it links to the booking script which is pointless having a check availability script if they can bypass.

Here is my code for the check availability page:

<?php

session_start();

if(isset($_SESSION['username']) == false){

header("Location: login.php");

exit();

}

$_SESSION['arrivaldate']=$_GET['arrivaldate'];

$_SESSION['departuredate']=$_GET['departuredate'];

require "connect.php";

$query = "SELECT RoomNo, Size, RentPerWeek FROM Room WHERE RoomNo NOT IN (SELECT RoomNo FROM Booking WHERE ArrivalDate < '".$_GET['departuredate']."' AND DepartureDate >'". $_GET['arrivaldate']."')";

$result = mysql_query($query, $connection)

or die("Unable to execute query<br>$query");

$query2 = "select * from dates";

$result2 = mysql_query($query2, $connection)

or die("Unable to execute query<br>$query2");

$query3 = "select * from dates";

$result3 = mysql_query($query3, $connection)

or die("Unable to execute query<br>$query3");

?>

<html>

<head>

</head>

<body>

<span>

</span>

</div>

<ul>

</ul>

</div>

<h1>Check Room Availability</h1>

<p><label for="arrivaldate">Arrival Date:</label>

<?php

while($row=mysql_fetch_array($result2))

{?>

<?php }?>

</select>

<label for="departuredate">Departure Date:</label>

<?php

while($row=mysql_fetch_array($result3))

{ ?>

<?php } ?>

</select>

</p>

</form>

<table>

<?php

while($row=mysql_fetch_array($result))

{?>

<tr>

</tr>

<?php

} ?>

</table>

</div>

</div>

</body>

</html>

Also how can i display results in muliple columns i have been told it is using a count but not too good at php to do this kind of logic

uniboy86 · December 24, 2007

Having read what I wrote I dont think I was very clear what I wrote. Basically this is what I want to be able to do:

I display a page with the search facility on I use a search facility which the limits the results table to only the rooms available to book. I want to know how I stop the query being executed until I have searched for rooms available to be booked during a certain day. The code for this page is in the previous.

Can somebody please guide me in the right direction. I know it has something to do with an IF statement but I dont really know where to put it and what conditions I have to use.

Please Help

Thanks

Sign In

Checking Availability Script

Recommended Posts

uniboy86

Link to comment

Share on other sites

uniboy86

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information