note 33715 added to function.jddayofweek
| From: | ben at rack1 dot php dot net | 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