| | |
How to store
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Nov 2009
Posts: 1
Reputation:
Solved Threads: 0
PHP Syntax (Toggle Plain Text)
hi all How to store xls and xslx ,txt extension file to mysql database?
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
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
•
•
Join Date: Sep 2009
Posts: 539
Reputation:
Solved Threads: 63
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
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
follow me on twitter
![]() |
Similar Threads
- $_SESSION and session.auto_start do not store data (PHP)
- using a DVD+RW to store files (OS X)
- Using the STL LIst Container, how do I create, write,read, and store in file. (C++)
- VC++:convert File IStream to hex and store...? (C++)
- Store Bluetooth remote address to a text file (C++)
- I need an exampls program in java to store image datatype in ms-sql (MS SQL)
- ?'s, JPG, Free Store and Compiler Synthesis (C)
- Were can I store an avitar. (Geeks' Lounge)
Other Threads in the PHP Forum
- Previous Thread: Thumb an image
- Next Thread: fading scroller effect for images and text
| Thread Tools | Search this Thread |
access ajax alexa apache api array beginner binary broken cakephp checkbox class cms code cron curl database date directory display dropdown dynamic echo email encode error fairness file files folder form forms function functions google href htaccess html image include indentedsubcategory insert integration ip java javascript joomla limit link login loop mail mail() menu methods mlm multiple multipletables mysql newsletters oop passwords paypal pdf php problem provider query radio random recursion regex remote script search secure server sessions simple sms soap source space sql syntax system table tutorial update upload url user validator variable variables video voteup web xml youtube






