Re: [PHP] Selecting all records between a date range
- From: eric.butera@xxxxxxxxx ("Eric Butera")
- Date: Wed, 8 Oct 2008 10:56:58 -0400
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <japruim@xxxxxxxxxx> wrote:
Hi Everyone,
I am working on a app where I need to be able to select all the values from
a database where the 'timein' field is between a certain date range...
Essentially the last 7 days...
here is the code that I am working with:
$rangeBegin = strtotime("Last week thursday midnight");
$rangeEnd = strtotime("Today now");
$SQLTEST = "SELECT * FROM `timeStore` WHERE `timein` BETWEEN
{$rangeBegin} AND {$rangeEnd}";
echo "SQLTEST: " . $SQLTEST . "<br>";
SQLTEST: SELECT * FROM `timeStore` WHERE `timein` BETWEEN
1222315200 AND 1222920000
Could not perform query: Query was empty
All of my times are stored as unix timestamps in the database, such as:
+------------------------------------------+
| timein | timeout | empID | record |
+------------+------------+-------+--------+
| 1222354037 | 1222382837 | 1 | 107 |
| 1222440437 | 1222469237 | 1 | 108 |
| 1222526837 | 1222555637 | 1 | 109 |
| 1222613237 | 1222642037 | 1 | 110 |
| 1222699637 | 1222728437 | 1 | 111 |
| 1222359217 | 1222359220 | 2 | 115 |
| 1222359214 | 1222359220 | 2 | 114 |
| 1222359219 | 1222359220 | 2 | 116 |
| 1222359231 | 1222359566 | 2 | 117 |
+------------------------------------------+
Anyone has any ideas? Or maybe a better way? :)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
You can do this:
$startTS = time() or mktime for today at midnight
strtotime("-1 week", $startTs)
and make your query use these params.
.
- References:
- Selecting all records between a date range
- From: Jason Pruim
- Selecting all records between a date range
- Prev by Date: Re: [PHP] Selecting all records between a date range
- Next by Date: Re: [PHP] Login
- Previous by thread: Re: [PHP] Selecting all records between a date range
- Next by thread: Events Calendar that read text file for events
- Index(es):
Relevant Pages
|
