displaying an image stored in a mysql blob

by

You can convert the image data into base64 and stick it in an <img> tag. Currently, you are trying to write text outside of the image data, and the internet browser thinks your text is part of the image and thus throws an error.

Try something like this:

echo '<img src="data:image/jpeg;base64,' . base64_encode( $row['imageContent'] ) . '" />';
echo 'Hello world.';

Note, this isn’t the best solution because it cannot be cached and is fairly slow, especially on mobile phones. Check out the caniuse for data URIs.

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. 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. How to create codeigniter dynamic menu from single table
  11. up/down voting system doesn't work when i add it to my html document
  12. How Secure Is This Login System? (Using Cookies In PHP)
  13. Commands out of sync; you can’t run this command now
  14. Get table column names in MySQL?
  15. PHP code to convert a MySQL query to CSV [closed]
  16. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  17. Use bound parameter multiple times
  18. The holy grail of cleaning input and output in php?
  19. MySQL: Select Random Entry, but Weight Towards Certain Entries
  20. Multiple mysql INSERT statements in one query php [duplicate]
  21. how safe are PDO prepared statements
  22. How to add a delete button to a PHP form that will delete a row from a MySQL table
  23. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  24. Is there any way to check the performance of mysql Indexing
  25. Understanding pdo mysql transactions
  26. Date in a URL dd/mm/yyyy
  27. PDO::rowCount VS COUNT(*)
  28. Pass PHP variable to bootstrap modal
  29. php (fuzzy) search matching
  30. SPARQL query to get all parent of a node

Leave a Comment