| | |
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 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/
My favourite PC. - Oopy Doopy Do 2U2!
http://syntax.cwarn23.net/
Smilies: ^_* +_+ v_v -_- *~*` My favourite PC. - Oopy Doopy Do 2U2!
•
•
Join Date: Sep 2009
Posts: 557
Reputation:
Solved Threads: 64
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
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
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
Views: 159 | Replies: 2
| Thread Tools | Search this Thread |
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl database dataentry date directory display download dynamic echo email error file files folder form forms freelancing function functions google href htaccess html image include insert integration ip java javascript joomla jquery limit link login loop mail menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search select server sessions sms soap sorting source space speed sql structure syntax system table tutorial tutorials update updates upload url validation validator variable video web xml youtube zend






