Solarpitch Posted January 28, 2008 Share Posted January 28, 2008 Hey, Just looking for a little help with this. I have a table in my DB that has a date and time column. Bascially it allows an admin to block a date to stop a customer from making a booking. So if I have a list of dates that were blocked, how would I loop through them and check it against the value the customer has entered? Customer enters 28/1/08 Dates Blocked... 27/1/08 28/1/08 02/2/08 05/3/08 message "This date is not available". Link to comment https://forums.phpfreaks.com/topic/88180-loop-to-check-a-value/ Share on other sites More sharing options...
priti Posted January 28, 2008 Share Posted January 28, 2008 hmmm,, well one thing you can do is convert both dates in timestamp format using mktime() and check if it is equal.If found == then it is blocked and you can show you message. Regards Link to comment https://forums.phpfreaks.com/topic/88180-loop-to-check-a-value/#findComment-451135 Share on other sites More sharing options...
adam291086 Posted January 28, 2008 Share Posted January 28, 2008 if the blocked list is saved in a database. Then try the following 1) select everything from the blocked table 2) use mysql_fetch_array 3) then using foreach($database_array_name as $blocked) { if($blocked == $datefromcustomer) { echo "date not allowed"; } else { update } Link to comment https://forums.phpfreaks.com/topic/88180-loop-to-check-a-value/#findComment-451137 Share on other sites More sharing options...
Solarpitch Posted January 28, 2008 Author Share Posted January 28, 2008 Cheers guys... I'll give it ago after lunch and see how i get on Link to comment https://forums.phpfreaks.com/topic/88180-loop-to-check-a-value/#findComment-451156 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.