How do I...

[devildog10920]

Make a expricy script for a database.... like i want to make a "detention" script and want the "detention" to expire after a certain amount of hours..... How could I do this.

[$cripts]

cron job

[devildog10920]

[!--quoteo(post=361420:date=Apr 3 2006, 08:50 PM:name=$cripts)--][div class=\'quotetop\']QUOTE($cripts @ Apr 3 2006, 08:50 PM) [snapback]361420[/snapback][/div][div class=\'quotemain\'][!--quotec--]
cron job
[/quote]


Im not very familier with that.

[khendar]

It means setting up a scheduled task on the server which executes a php script which will do the expiry. Only really useful if your server is running Linux and you have access to the server to do this.

The other way is to have a "time_to_expire" field in a database. And each time the webpage is loaded, it checks to see if the time_to_expire is less than the current time. If it is then set a flag in the databse which indicates that it has expired.

[redarrow]

[!--quoteo(post=361421:date=Apr 4 2006, 12:51 AM:name=PHPDesigner)--][div class=\'quotetop\']QUOTE(PHPDesigner @ Apr 4 2006, 12:51 AM) [snapback]361421[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Im not very familier with that.
[/quote]

I thort i throw this in ok.

[code]
$dosomethinkday = '01'; // day of month
$today = date("M d, Y");
$doit = date("M $dosomethinkday, Y");
if ($doit == $today) {IF 2 DATES MATCH LET'S DO SOMETHINk}
[/code]


It will also use the time() format to do somethink ok.