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
31 Days Ago
  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,478
Reputation: cwarn23 has a spectacular aura about cwarn23 has a spectacular aura about cwarn23 has a spectacular aura about 
Solved Threads: 136
cwarn23's Avatar
cwarn23 cwarn23 is offline Offline
Nearly a Posting Virtuoso
 
0
  #2
31 Days Ago
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.
Like php then read my website at http://syntax.cwarn23.net/
Star-Trek-Atlantis - now that's what I call a movie ^_^
My favourite PC. - MacGyver Fan
Bad english note: dis-iz-2b4u
Reply With Quote Quick reply to this message  
Join Date: Sep 2009
Posts: 539
Reputation: network18 is an unknown quantity at this point 
Solved Threads: 63
network18 network18 is offline Offline
Posting Pro
 
0
  #3
31 Days Ago
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; 31 Days Ago 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:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC