php - How to display an Image from a mysql blob

Question

I am trying to display an image from a MySQL blob field. I have tried a few different things and none of them seem to work.

I have tried:

• header("Content-type: $type"); img src = $blobData;

• header("Content-type: $type"); echo($blobData);

Answer 1

<?php
  header("Content-type: $type");
  echo $blobData;
?>

This code looks perfectly OK. However, I heard a similar complain from another person and I was able to troubleshoot it by assuring that:

1. The php script does not output any extra character before or after sending the binary image data.

2. The php script is saved as a pure ASCII text file, not as a Unicode/UTF-8 encoded file. The Unicode/UTF-8 encoded PHP files might include a signature as the first bytes. These bytes will be invisible in your text editor but server will send these few extra bytes to the browser before the JPEG/GIF/PNG data. The browser will therefore find the wrong signature in the beginning of data. To workaround, create a blank text file in notepad, paste in the php code and save the file in ANSI encoding.