[PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically
You can set up the task manager to run a php script from the command line: php -q script.php log.txt The '-q' switch suppresses the HTTP header output, so if you scheduled the script to run with the output redirected to a file, then all echoes etc. in the script would be redirected to the log and you won't have to mess with the web header stuff. Oh, and make sure that the PHP subdirectory is included in the PATH. You can set this manually for testing by: path=%path%;C:\PHP Best regards, Jeremy Reed George Loch [EMAIL PROTECTED] wrote in message 001101c189a9$8eaa7a60$[EMAIL PROTECTED]">news:001101c189a9$8eaa7a60$[EMAIL PROTECTED]... What if you are on win2K? - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 12:22 PM Subject: [mysql-support] RE: [PHP-DB] Run php page automatically I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Run php page automatically
it's better to do something like 0,10,20,30,40,50 * * * * /usr/bin/php -q /home/you/yourscript.php /dev/null or even */10 * * * * /home/you/yourscript.php /dev/null with the first line of you php script being #!/path/to/php -q -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Run php page automatically
I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Run php page automatically
do this (crontab file) 35 23 * * * root lynx http://www.host.com/dir/file.php -accept_all_cookies it's work! marco -Mensaje original- De: Harpreet [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 02:21 p.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RE: [mysql-support] RE: [PHP-DB] Run php page automatically
In my opinion, PHP works fine with small scripts like this. True, it could
be more efficient with Perl, but when you don't know Perl, or don't have DB
perl modules installed, PHP scriptlets are a nice way to take care of small
tasks. And PHP can just as easily run a system command and append text to a
log file:
system('echo A new message MyLogFile');
I used to think that PHP was only for the purpose of viewing through web
pages, but I've since found that it really can make a handy system tool
sometimes when Perl is a hassle.
- Jonathan
-Original Message-
From: NiteHaqr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 1:53 PM
To: Jonathan Hilgeman; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [mysql-support] RE: [PHP-DB] Run php page automatically
I would probably recommend AGAINST running this php script from cron.
I have a similar script but I use a PERL version for auto-updates.
PHP should only (IMHO) be used where someone will see some output on a
webpage.
Other advantage of using PERL is that you could easily create a log file by
redirecting the output (or PRINT statements) to a file using simple
redirection ( and ) instead of having to actually manipulate the file.
Just my tuppenceworth.
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Jonathan Hilgeman
Sent: 20 December 2001 19:22
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [mysql-support] RE: [PHP-DB] Run php page automatically
I usually just create a cron job for this. Create your PHP script that will
delete the matching records once. Then go into cron and have it run every 10
minutes.
- Jonathan
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 11:21 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Run php page automatically
I would like to create a php page that would automatically run every 10
minutes or so to delete records from a table. This table has an expiration
field and records r tested by comparing current date with the expiration
date and record is deleted if expired.
Is this possible.
Help is greatly appreciated.
I am using php for my application. I am working on a LInux server and using
mysql as my database.
regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
___
To unsubscribe yourself from this list please go to
http://www.mysql.org/mailman/listinfo/support and read the unsubscription
information.
support mailing list
[EMAIL PROTECTED]
http://www.mysql.org/mailman/listinfo/support
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically
What if you are on win2K? - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 12:22 PM Subject: [mysql-support] RE: [PHP-DB] Run php page automatically I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically
task manager -Mensaje original- De: George Loch [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 05:56 PM Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically What if you are on win2K? - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 12:22 PM Subject: [mysql-support] RE: [PHP-DB] Run php page automatically I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Run php page automatically I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly appreciated. I am using php for my application. I am working on a LInux server and using mysql as my database. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Run php page automatically
it's better to do something like 0,10,20,30,40,50* * * * /usr/bin/php -q /home/you/yourscript.php /dev/null since crontab actually stores the result of it's operations in a file (/home/you/Mailbox?) so you will bloat your server if you don't clear the output. alternatively, use yourscript.php /home/you/logfile and send the output to a text-based logfile for later analysis, then just make sure you aren't using b and stuff in the log :) HTH /beau // -Original Message- // From: Marco Eyzaguirre [mailto:[EMAIL PROTECTED]] // Sent: Friday, 21 December 2001 3:28 AM // To: [EMAIL PROTECTED] // Subject: RE: [PHP-DB] Run php page automatically // Importance: High // // // do this (crontab file) // // 35 23 * * * root lynx http://www.host.com/dir/file.php // -accept_all_cookies // // it's work! // marco // // -Mensaje original- // De: Harpreet [mailto:[EMAIL PROTECTED]] // Enviado el: Jueves, 20 de Diciembre de 2001 02:21 p.m. // Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] // Asunto: [PHP-DB] Run php page automatically // // // I would like to create a php page that would automatically // run every 10 // minutes or so to delete records from a table. This table has // an expiration // field and records r tested by comparing current date with // the expiration // date and record is deleted if expired. // // Is this possible. // // Help is greatly appreciated. // // I am using php for my application. I am working on a LInux // server and using // mysql as my database. // // regards, // Harpreet Kaur // Software Developer // Crispin Corporations Inc. // // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
