php:Store image into Mysql blob, Good or bad?

by

I have often built systems to store images in the database, there are pros and cons to doing this.

Pros:

  • All your data is kept in one place, if you migrate your website/database the images will just be there
  • Its easier to sort/delete/etc…
  • Since you have to serve it via a PHP script, you can perform additional things such as security if required, or image processing (obviously you can do this with flat file too, but you have to make sure the security cant be bypassed by leaving the images in a public directory).

Cons:

  • Its slower then serving a flat file from the webserver as a PHP script needs to retrieve it, and MySQL needs to return the data.
  • Your database will become large very fast and not all web hosts take too kindly to this.
  • The file system is faster for flat file storage and retrieval as thats exactly what a file system is designed for.

More Related Contents:

  1. How can I store and retrieve images from a MySQL database using PHP?
  2. Insert Blobs in MySql databases with php
  3. I need my PHP page to show my BLOB image from mysql database
  4. displaying an image stored in a mysql blob
  5. Php : Convert a blob into an image file
  6. How to display an BLOB image stored in MySql database?
  7. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  8. how to download blob based file from MySQL database in PHP?
  9. How can I insert large files in MySQL db using PHP?
  10. Comma separated numeric values – PHP CodeIgniter
  11. Select those record only from table 1 where city exist against state id in table 2 in PHP
  12. PHP PDO prepared statements
  13. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  14. select count(*) from table of mysql in php
  15. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  16. Loading .sql files from within PHP
  17. Incorrect Integer (2147483647) is inserted into MySQL?
  18. Cannot connect to MySQL 4.1+ using old authentication
  19. Object of class DateTime could not be converted to string
  20. PHP Commands Out of Sync error
  21. PHP MYSQL UPDATE if Exist or INSERT if not?
  22. how to check and set max_allowed_packet mysql variable [duplicate]
  23. mysql_real_escape_string VS addslashes
  24. PHP: multiple SQL queries in one mysql_query statement
  25. MySql Error: 1364 Field ‘display_name’ doesn’t have default value
  26. Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
  27. How to join two tables with ssp.class.php
  28. How to convert IPv6 from binary for storage in MySQL
  29. Eloquent many-to-many-to-many – how to load distant relation easily
  30. Which is fastest in PHP- MySQL or MySQLi?

Leave a Comment