date searches

gsinker

I have trying to get a query show when a room in our hotel is not booked. I have set up a database that show when the room is booked but i need to show when the rooms are vacant.

help

eoghain

What data do you have to check on?

gsinker

I enter a start date 0000-00-00 and also a end date 0000-00-00

this is the date the room is booked what I need to be able to do is show when the room is vacant when I do a seach by date from and till.

I hope this makes sense?

eoghain

You should be able to run a query like:

SELECT *
FROM rooms
WHERE date NOT BETWEEN '0000-00-00' AND '0000-00-00'

gsinker

Thanks that works and it was so much simpler than what i was trying to do. All I have to do now is work out how to put the query into my search form.
I think i need to set the room type as a variable and get the the form to search on the startdate again as a variable.

Something like $roomtype and $startdate and $endate.

BTW this is the query that I have so far
SELECT *
FROM bookings WHERE bookings.roomtype = 'spring creek' AND startdate NOT BETWEEN '2002-11-23' AND '2002-11-30' LIMIT 0, 30

the date sI entered manually to test the query

Also do you know of a method to stop a user enter a endate that is before the startdate?

eoghain

The only way to stop the user from entering an end date that is before the start date is to use JavaScript. I don't know much about JavaScript so you're on your own with that. But you can always just do a sanity check on the data (you should do this anyway for security) and kick them back to the form if they've entered an end date that is before the start date.

As for making your query dynamic just use a web form and post your data to the query form and put it all together:

<?php
$query = "
SELECT *
FROM bookings 
WHERE bookings.roomtype = '" . $_POST["room_type"] . "'
AND startdate NOT BETWEEN '" . $_POST["start_date"] . "' AND '" . $_POST["end_date"] . "'
LIMIT 0, 30" 
?>

gsinker

Thanks for all your help it took some playing with but I finally got it going. I am just adding some more touches to it and it will soon go live.

My next venture is my real estate site one item i need is the ability for a client to print of the screen that is displayed I have seen buttons on site that say print do you know if they just print of the actual info or do they print everything including headers?

😃

eoghain

Most sites that offer a print button use that button to show the user a printer friendly version of the page. I've never set one up so I don't know what a printer friendly version is, but the ones I've seen end up not having any background color or ads.