note 90994 deleted from function.strtotime by danbrown
| From: | danbrown@php.net | Date: | Wed, 20 May 2009 13:28:16 +0000 |
| Subject: | note 90994 deleted from function.strtotime by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-155786@lists.php.net to get a copy of this message | ||
Note Submitter: Overyde mojointeractive dot net
----
MySql and PHP start the week on different days. MySQL on Sundays, PHP on Mondays, but a week ahead.
Therefore we need to set Sunday as beginning day of the week to select data from a MySQL database.
<?php
$dayset = mktime(0, 0, 0, 06, 25, 2009);
if (date("w", $dayset)=="0")
{
$weekstart = $dayset;
$date = date("y-m-d", $dayset);
echo "it's sunday already<br>";
}else{
$weekstart = strtotime ("last Sunday", $dayset);
$date = date("y-m-d", $weekstart);
echo "too late...back to sunday<br>";
}
echo "$date<br>";
echo date(W, $weekstart);
?>