Entry disappearing after a specific time

[cordoprod]

Hello!

 

I'm using a flat file db.

 

I want to delete an entry in the db after 3 months from the date I posted it.

 

I just don't know much about the time and date functions in PHP.

 

Any ideas?

[uniflare]

explaining something like this is quite complicated.... why cant you use mysql instead?

 

----

anyway im guessing you know how to find,edit and delete entries from your flat file, so you want to know how to compare a date to check how old it is?

 

first off, save a date_added field with a time(); unix timestamp. check this field like so:

 

if(time() >= ($db_date_added + 2592000)){
  // delete entry
}

 

this will delete the record after 30 days.

 

--------

also see http://www.php.net/date for more information on the php's date functionality

 

 

hope this helps,

[cordoprod]

Thank you very much! 

[cordoprod]

What format of the date() function should I use when I post the entry?

[uniflare]

do you mean when you read it?

 

have a look at php.net/date and choose, i usually go for : date("jS F y");

 

if saving to a db you should ALWAYS use time(); as a unix timestamp, you can use date("jS F y",time()); to format timestamps.

hope this helps,

[cordoprod]

When saving to a DB.

So $date should be date("jS F y",time());  ?

[uniflare]

when saving to a db $date = time();  when puling from a db use date("jS F y",$date);

[cordoprod]

Ok thanks