Can I store images in MySQL 

Yes, you can store images in the database, but it’s not advisable in my opinion, and it’s not general practice.

A general practice is to store images in directories on the file system and store references to the images in the database. e.g. path to the image,the image name, etc.. Or alternatively, you may even store images on a content delivery network (CDN) or numerous hosts across some great expanse of physical territory, and store references to access those resources in the database.

Images can get quite large, greater than 1MB. And so storing images in a database can potentially put unnecessary load on your database and the network between your database and your web server if they’re on different hosts.

I’ve worked at startups, mid-size companies and large technology companies with 400K+ employees. In my 13 years of professional experience, I’ve never seen anyone store images in a database. I say this to support the statement it is an uncommon practice.

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  3. Fatal error: Call to undefined function mysql_connect()
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Mysql query- How to use contains?
  8. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  9. Invalid column count in CSV input on line 1 Error
  10. Invalid column count in CSV input on line 1 Error
  11. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  12. PDO with INSERT INTO through prepared statements
  13. phpMyAdmin: secret passphrase?
  14. PDO bindParam() with prepared statement isn’t working
  15. Forbidden :You don’t have permission to access /phpmyadmin on this server
  16. Creating a search form in PHP to search a database?
  17. How can I do ‘insert if not exists’ in MySQL?
  18. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  19. MySqli Commands out of sync; you can’t run this command now
  20. Trying to get property of non-object in
  21. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  22. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. Commands out of sync; you can’t run this command now
  24. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  25. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  26. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  27. How can I do ‘insert if not exists’ in MySQL?
  28. Object of class DateTime could not be converted to string
  29. What does it mean to escape a string?
  30. Convert from MySQL datetime to another format with PHP
  31. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  32. mysqli::query(): Couldn’t fetch mysqli
  33. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  34. Uncaught Error: Call to undefined function mysql_escape_string()
  35. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  36. Call to a member function on null?
  37. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  38. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  39. MySQL query to get column names?
  40. What does MYSQLI_NUM mean and do?
  41. Mysql where id is in array
  42. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  43. What is the advantage of using try {} catch {} versus if {} else {}
  44. select * from table where column = value ^ column2= value
  45. Deprecated: mysql_query() [duplicate]
  46. No query results for model [App\Products] Laravel
  47. Fatal error: Call to a member function query() on null
  48. mysqlworkbench giving version error on exporting database
  49. How to make DROP INDEX IF EXISTS for mysql?
  50. What is the meaning of sprintf(): Too few arguments
  51. Having a problem getting mysqli_query to execute
  52. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  53. MySQL Daemon Failed to Start – centos 6
  54. How to insert TIMESTAMP into my MySQL table?
  55. How to remove index.php from WordPress site URL
  56. PHP Like thing similar to MySQL Like, for if statement?
  57. How get value from URL
  58. How to use Memcached with PHP7?
  59. select count(*) from table of mysql in php
  60. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  61. Array to String PHP?
  62. Convert a PHP object to an associative array
  63. Illegal string offset Warning PHP
  64. What is the difference between the ‘www’ folder and ‘htdocs’ folder?
  65. Notice: Trying to get property of non-object error
  66. undefined offset PHP error
  67. Call to undefined function mysql_query() with Login
  68. What is Options +FollowSymLinks?
  69. Call to undefined method mysqli_stmt::get_result
  70. Prioritize Visible Content WordPress
  71. file_get_contents(“php://input”) or $HTTP_RAW_POST_DATA, which one is better to get the body of JSON request?
  72. What is unexpected T_VARIABLE in PHP?
  73. How to close Browser Tab After Submitting a Form?
  74. get type in php returns “object” and not the object type
  75. How to find out if you’re using HTTPS without $_SERVER[‘HTTPS’]
  76. Check if $_POST exists
  77. PHP – Fatal error: Unsupported operand types
  78. MySQL – count total number of rows in php
  79. error importing localhost export file to server
  80. How to sort results from a custom database table
  81. Strange wordpress slowness
  82. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  83. How to get number of Affected rows from wordpress dbDelta() function
  84. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  85. Should I use WordPress to skin a database website?
  86. WordPress Custom SQL Table with UserID Filter for results
  87. How to use AJAX in WordPress in MYSQL query?
  88. MySQL Query Returns Array () In Shortcode
  89. Passing in MySQL prepare statement parameter separately throwing error
  90. Database SQL query error
  91. Cant create table on plugin activation
  92. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  93. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  94. Moving a few select DB tables to a new WP instance
  95. Need help with format of nested array in MySQL
  96. Splash pages on a high traffic site
  97. how to search through plugin in wordpress cimy-user-extra-fields?
  98. Submit cf7 form to cfdb as pdf/BLOB [closed]
  99. How to set variable to specific field when querying
  100. Split Million WordPress Post’s Into Multiple Database Server

Leave a Comment