• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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