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]
