RE: [PHP] beginnind and end of the week
| From: | Tim Owens | Date: | Mon, 01 Nov 2004 21:33:56 +0000 |
| Subject: | RE: [PHP] beginnind and end of the week | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200867@lists.php.net to get a copy of this message | ||
>-----Original Message-----
>From: Curt Zirzow [mailto:php-general@zirzow.dyndns.org]
>Sent: Monday, 1 November 2004 3:46 p.m.
>To: php-general@lists.php.net
>Subject: Re: [PHP] beginnind and end of the week
>
>* Thus wrote Jerry Swanson:
>> I need to run a query using PHP/MYSQL. The query should be for a week.
>> So if today is tuesday, the query should be from Monday to Sunday.
>> How in in php I can know when the beginning and end of the week?
>>
> <?php
> // in case the date unlikley changes
> $t = time();
>
> // this weeks monday
> $m = strtotime('this monday', $t);
>
> // next weeks monday minus 1 second
> $s = strtotime('next monday', $t) - 1;
>
> echo date('r', $m), "\n";
> echo date('r', $s), "\n"
>
>?>
>
>Now $m and $s contain the proper timestamps.
>
>Curt
Hmm. Could you simply use the SQL
"WHERE WEEK(dateinrecord) = WEEK(dateinquestion)"? Or maybe use YEARWEEK to
make sure you match the year too?
Saves re-inventing the wheel...
Tim