PHP MySQL Storage of Word Document

Question

How can I make it so that a user can upload and then store their word document in a database so that they can download it as a word document later?

http://php.net/manual/en/features.file-upload.php and http://php.net/pdo. — ceejayoz, Feb 02 '13 at 18:25
possible duplicate of this one? http://stackoverflow.com/questions/5285857/when-is-using-mysql-blob-recommended — ultrajohn, Feb 02 '13 at 18:26

score 1 · Answer 1 · answered Feb 02 '13 at 18:27

1

Storing files in a regular RDBM is generally considered to be bad practice. I would recommend storing the files on the file system and storing the path to the file in some kind of VARCHAR or TEXT field in the database. If you're desperate to store the file in the database look at storing it in a BINARY blob or base64 encoding it.

answered Feb 02 '13 at 18:27

James C

14,047
1
34
43

So how would I upload to document and then store it on the file system – jister13 Feb 02 '13 at 18:34

score 0 · Answer 2 · answered Feb 02 '13 at 18:25

0

The Word document should not be stored IN the database. A good practice would be to only store a link to a file within the public scope of your website.

answered Feb 02 '13 at 18:25

mimipc

1,354
2
14
28

PHP MySQL Storage of Word Document

2 Answers2