Export mysql results to CSV from PHP website - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

bgjyd834 · 04-26-2011, 09:26 PM

I have written a small (2line) query. I want to create link on my php site which on click will run this script automatically and export results to an excel or csv file. I dont want to create a page to view the results.

Any help to me will be very useful. I am not well conversed with PHP just know a little bit of mysql.

Thanks in advance.

ap2010 · 04-27-2011, 03:59 AM

You can use the PHP fputcsv() function to generate CSV files from array. The array can be created via mysql_query() and mysql_fetch_assoc() functions. If you need more help, let me know.

fernades · 04-27-2011, 06:47 AM

The look and feel is not bad but you can do some more modifications also. And please do change the phpBB banner from the forum area, its not good.