PHP image upload method

Question

I am developing a PHP website and I am having difficulty choosing the best method for storing uploaded files.

At the moment I am considering storing the image as a BLOB in the MySQL database but I have also been told that storing the file name of the image would be enough.

possible duplicate of [Storing Images in DB - Yea or Nay?](http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay) — Pekka, Feb 17 '11 at 12:29

score 0 · Accepted Answer · answered Feb 17 '11 at 12:38

There are advantages and disadvantages to both, personally i like to store the images outside of the db and reference the file using a varchar in the db.

If you want to go down the route of storing them as a blob, then this article is a nicely balanced one.

http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html

score 0 · Answer 2 · answered Feb 17 '11 at 12:42

In my opinion storing the file names only in database is fast and rich technique. you should save the files in any other directory. When you have to retrieve, your uploaded file you just need to compare it with stored name. If you are storing multiple types of files, so its always a good technique to store them in different directories. So storing the file name in database and file elsewhere is fast and good technique in my opinion

PHP image upload method

2 Answers2