dates,

[newbieiguess]

Am doing for myself some code to remind me via email of birthdays (dont want spam so am coding it myself) this how far i got:

I did a control panel putting the data (name, birthday, etc), and it tells me THE SAME DAY that the date is due like this:

 $datenow=date("Y-m-d");
 $sql = mysql_query ("select * from data WHERE date = '$datenow'");
 ...

I want to be able to send me an email 7 days before, how could this be done?

I have a cron job running the script every day.

Thanks.

[TheDefender]

Take a look at the [man]strtotime[/man] function in the manual to do it in PHP.

Also, you can use the built in DATE and TIME functions in the MySQL manual to accomplish this. Depends on what route you want to take.

[programmer79]

You can assign a value for the year, month, day.
ex.

$day = date("d");
$month = date("m");
$year = date("Y");

You will then need to perform some checks to account for the first month in the year, the beginning of the month and adjust the 7 days prior accordingly. By now you should have your date which is 7 days before the current date. Assign these values back to the $day, $month, and $year. Now perform your query. If you have the column in the DB setup as a date format you can use the following query.

$query = "Select * from dates_to_remember";
$result = mysql_query($query) or die(mysql_error() . " error querying database");
while($row = mysql_fetch_array($result)){
	if ($row['date'] == $year . "-" . $month . "-" . $day )[
	  echo "Today is the date.  Send and email, call or forget about it.";
               }
}

[newbieiguess]

Actually the code i posted works the same telling me THE SAME DAY of the event, i wanted to be told, like for example, 7 DAYS BEFORE,

Thanks.

[tekky]

newbieiguess wrote:

Actually the code i posted works the same telling me THE SAME DAY of the event, i wanted to be told, like for example, 7 DAYS BEFORE,

Thanks.

if you are using a MYSQL DATE field...

SELECT something FROM tbl_name WHERE DATE_ADD(CURDATE(),INTERVAL 1 WEEK) = date_col;

[maxpup979]

or, if you want to do it in the code for some strange reason (doing it in the SQL always seemed better to me), then you can use:

$nextweek = date("m-d-y",mktime(0, 0, 0, date("m") , date("d")+7, date("Y")));

[wilku]

Or, as it was mentioned above, use strtotime which allows you to forget about the beginning of a month, a year and phases of the moon 😉

$datenow=date("Y-m-d",strtotime('now +1 week'));
$sql = mysql_query ("select * from data WHERE date = '$datenow'"); 

[tekky]

wilku wrote:

Or, as it was mentioned above, use strtotime which allows you to forget about the beginning of a month, a year and phases of the moon 😉

$datenow=date("Y-m-d",strtotime('now +1 week'));
$sql = mysql_query ("select * from data WHERE date = '$datenow'"); 

that's identical to what I did with the mysql query and it to doesn't care about end of months, years, leap years, leap seconds or anything else you can think of, and its more efficient since the php parser doesnt have to deal with it 😉