note 33715 added to function.jddayofweek

From: Date: Fri, 04 Jul 2003 18:41:08 +0000
Subject: note 33715 added to function.jddayofweek
Groups: php.notes 
Request: Send a blank email to php-notes+get-51531@lists.php.net to get a copy of this message
I used this on output from an array and it worked fine for me (php 4.3.2). I was processing a log file that was split and inserted into a MySQL DB. This is what I wrote to extract, count, and total website hits. (Thesis Project) $query = "SELECT dateDay FROM stats"; $mysql_result = mysql_query($query); $Sun = 0; $Mon = 0; $Tue = 0; $Wed = 0; // initialize buckets to 0 $Thu = 0; $Fri = 0; $Sat = 0; while($row = mysql_fetch_array($mysql_result)){ $dayFallsOn = jddayofweek($row[0], 2); switch($dayFallsOn){ case "Sun" : $Sun = $Sun + 1; break; case "Mon" : $Mon = $Mon + 1; break; case "Tue" : $Tue = $Tue + 1; break; case "Wed" : $Wed = $Wed + 1; break; case "Thu" : $Thu = $Thu + 1; break; case "Fri" : $Fri = $Fri + 1; break; case "Sat" : $Sat = $Sat + 1; break; default : break; } //switch } //end while * not proven to be leap year compatible, more testing needed ---- Manual Page -- http://www.php.net/manual/en/function.jddayofweek.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+33715 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+33715&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+33715&report=yes

« previous php.notes (#51531) next »