[RESOLVED] real-time "time" problem

cbesh2

I am new to PHP and am trying to create a script that tells if our office is currently open or closed. I'd like to be able to search my database to see if there is an entry for the current date (not every day will have an entry). For example, for New Year's Eve, I want to create an entry by using the numerial format of the day of the year (i.e., 365) and also give the name of the reason we're going to be closed ("New Year's Eve"). But when I upload my script, it doesn't work. Anybody know what I'm doing wrong? I think it has something to do with my if/then statements.

doty is the numerical value of the day of the year in the database.
reason is the reason we're close in the database.

Example:

doty = 365
reason = New Years Eve

Here's the code:

<!-- This script shows real-time postings whether the office is open or closed.  -->

<?php
//connect to the database -- CONVERT THIS TO A FILE //
$connect = mysql_connect("localhost", "username", "password") or
die ("Could not connect to server.  Please check connection.");
mysql_select_db ("database");
?>

<html>
<head>
<title> </title>
</head>

<body>

<?php
//caluculate current time from GMT time by unix timestamp
$hour=gmdate('H');              // hour
$min=gmdate('i');               // minutes
$sec=gmdate('s');               // seconds
$day=gmdate('w');               // numeric representation of the day of week (0=Sunday through 6=Saturday)
$month=gmdate('n');             // numeric representative of the month
$date=gmdate('d');              // double digit format of date
$year=gmdate('Y');              // four digit format of year
$dayoftheyear=gmdate('z');      // numeric representation of day of the year (0-365)
$conversion = ($hour*60)+$min;  // converts time to minutes

$query = "SELECT * FROM holidays WHERE doty=$dayoftheyear";
$results = mysql_query($query)
or die(mysql_error());

while ($row = mysql_fetch_array($results)) {
extract ($row);

echo "Our office is currently "; 

   if ($doty = $dayoftheyear)          //$doty is numerical value of holiday in database
	  {
	  echo "closed for ",$reason,".";   //example:  New Year's Eve = 365
	  }
   else
      if ($day==0)           // day of the week conditions 
   	     {
		 echo "closed.";   

		 }
	  else
	     if ($day==6)
            {
			echo "closed.";   

			}
		 else
            if ($conversion>=0 && $conversion<=779) //converted time: closed 12:00AM - 7:59AM
	           {
			   echo "closed.";
			   }
			else
			   if ($conversion>=780 && $conversion<=1290) //converted time: open 8:00AM - 4:30PM
	              {
				  echo "open.";
				  }
			   else
			      if($conversion>=1291 && $conversion<=1440) //converted time: closed 4:31PM - 11:59PM(12:00AM)
	                 {
					 echo "closed.";
					 }
   }  

// testing variables //
echo "doty: ",$doty,"<br>";
echo "dayoftheyear: ",$dayoftheyear,"<br>";
echo "conversion: ",$conversion,"<br>";
echo "day: ",$day,"<br>";

?>

</body>
</html>

coreyp_1

I trimmed it down a bit, but was unable to test it. Let me know if it works!

 <!-- This script shows real-time postings whether the office is open or closed.  -->

<?php
//connect to the database -- CONVERT THIS TO A FILE //
$connect = mysql_connect("localhost", "username", "password") or
die ("Could not connect to server.  Please check connection.");
mysql_select_db ("database");
?>

<html>
<head>
<title> </title>
</head>

<body>

<?php
//caluculate current time from GMT time by unix timestamp
list($hour, $min, $sec, $day, $month, $date, $year, $dayoftheyear) = explode(',', gmdate('H,i,s,w,n,d,Y,z'));

$conversion = ($hour*60)+$min;  // converts time to minutes

$query = "SELECT * FROM holidays WHERE doty=$dayoftheyear LIMIT 1";
$results = mysql_query($query)
or die(mysql_error());

echo "Our office is currently ";

if ($row = mysql_fetch_array($results)) {
  extract ($row);
  echo "closed for ".$reason.".";                  //example:  New Year's Eve = 365
} elseif ($day==0 || $day == 6) {                  // day of the week conditions
  echo "closed for the weekend.";
} elseif ($conversion<=779 || $conversion>=1291) { //converted time: closed 12:00AM - 7:59AM & 4:31PM - 11:59PM
  echo "closed for the day.";
} else {                                           //converted time: open 8:00AM - 4:30PM
  echo "open.";
}

// testing variables //
echo "doty: ",$doty,"<br>";
echo "dayoftheyear: ",$dayoftheyear,"<br>";
echo "conversion: ",$conversion,"<br>";
echo "day: ",$day,"<br>";

?>

</body>
</html>

cbesh2

Thanks, Corey. It works! That's exactly what I wanted it to do. Thanks again.

Christopher