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
Jump to PostWell, 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:
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.