PHP: Export DB Table to CSV FILE

Question

I've got a custom table in WordPress and I'd like to be able to export the data in that table as a FILE in CSV (semi-colon seperated) format.

I've got the data coming out properly, but how do I then save it as an attachment?

Keep in mind that when using WordPress, headers have already been set... and I really don't know how to get around that.

do you mean you used a plugin that generates custom table, and you want to export a table that is generated by that plugin? — Raptor
– Raptor, Commented Oct 3, 2011 at 3:23

paulsm4 · Accepted Answer · 2011-10-03 03:36:07Z

3

I'm not sure exactly HOW you're doing what you're TRYING to do ...

... but this link gives you a simple, straightforward way to write the data as a .csv file you can do a "save as" from your browser:

http://wordpress.org/support/topic/export-wordpress-db-table-to-excel

answered Oct 3, 2011 at 3:36

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raptor · Accepted Answer · 2011-10-03 04:24:14Z

0

For these plugins, they use database to store row & column details. You have to extract the data in MySQL database tables ( those table names are usually named after the plugin's name ) .

If you are still not sure how to do, you can just copy the table being displayed in page in browser, then paste in Excel. Last, save as CSV or XLS if you like.

answered Oct 3, 2011 at 4:24

Raptor

54.4k47 gold badges254 silver badges405 bronze badges

Comments

Umair Idrees · Accepted Answer · 2014-02-12 08:59:09Z

-1

you can use this code. just copy and past and you have it :)

https://gist.github.com/umairidrees/8952054#file-php-save-db-table-as-csv

answered Feb 12, 2014 at 8:59

Umair Idrees

1,4561 gold badge11 silver badges6 bronze badges

Collectives™ on Stack Overflow

PHP: Export DB Table to CSV FILE

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related