Re: exec output to mySQL, How?

On Wed, Jul 21, 2010 at 12:39 PM, Tom Sparks <tom_a_sparks@yahoo.com.au> wrote: > --- 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 > > > > You want to calculate how much time the query takes? -- Regards, Nilesh Govindarajan Facebook: http://www.facebook.com/nilesh.gr Twitter: http://twitter.com/nileshgr Website: http://www.itech7.com