How to store

Reply

Join Date: Nov 2009
Posts: 1
Reputation: mike14 is an unknown quantity at this point 
Solved Threads: 0
mike14 mike14 is offline Offline
Newbie Poster

How to store

 
0
  #1
Nov 4th, 2009
  1. hi all
  2.  
  3. How to store xls and xslx ,txt extension file to mysql database?
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 1,540
Reputation: cwarn23 has a spectacular aura about cwarn23 has a spectacular aura about cwarn23 has a spectacular aura about 
Solved Threads: 137
cwarn23's Avatar
cwarn23 cwarn23 is offline Offline
Posting Virtuoso
 
0
  #2
Nov 4th, 2009
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.
Try not to bump 10 year old threads as it can be really annoying.
http://syntax.cwarn23.net/
Smilies: ^_* +_+ v_v -_- *~*`
My favourite PC. - Oopy Doopy Do 2U2!
Reply With Quote Quick reply to this message  
Join Date: Sep 2009
Posts: 557
Reputation: network18 is an unknown quantity at this point 
Solved Threads: 64
network18 network18 is offline Offline
Posting Pro
 
0
  #3
Nov 4th, 2009
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
"The discipline of writing something down is the first step towards making it happen."

follow me on twitter
Reply With Quote Quick reply to this message  
Reply

Message:




Views: 159 | Replies: 2
Thread Tools Search this Thread



Tag cloud for PHP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC