Solved

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

Posted on 2008-06-20
4
395 Views
Last Modified: 2013-12-12
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
Comment
Question by:galayr
4 Comments
 
LVL 14

Accepted Solution

by:
Aamir Saeed earned 63 total points
Comment Utility
0
 
LVL 108

Assisted Solution

by:Ray Paseur
Ray Paseur earned 62 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now