Hi
Via the cpanel that my host provider has I can use PHPMyAdmin. This has the usual admin functions such as the ability to export the data from a specified table into Excel.

My client needs to be be able to do this - but from the website.

I have been trying to google this, but have no idea how to provide a 'button' which when clicked will run a script to extract that data from a set table?

Any help or link to a what I need would be great.

Thanks

Recommended Answers

Well, you can create CSV files easily enough from a DB. Creating a specific Excel file is a little more tricky - it involves more than just changing the file extension.

You may find this useful:

Jump to Post

All 2 Replies

Member Avatar

Well, you can create CSV files easily enough from a DB. Creating a specific Excel file is a little more tricky - it involves more than just changing the file extension.

You may find this useful: http://phpexcel.codeplex.com/

Or a list of alternatives:

http://stackoverflow.com/posts/3931142/revisions

PHPExcel has been discussed a number of times on this forum - try a forum search.

Hi Yes csv file is fine. What I'm struggling with is enabling the client to execute this export from a button on a webpage, so that they don't need to go into phpmyadmin or what ever the case may be.
Thanks I'll look at the forum and PHPexcel.

Be a part of the DaniWeb community

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