scheduler

[Vinay Kannan]

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

[Kamil Walas]

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

[Samar Hedaoo]

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 <vinykan@...> 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
>

[Phpster]

Scheduled task?

Bastien

Sent from my iPod

On Sep 23, 2009, at 6:46 AM, Vinay Kannan <vinykan@...> 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

[Niel Archer-4]

> 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

[Richard Quadling]

2009/9/23 Vinay Kannan <vinykan@...>:

> 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=ZEND002498&r=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

[Vinay Kannan]

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 <not@...> 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
>
>

[Richard Quadling]

2009/9/23 Vinay Kannan <vinykan@...>:

> 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 <not@...> 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=ZEND002498&r=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