CSV File 1

[jestrada101]

Is there a way to create a CSV file using PHP and pulling the data from MySQL? Any ideas that could guide me?

Thanks!
JE

 

[Borvik]

Yes there is a way to do this.

We currently do it from a MSSQL table so a MySQL table shouldn't be much different.

First you want to make sure the proper header goes out:

Header("Content-type: text");
Header("Content-Disposition: attachment; filename=invoice.nonedi.zzprecdata");

Then as your going through your records, just output them like you would to the screen.

echo "$Field1,$Field2,$Filed3,$Fieldn\n";

And when your php finally finishes executing your download is complete.

Hope that helps.

 

[jestrada101]

Perfect!!! Thanks!

JE