Member Avatar for omlac

How do i write an export script in php from mysql data base

Regards

  • 4 Contributors
  • 3 Replies
  • 78 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by chrishea
Member Avatar for blocblue

If you write a script to write the data to a file with a .xls extension as an HTML table, it will open in Excel.

Then all you need to do is select and iterate through all the tables and rows you want to export from your MySQL database.

Member Avatar for cwarn23

Or you could use phpexcel from codeplex

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.