Not allowing a user to book if they have two bookings that day already

rix1505 · 07-02-2010, 12:08 PM

Hi folks!

OK I have got on pretty well with little php / mysql project for a Water Ski Tow booking system

I'm nearly done, just one thing I'm puzzled with.

Members can log in and look at a list of ski two booking slots, and book a slot that is available. What I want to do, is once a member has booked two slots that day, is prevent them from booking anymore.

So, my database table is called bookings and it contains

ID (primary key, auto increment)
skidate (date of the slot, e.g. 03 July 2010)
skitime (time of the slot e.g. 09:10)
status (available, booked, or blocked)
member_ID (the username of the person if it's booked)

Do I check the table when a user tries to book a third slot that day, using some method in my insert script, or do I somehow not list records for days where a member has already booked 2 slots, and how would I do either of these?

Thanks in advance!

Rich :)

dschreck · 07-21-2010, 09:32 PM

Since you're limiting them to two entries, you're going to need some application side logic to control that.

This could be pretty simple to integrate into the user flow if you have a specific page that they need to hit when registering a reservation.

For example:

PHP Code:


			


$sql = "SELECT 1 WHERE member_ID = {$memberID}";

$res = mysql_query($sql);

$numRows = mysql_num_rows($res);



if($numRows < 2)

{

   // they can add a new one

}

else

{

 // they can't 

}

Also note that you'll need a cron or script that will automagically clean up the table to remove all their past reservations. Or, you'd need a date where clause on the query.