Re: PHP 24 hour processes?

From:	Nathan Rixham	Date:	Mon, 25 Feb 2008 16:50:46 +0000
Subject:	Re: PHP 24 hour processes?
References:	1 2 3	Groups:	php.general
Request:	Send a blank email to php-general+get-270066@lists.php.net to get a copy of this message

Nathan Rixham wrote:

Daniel Brown wrote:
On Mon, Feb 25, 2008 at 1:39 AM, Zoran Bogdanov <test1.test1@hi.t-com.hr> wrote:
Hi, How can you perform a timed event in PHP; for example: Count 24 hours and then delete all rows in a database...
    Once again, I say verily unto you: RTFM and STFW.
    Linux/*nix:  cron
    Windows:   at
Cron Example: 40 03 * * * which php /path/to/php/script.php PHP: <? include('configure.php'); // With database connection stuff, et cetera. $sql = "TRUNCATE TABLE table_name"; mysql_query($sql); ?>
of negate php all together and use cron to schedule: mysql -h hostname -u username -ppassword -e "TRUNCATE TABLE table_name"

clean forgot, if your on mysql 5.1.6> then you can use the "create event" syntax http://dev.mysql.com/tech-resources/articles/event-feature.html no need for cron or php and platform independant :)