Checking between a range of 2 dates

[jacko_162]

i have the below code which i wrote this monring, for some reason when i assign $date to fetch data from my database i just get the echo of "You had an Error" yet if i manually assign $date as the following it works:

 

$date = strtotime("2011-09-20");

 

i have it set exactly the same in the database cus if i echo $date

 

i get:

2011-09-20

 

whats going on? date in php is a cruel function to play around with..

 

here is my code:

<?php
// Query the DB to fetch all data where member_id matches that set in session
$reminder = mysql_query("SELECT * FROM `reminders` WHERE member_id=$_SESSION[sESS_MEMBER_ID]") or die(mysql_error());
//While Loop the results
while($fetch = mysql_fetch_array( $reminder )) { 
// Start date (TODAY!)
$s_date = strtotime("now"); 
// End Date (+7 days from today)
$e_date = strtotime("+1 week"); 
// Fetches Date stamp from "reminderDate" row in DB
$date = $fetch['reminderDate']; 

// Checks if the date is between 2 ranges set above
if($date > $s_date && $date < $e_date) 

//Echo The Results
{
    echo "<div class='notification error png_bg'><a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a><div>Custom Error Notification BOX!</div></div>";
}
else
{
    echo "You had an Error";
//echo $date; // TEST that date outputs datestamp "2011-09-02"
}
//END LOOP
}
?>

[AyKay47]

strtotime() returns an int timestamp... while your db field is in string format.. you will need to convert the fetched data into an int

[jacko_162]

my database row is stored as "DATE" i didnt think that was a string?

[AyKay47]

anything retrieved from a database will be in string format..

will need to be an int

[jacko_162]

ok where do i need to look in the manual on changing the variable to an int.. i only found something on idate()

[AyKay47]

you can also use mktime to make the future timestamp.. use that timestamp with the date function to get your date as a string.. you can also use date to get your current date as a string and compare them to your db table data..

[PFMaBiSmAd]

Since you have a DATE data type, why don't you just write a query to match the rows that you want? Mysql has a couple dozen date functions that make using dates easy.

[AyKay47]

Since you have a DATE data type, why don't you just write a query to match the rows that you want? Mysql has a couple dozen date functions that make using dates easy.

as PFM suggested, perhaps a mysql solution here would be much easier..

refer here for a reference of mysql's date/time functions

[jacko_162]

so i can specify in the mysql query by using "WHERE" date is between todays date and +7 days?

[PFMaBiSmAd]

SELECT * FROM `reminders`
WHERE member_id={$_SESSION['SESS_MEMBER_ID']} AND
reminderDate BETWEEN CURDATE() AND CURDATE() + INTERVAL 7 DAY

[jacko_162]

i see what you did there 

 

indeed much easier way to limit results using the query.

 

marked as solved. thanks guys.