Insert Blobs in MySql databases with php

by

Problem

$sql = "INSERT INTO ImageStore(ImageId,Image)
        VALUES('$this->image_id','file_get_contents($tmp_image)')";

This creates a string in PHP named $sql. Forget about MySQL for a minute, because you’re not executing any query yet. You’re just building a string.

The magic of PHP means that you can write a variable name — say, $this->image_id — inside the double quotes and the variable still gets magically expanded.

This functionality, known as “variable interpolation”, does not occur for function calls. So, all you’re doing here is writing the string "file_get_contents($tmp_image)" into the database.

Solution (1)

So, to concatenate the result of calling file_get_contents($tmp_image), you have to jump out of the string and do things explicitly:

$sql = "INSERT INTO ImageStore(ImageId,Image)
        VALUES('$this->image_id','" . file_get_contents($tmp_image) . "')";

(You can see even just from the syntax highlighting how this has worked.)

Solution (2)

Now the problem you have is that if the binary data contains any ', your query is not valid. So you should run it through mysql_escape_string to sanitize it for the query operation:

$sql = "INSERT INTO ImageStore(ImageId,Image)
        VALUES('$this->image_id','" . mysql_escape_string(file_get_contents($tmp_image)) . "')";

Solution (3)

Now you have a really big string, and your database is getting bulky.

Prefer not storing images in databases, where you can help it.

More Related Contents:

  1. How can I store and retrieve images from a MySQL database using PHP?
  2. I need my PHP page to show my BLOB image from mysql database
  3. displaying an image stored in a mysql blob
  4. Php : Convert a blob into an image file
  5. How to display an BLOB image stored in MySql database?
  6. php:Store image into Mysql blob, Good or bad?
  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. PHP DateTime supported formats
  11. Can I call a PHP function in a JavaScript click handler?
  12. How to create a chat program using php and mysqli for chatting [closed]
  13. 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 ‘WHERE `id` [closed]
  14. Can I store images in MySQL [duplicate]
  15. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  16. Are mysql_real_escape_string() and mysql_escape_string() sufficient for app security?
  17. Hiding true database object ID in url’s
  18. Mysql No connection could be made because the target machine actively refused it
  19. Replacing mysql_* functions with PDO and prepared statements
  20. Laravel 5.4 field doesn’t have a default value
  21. How to store .pdf files into MySQL as BLOBs using PHP?
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. PDO MySQL: Insert multiple rows in one query
  24. Outputting all PHP errors to database not error_log
  25. Laravel nested relationships
  26. getting the value of an extra pivot table column laravel
  27. php sample script for pagination [closed]
  28. Create PHP array from MySQL column
  29. UNION syntax in Cakephp
  30. How do i search from serialize field in mysql database?

Leave a Comment