[RESOLVED] Compare dates?

zzz

I have a search where a user can specify the search date range byt setting: From Month + Year and To Month + Year

I'd like to have some sort of logic in place to display error if they specify overlapped dates, like:

From June 2005 to May 2005

From June 2006 to July 2005

Here's how use the date range in my db search query:

SELECT *
FROM mytable
WHERE MONTH(event_date) >= ".$FROMmonth."
AND YEAR(event_date) >= ".$FROMyear."
AND MONTH(event_date) <= ".$TOmonth."
AND YEAR(event_date) <= ".$TOyear."

🆒

blanius

you could use gregoriantojd() to convert to Julian then do the usual math checks.

http://www.php.net/manual/en/function.gregoriantojd.php

Installer

Or something like this:

$from_ts = strtotime('01 ' . $FROMmonth . ' ' . $FROMyear);
$to_ts =  strtotime('01 ' . $TOmonth . ' ' . $TOyear);

if $from_ts >= $to_ts) {
    die('Invalid data.');
}

$query = "SELECT * FROM mytable WHERE event_date 
          BETWEEN FROM_UNIXTIME(" . $from_ts . ") AND FROM_UNIXTIME(" . $to_ts . ")";

Edit: Simpler query:

$query = "SELECT * FROM mytable WHERE UNIX_TIMESTAMP(event_date) 
          BETWEEN " . $from_ts . " AND " . $to_ts;

zzz

The event date is recorded in the db in the following format 0000-00-00 and is a "date" type.

Installer

That's what I assumed.

zzz

Ohh.. Great! Lemme give it a wrirl!

zzz

OK, I'm having problems with strtotime.

The values that I get from my variable are in the following format:

$FROMmonth = 8
$FROMyear = 2006

Do I need to first convert it with the date function to different format?

zzz

Well, it is possible that I overcomplicated this again but it seem to be working. I ended up tweaking the strtotime by using my months array and came up with something like this:

$from_ts = strtotime($months[$_POST['moFrom']]." ".$_POST['yrFrom']);
$to_ts   = strtotime($months[$_POST['moTo']]." ".$_POST['yrTo']);