Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

Create file from mySQL data and save the file back to mySQL table using PHP

I am developing with PHP and mySQL. I am creating an Excel file from mySQL data.  I want to know how I can store the Excel file being created into mySQL table. I do not want to store the file in the file system or open the file through the browser. I want to create the file and save to mySQL without saving it in the file system first and uploading later.
0
galayr
Asked:
galayr
2 Solutions
 
Ray PaseurCommented:
galayr, You are on the threshold of a computer science adventure!  You probably want to use XML for the greatest portability.  This is not a small task, but it's the right way to go.  Start your reading here:
http://office.microsoft.com/en-us/excel/HA102063961033.aspx
http://www.mrexcel.com/tip064.shtml

In the alternative you can create CSV (comma-separated values) files and store them in plain text format in MySQL.

But I sense a greater question here... If you've got a data base and you're using its contents to create a spreadsheet, why not create the Excel spreadsheet on demand using the most current values in the data base?  Just a thought.  ~Ray
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now