Exporting a database report.

Anon

I have a mySQL query run against a DB using PHP that returns a spiff web based report for some of my clients. (the whole process available because of the tremendous help you guys have given me in the past, I might add)

In their infinite wisdom, this doesn't seem to be good enough, and they want particular reports able to be imported into an Excel spreadsheet. To do this, of course, I'd just need to generate a .csv file with all the data returned.

My question I pose to you is this:

Is there a way that not only can the report be web based, but behind the scenes it somehow prints the data to a csv file that they can later download?

Any and all help is once again greatly appreciated.

Anon

The mySql command SELECT...Into...Outfile will create a file on the server. Run this query after you make the web page report. You can format the file using export options and get the 'look and feel' that you need for CSV. See section 7.19 of the MySql documentation.

Anon

I actually got this solved by doing the following:

$sql = "select yadda, yadda2, yadda3, UNIX_TIMESTAMP(date) AS date FROM table";

// execute SQL query and get result

$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

if (!$sql_result) {  

	echo "<P>Couldn't get item!";

} else {

$csv = fopen("/path/to/file.csv", "w");
while($row = mysql_fetch_array($sql_result))
{
$yadda = $row["yadda"];
$yadda2 = $row["yadda2"];
$yadda3 = $row["yadda3"];
$date_st = date("m/d/Y",$row["date"]);
if($date_st == "12/31/1969") $date_st = "N/A";

fwrite($csv,"$yadda,$yadda2,$yadda3,$date_st\r\n");
}
fclose($csv);

Now granted, this was with the help of other folks on the boards (coding help), but it got the job done. After I wrote the data out to a file, I used the class file someone wrote to allow the mailing of attachments.

I hope this helps some folks on the board with similar problems.

I can't begin to tell you how much help everyone has been. If it weren't for the folks around here, I'd be one lost homie.

Thanx!