convert mysql data to excel file

[fariba123]

i have developed a ip management website. there are options to view reports. is there any way to convert the reports in excel file by clicking a link/image.

thank you,
fariba

[ronverdonk]

You can write your own MySQL extraction code and convert the results to a CSV, which you can import into Excel.

You can also use a pre-made FREE class at www.phpclasses.org, link for this to MySQL to Excel

This class is used for exporting the data from a MySql to spreadsheet files in the Excel format.

The class executes a given database query and extract the result set data to generate the Excel spreadsheet.

The generated Excel spreadsheet can be stored in a given file or be made available immediately for download.

Ronald :cool: