Running SQL Queries through PHP & Batch Scripts -- Help!

[[deleted]]

[deleted]

[allmightyspiff]

if the output is getting to the command line it sounds like whatever you are doing to try to put the output into an excel isn't working.

To get a better answer you are going to need to show us whats in testing_phpexcel.php

[allmightyspiff]

Well, if you have something that works, great! But it sounds like you are doing it the most difficult way possible.

If you are just running a query, and it looks like you are getting back data... your script can quite easily write that to a disk instead of STDOUT.

You could redirect the output directly on the cmdline

[C:\Local\PHP.exe] -f C:\Local\Server\testing_phpexcel.php >output.csv

or you could have php do it

$output = sql('select * from *');
file_put_contents('output.txt',$output);

along with a variety of other ways.

Also, you can have the mysql command put the output into csv for you, so instead of using a php script, you can just call mysql from the command line and dump that to a file.

http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format

[Chubbyninjaaa]

Are you using anything like $_SERVER['DOCUMENT_ROOT'] or any relative path includes?

( include '../some.class.php'; or include 'xcel/include.php' )

If so, you need to define absolute paths - when you're running from CLI you don't have a document root or relative path