I need my PHP page to show my BLOB image from mysql database

by

In your current case, you have two upfront options.

The first, and the one I don’t recommend if you have numerous images like this, is to use inline base64 encoding. This is done with:

<img src="data:image/jpeg;base64,<?php echo base64_encode($image); ?>" />

A copy/paste version, using your existing code:

echo '<dt><strong>Technician Image:</strong></dt><dd>'
     . '<img src="data:image/jpeg;base64,' . base64_encode($row2['image']) . '" width="290" height="290">'
     . '</dd>';

The second method is to create an “image” PHP file that takes the ID of the image in the database as a query-string parameter and outputs the image. So, your HTML would look something like:

<img src="https://stackoverflow.com/questions/13225726/image.php?id=<?php echo $image_id; ?>" />

And your PHP page would look something similar to:

<?php
$id = (isset($_GET['id']) && is_numeric($_GET['id'])) ? intval($_GET['id']) : 0;
$image = getImageFromDatabase($id); // your code to fetch the image

header('Content-Type: image/jpeg');
echo $image;
?>

More Related Contents:

  1. Php : Convert a blob into an image file
  2. How to display an BLOB image stored in MySql database?
  3. Can I store images in MySQL [duplicate]
  4. How can I store and retrieve images from a MySQL database using PHP?
  5. Insert Blobs in MySql databases with php
  6. displaying an image stored in a mysql blob
  7. php:Store image into Mysql blob, Good or bad?
  8. Saving images in database mysql
  9. PHP to store images in MySQL or not?
  10. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  11. how to download blob based file from MySQL database in PHP?
  12. How can I insert large files in MySQL db using PHP?
  13. Comma separated numeric values – PHP CodeIgniter
  14. Select those record only from table 1 where city exist against state id in table 2 in PHP
  15. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  16. select count(*) from table of mysql in php
  17. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  18. Loading .sql files from within PHP
  19. implement LIKE query in PDO
  20. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  21. php link to image file outside default web directory
  22. MySQL db question marks instead of hebrew characters..?
  23. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  24. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  25. How I can create installer for website. PHP mysql [closed]
  26. How to join two tables with ssp.class.php
  27. How to convert IPv6 from binary for storage in MySQL
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Using Prepared Statement, how I return the id of the inserted row?
  30. Replacing \r\n with PHP

Leave a Comment