PHP export tool for xls, csv and xml

Hello,
I'm searching about an extension/script that allow me to export recordset from database in xls (excel), csv and xml.
DataBridge offers this functionality (or as a separate extension)?

In attachment an example from an old extension used several years ago (not more compatible with MySQLi).

Thanks.

You could use MySQLi Server Behaviors to create a comma separated repeated region for your data. Then just add the necessary headers to have the file downloaded and saved as a CSV like:

header('Content-Type: application/octet-stream');

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=yourfileneame.csv');

Ok thanks!

Hi Ray

Do you have a sample file available that I could use as a starting point?

Many thanks

Chris

I don't, but it should be very simple to do.

Give it a try and upload a copy of your page if you get stuck and I can try to help.

Thanks, Ray - will do.

This post has been deleted.

This post has been deleted.

Hi Ray

Done it!

(I've deleted previous posts with non-working solutions)

The only thing I haven't managed is to get the fm_title from the recordset as the name of the csv file.

Latest code in the private message.

Cheers

Chris

The name of the CSV is set on this line:
header('Content-Disposition: attachment; filename=myform.csv');

So you can move the header setting below the recordset and get that value from the recordset like:
header('Content-Disposition: attachment; filename=' .$rows->getColumnVal("fm_title"). '.csv');