How to upload images into MySQL database using PHP code

by

Firstly, you should check if your image column is BLOB type!

I don’t know anything about your SQL table, but if I’ll try to make my own as an example.

We got fields id (int), image (blob) and image_name (varchar(64)).

So the code should look like this (assume ID is always ‘1’ and let’s use this mysql_query):

$image = addslashes(file_get_contents($_FILES['image']['tmp_name'])); //SQL Injection defence!
$image_name = addslashes($_FILES['image']['name']);
$sql = "INSERT INTO `product_images` (`id`, `image`, `image_name`) VALUES ('1', '{$image}', '{$image_name}')";
if (!mysql_query($sql)) { // Error handling
    echo "Something went wrong! :("; 
}

You are doing it wrong in many ways. Don’t use mysql functions – they are deprecated! Use PDO or MySQLi. You should also think about storing files locations on disk. Using MySQL for storing images is thought to be Bad Idea™. Handling SQL table with big data like images can be problematic.

Also your HTML form is out of standards. It should look like this:

<form action="insert_product.php" method="POST" enctype="multipart/form-data">
    <label>File: </label><input type="file" name="image" />
    <input type="submit" />
</form>

Sidenote:

When dealing with files and storing them as a BLOB, the data must be escaped using mysql_real_escape_string(), otherwise it will result in a syntax error.

More Related Contents:

  1. PHP – Secure member-only pages with a login system
  2. which is better every user have a table or just a row [closed]
  3. Create hyperlink from html table row to open record on a new page
  4. PHP – Change value y,n in database [closed]
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  8. PDO mysql: How to know if insert was successful
  9. How to loop through a mysql result set
  10. Maximum execution time in phpMyadmin
  11. Fetching data from MySQL database to HTML dropdown list
  12. Delete multiple rows by selecting checkboxes using PHP
  13. Fetching single row, single column with PDO
  14. Mysql No connection could be made because the target machine actively refused it
  15. How to add a delete button to a PHP form that will delete a row from a MySQL table
  16. Replacing mysql_* functions with PDO and prepared statements
  17. Is there any way to check the performance of mysql Indexing
  18. IP address storing in MySQL database using PHP [duplicate]
  19. display data from SQL database into php/ html table [closed]
  20. How to display an BLOB image stored in MySql database?
  21. phpmyadmin automatic logout time
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Fatal error: Call to undefined function mysqli_result()
  24. Laravel nested relationships
  25. Selecting all fields except only one field in mysql [duplicate]
  26. Create table with PHP and populate from MySQL
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Auto Increment skipping numbers?
  29. How to get last inserted id from table MySQL [duplicate]
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment