[PHP-DB] scheduler
Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay
Re: [PHP-DB] scheduler
Hi, try this: http://cronw.sourceforge.net/ Kamil Walas Vinay Kannan pisze: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] scheduler
If you had been using linux, I would have suggested *cron* for job scheduling. On Windows, there should be something like Task Scheduler for the same. You can write the code for database query and dumping in PHP and then have a batch file containing php yourfile.php scheduled to run using the above. hope that helps. regards, samar On Wed, Sep 23, 2009 at 4:16 PM, Vinay Kannan viny...@gmail.com wrote: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay
Re: [PHP-DB] scheduler
Scheduled task? Bastien Sent from my iPod On Sep 23, 2009, at 6:46 AM, Vinay Kannan viny...@gmail.com wrote: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] scheduler
Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Not only possible but very simple. Just write the php as normal and use Windows' Scheduler to run it with something like: C:\php\php.exe C:\path\to\script.php I have several scripts like this scheduled to do basic maintenance work or carry out automated tasks. Thanks, Vinay -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] scheduler
2009/9/23 Vinay Kannan viny...@gmail.com: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay Take a look at http://docs.php.net/manual/en/install.windows.commandline.php for using PHP from the command line on windows. The command lines you use are the same for the task scheduler. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] scheduler
Thank You Neil ! So if I write in a command like C:\php\php.exe C:\path\to\script.php in a batch file, and have another batch file to run it at given time frames, then the PHP file would make the updates and perform the functionalities that its required to do, is it? coz what I have on my mind is that the tasks are run and the functions are performed even if theres no one to run in the command, that can be done right? Vinay Kannan. On Wed, Sep 23, 2009 at 5:40 PM, Niel Archer n...@chance.now wrote: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Not only possible but very simple. Just write the php as normal and use Windows' Scheduler to run it with something like: C:\php\php.exe C:\path\to\script.php I have several scripts like this scheduled to do basic maintenance work or carry out automated tasks. Thanks, Vinay -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] scheduler
2009/9/23 Vinay Kannan viny...@gmail.com: Thank You Neil ! So if I write in a command like C:\php\php.exe C:\path\to\script.php in a batch file, and have another batch file to run it at given time frames, then the PHP file would make the updates and perform the functionalities that its required to do, is it? coz what I have on my mind is that the tasks are run and the functions are performed even if theres no one to run in the command, that can be done right? Vinay Kannan. On Wed, Sep 23, 2009 at 5:40 PM, Niel Archer n...@chance.now wrote: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Not only possible but very simple. Just write the php as normal and use Windows' Scheduler to run it with something like: C:\php\php.exe C:\path\to\script.php I have several scripts like this scheduled to do basic maintenance work or carry out automated tasks. Thanks, Vinay -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Save yourself the batch files. Just use ... C:\php\php.exe -f C:\path\to\script.php -- as the command. The -f is for completeness. If you want to pass parameters to your script, put them after the -- e.g. C:\php\php.exe -f C:\path\to\script.php -- --scriptparam1 --scriptparam2 The task scheduler is a windows service. It runs even if you are not logged on. Richard. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php