Php Scripting : Mysql Time format and PHP Calc based on opening hours in database

[daknightuk]

Hi people,

I'm working on a project where I have a MYSQL database containing a database table which has opening hours of a load of businesses in it.

Each business has 4 TIME fields for each day in the format 00:00:00 which are named to indicate the weekday i.e MONOPEN1, MONCLOSE1, MONOPEN2, MONCLOSE2, TUEOPEN1....... ..

My original idea was to output it as a table in the format

Monday
10:00-12:00
14:00-16:00.......... . obviously showing 4 times per weekday

I then found that I haven't got room for it on my webpage so I decided that the best way would just to give a visual indication as to whether the business is open or closed.

So I had to determine the day:

I managed that using the code:

 $timestamp = time();
 $day = date("D",$timestamp);
 echo $day;

I can use an IF statement to pick up the day and look at the respective 4 fields but heres what i'm really struggling with:

1. I want to format the times so that they are in the format HH:MM not HH:MM:SS as stored in the mysql database

2. Once I have managed to do that I would like to be able to compare the current time (which I can get using a similar function to the above) to the 4 time values and set another field to "Open" or "Closed" so I can echo it to the screen
I just can't get my head round how to do this as I'm not great with maths and time calculations have just got me totally confused, especially with 4 times to look at each time.

If anyone can help with this I would really appreciate it as I am very new to PHP and MYSQL and am only learning at the moment. I've trawled the web quite a bit to try and work out how to do this and there's so many functions I'm lost!

Thanks

David

[daknightuk]

heres what i've come up with, maybe someone can suggest where it might not work or a better way of coding it?

        	  <?PHP   // this code determines what the current date and time is and compares it to the businesses opening hours (assuming that there is a lunch hour also
			$timestamp = time();
			$currentday = date("D",$timestamp);
			$currenttime=date('H:i');
			$output="OPEN NOW FOR DELIVERY"; // assumes that the business is open unless one of the statements below picks up it is outside opening hours
		
			if ($currentday=="Mon")	
				{
            		if ($row_Find['MONCLOSE1'] != $row_Find['MONOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['MONCLOSE1'] and $currenttime < $row_Find['MONOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['MONCLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['MONOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Monday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
             
			 if ($currentday=="Tue")	
				{
            		if ($row_Find['TUECLOSE1'] != $row_Find['TUEOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['TUECLOSE1'] and $currenttime < $row_Find['TUEOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['TUECLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['TUEOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Tuesday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
			 
			 if ($currentday=="Wed")	
				{
            		if ($row_Find['WEDCLOSE1'] != $row_Find['WEDOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['WEDCLOSE1'] and $currenttime < $row_Find['WEDOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['WEDCLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['WEDOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Wednesday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
			 
			 if ($currentday=="Thu")	
				{
            		if ($row_Find['THURSCLOSE1'] != $row_Find['THURSOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['THURSCLOSE1'] and $currenttime < $row_Find['THURSOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['THURSCLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['THURSOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Thursday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
			 			 
			  if ($currentday=="Fri")	
				{
            		if ($row_Find['FRICLOSE1'] != $row_Find['FRIOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['FRICLOSE1'] and $currenttime < $row_Find['FRIOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['FRICLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['FRIOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Friday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
			 
			 if ($currentday=="Sat")	
				{
            		if ($row_Find['SATCLOSE1'] != $row_Find['SATOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['SATCLOSE1'] and $currenttime < $row_Find['SATOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['SATCLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['SATOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Saturday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}
			 
			  
			 if ($currentday=="Sun")	
				{
            		if ($row_Find['SUNCLOSE1'] != $row_Find['SUNOPEN2'])    		// picks up whether there is actually a lunch break
						{
							if ($currenttime > $row_Find['SUNCLOSE1'] and $currenttime < $row_Find['SUNOPEN2']) $output="LUNCH BREAK"; 
						}
					if ($currenttime > $row_Find['SUNCLOSE2']) $output="PAST FINAL CLOSING TIME"; 
					if ($currenttime < $row_Find['SUNOPEN1']) $output="NOT OPEN YET"; 
									
					echo "The day is Sunday";
					
					echo $output;	 	
					echo " The time is : ";
					echo $currenttime;
				}

[sumeetk]

Hi,

You can use this :

[PHP]$timeval = date('H:i');[/PHP]

This wil produce the time in HH:MM

In the mysql database define the field as "time" data type

Hope this helps

Regards
Sumeet