RE: [PHP] How do I import tables into MySQL from web page ...

using dan's test below if u add a '/s' like so $output = system('dir /s c:\books', $return_var); you will get all contents os subdir's as well.... how ever i suggest working on a format as this tree's out along the page so maybe if u add a '/w' after the '/s'as well that will sort of solve that problem .. though does create one massive block of filenames in ur browser... Cheers > -----Original Message----- > From: Fargo Lee [mailto:fargolee@iname.com] > Sent: Thursday, 11 July 2002 11:54 AM > To: php-general@lists.php.net > Subject: Re: [PHP] How do I import tables into MySQL from web page ... > > > I ran a few tests as well and the few system commands I tried > only saved the > *last* line of the output in a variable on success as the manual > suggests it > should - better than nothing - but not the entire output as you seem to > suggest you were able to do and what I have been trying to do. > > "Analysis & Solutions" <danielc@analysisandsolutions.com> wrote in message > news:20020710233342.GB22872@panix.com... > > On Wed, Jul 10, 2002 at 12:14:58PM -0700, Fargo Lee wrote: > > > > > > This suggests, as do a few posts I just noticed in the manual, that > > > one cannot assign the output of system() and perhaps passthru() and > exec() > > > to a variable. > > > > I forgot to mention, that's not accurate. I just ran a test to > make sure. > > Got the results just fine. > > > > Just for clarity, here's my test (PHP 4.2.1, NT 4.0): > > > > # real directory. > > # result: output shows file list, false no, return 0 > > # $output = system('dir c:\books', $return_var); > > > > # fake directory. > > # result: output shows nothing, false yes, return 1 > > $output = system('dir y:\fake', $return_var); > > > > echo "output: $output"; > > echo '<hr />'; > > echo 'output false? ' . ( ($output == FALSE) ? 'yes' : > > 'no' ); > > echo '<hr />'; > > echo "return: $return_var"; > > > > > > --Dan > > > > > > I think this is only possible using backticks, which I can't > > > use as this needs to be run in safe mode. So I guess I just > need to use > the > > > return_var as you suggested. Thanks! > > > > > > "Analysis & Solutions" <danielc@analysisandsolutions.com> wrote > > > in > message > > > news:20020710070725.GA20614@panix.com... > > > > On Tue, Jul 09, 2002 at 11:41:47PM -0700, Fargo Lee wrote: > > > > > > > > > got it to assign a 0 (success) or 1 (failure) to the return_var > argument > > > as > > > > > you suggested so I am happy. > > > > > > > > Good! > > > > > > > > > > > > > What mixed me up and I still don't understand is the manual entry > for > > > > > system() says ... > > > > > > > > > > "Returns the last line of the command output on success, and FALSE > on > > > > > failure." > > > > > > > > > > When it says it "Returns", where does it return this > information and > how > > > can > > > > > it be captured for comparison? > > > > > > > > The thing that's tripping you up is, I believe, executing MySQL > programs > > > > at a prompt doesn't produce any visible output. But, if > you executed > a > > > > command that returns some output to STDOUT, like "ls", you'd see > > > > the > last > > > > line of output therefrom in the "Return." > > > > > > > > --Dan > > > > > > > > -- > > > > PHP classes that make web design easier > > > > SQL Solution | Layout Solution | Form Solution > > > > sqlsolution.info | layoutsolution.info | formsolution.info > > > > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > > > > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > > PHP classes that make web design easier > > SQL Solution | Layout Solution | Form Solution > > sqlsolution.info | layoutsolution.info | formsolution.info > > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >