944,043 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 262
  • PHP RSS
Nov 4th, 2009
0

How to store

Expand Post »
PHP Syntax (Toggle Plain Text)
  1. hi all
  2.  
  3. How to store xls and xslx ,txt extension file to mysql database?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mike14 is offline Offline
1 posts
since Nov 2009
Nov 4th, 2009
0
Re: How to store
Arr - ain't code tags meant to be used for code. As for the question assuming it's not code, php has a cool function called mysql_query(). With this function it is possible to insert and retrieve data from a database and to use it as something like a xls file, you could simply display the inserted data to the browser. Then when you get the user to download that file lapresto you have a downloaded xls file.
Sponsor
Featured Poster
Reputation Points: 410
Solved Threads: 258
Occupation: Genius
cwarn23 is offline Offline
3,004 posts
since Sep 2007
Nov 4th, 2009
0
Re: How to store
I guess, you trying to upload the user supplied files to the server.
If am right , storing them on the server inside some folder and saving their file name & path in the database is the proper way to handle this scenario.
Storing the entire file in database table is not necessary.

Edit: And if you save them, additionally you will have the memory issues.
In strict conditions if you want to do that, use the TEXT field type
Last edited by network18; Nov 4th, 2009 at 5:33 am. Reason: light on memory issue
Reputation Points: 29
Solved Threads: 76
Practically a Master Poster
network18 is offline Offline
616 posts
since Sep 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Thumb an image
Next Thread in PHP Forum Timeline: fading scroller effect for images and text





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC