scheduler

--0016e649c24ed8d7b604743c6d76
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e649c24ed8d7b604743c6d76--

Re: 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: scheduler

--000e0cd20ff464f6ce04743cef5a
Content-Type: text/plain; charset=UTF-8

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 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
>

--000e0cd20ff464f6ce04743cef5a--

Re: scheduler

Scheduled task?

Bastien

Sent from my iPod

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

2009/9/23 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
>

Take a look at http://docs.php.net/manual/en/install.windows.commandline.ph p
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

Re: scheduler

--00163692089b570de704743ea5d3
Content-Type: text/plain; charset=ISO-8859-1

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 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
>
>

--00163692089b570de704743ea5d3--

Re: scheduler

2009/9/23 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, t=
hen
> 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 r=
un
> and the functions are performed even if theres no one to run in the comma=
nd,
> that can be done right?
>
> Vinay Kannan.
>
> On Wed, Sep 23, 2009 at 5:40 PM, Niel Archer 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 everyda=
y,
>> > 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 sa=
id
>> 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.


--=20
-----
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=3DZEND002498&r=3D213474=
731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php