note 33715 deleted from function.jddayofweek by alindeman
| From: | alindeman@php.net | Date: | Fri, 04 Jul 2003 18:48:57 +0000 |
| Subject: | note 33715 deleted from function.jddayofweek by alindeman | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-51532@lists.php.net to get a copy of this message | ||
Note Submitter: ben AT idezyne dot com
----
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