jacomus Posted March 28, 2008 Share Posted March 28, 2008 Alright, now I am very very new to databases in general, and fairly new to PHP. My question is rather simple, I am just wondering that in the case of booking: A person books from January 1st until January 20th, to return an error if someone tried to book within that time period, would that be a PHP function, or someething that can be handled in MySQL? Link to comment https://forums.phpfreaks.com/topic/98330-quick-newbie-booking-question-in-mysql/ Share on other sites More sharing options...
mwasif Posted March 28, 2008 Share Posted March 28, 2008 You need to handle this in MySQL by comparing the booked dates and the new dates which a user is looking for. Link to comment https://forums.phpfreaks.com/topic/98330-quick-newbie-booking-question-in-mysql/#findComment-503161 Share on other sites More sharing options...
aschk Posted March 28, 2008 Share Posted March 28, 2008 A combination I would say, take the times they have chosen, perform a SQL SELECT query to find if anything exists during those times, if you get a result (i.e. more than 0 rows returned) then there will be a conflict, otherwise you're good to perform an INSERT statement. All of this could of course be done inside a procedure should you so choose. Link to comment https://forums.phpfreaks.com/topic/98330-quick-newbie-booking-question-in-mysql/#findComment-503201 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.