Date check database output.

[Anon]

Hello Everyone,
I'am a new to coding PHP but, have enjoy its great features. I have a simple classified ad section I'am working on and I would like to have the ad expire after 30 days in this case. As users add more listings, it can maintain itself by not displaying any ads over 30 days old. I thought this could be done by looking at the time/date stamp that each ad has when posted and then looking at the present date and calculating. If 30 days has passed, then skip don't display this ad (its expired) and go to the next one within the loop.

I have looked within my basic manual and it doesn't cover this very well, hope someone has had this challenge before and can share the code with me.

Thank you again.

John

[Anon]

What database are you using? The solution should most
likely be to write the query in such a way that rows
containing expired ads aren't even returned, e.g.

  select * from ads where expires >= now()

for postgreSQL, or

  select * from ads where expires >= cur_date()

for MySql

[Anon]

i think the easiest way to do it is with unix timestamp..
if you are storing the date in another format, use the mktime function (more information php.net/mktime) to transform in unix timestamp:

$classified_date = mktime(h,m,s,M,D,Y);
$now = time();
$expire_time = 30 24 60 * 60; // (days,hours,...)
// course you can use directly the number of seconds passed in 30 days: 2592000
if ($classified_date > $now - $expire_time) {
// show it.. it isn't expirated.
}

i hope it's rigth, bcause i hadn't test it.. 🙂
ic