Re: exec output to mySQL, How?
| From: | Tom Sparks | Date: | Wed, 21 Jul 2010 07:09:55 +0000 |
| Subject: | Re: exec output to mySQL, How? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-307055@lists.php.net to get a copy of this message | ||
--- On Wed, 21/7/10, Nilesh Govindarajan <lists@itech7.com> wrote:
> On Wed, Jul 21, 2010 at 8:49 AM, Tom
> Sparks <tom_a_sparks@yahoo.com.au>
> wrote:
> > How do I take the output from a command line program
> and update a MYSQL database with it?
> >
> > tom_a_sparks
> > Light travels faster then sound, which is why some
> people appear bright, until you hear them speak
> >
>
> $cmdop=shell_exec('cmd');
> $con=new mysqli(...);
> // Check connection error
> // Refer to php.net/mysqli
> $con->multi_query($cmdop);
ok, thanks the program I am using reports a estimated time to completion, I understand I need a
loop, but I cant work out how I would do this
run program
while program is running {
sleep 60 seconds
update mySQL with ET from program
}
tom