PHP display image BLOB from MySQL

Question

I m attempting to display an image stored in the BLOB column in the database   I fetch the data from the database with a SELECT perform no transformations on the data and display it with the following  from a script whose only output is the following    header  Content-Type  image jpeg    echo  image    Please note chrome is displaying the content size as the correct size for the image as well as the correct mime type  image jpeg   nothing is echoing out before the header and ive checked the blob in the database is correct  There is also no trailing whitespace before or after the  lt  php   gt  tags   chrome IE displays an image icon but not the image itself  any ideas   EDIT  image is got the from the database as such     sql    SELECT   FROM products WHERE id    id    sth    db- gt query  sql    row    sth- gt fetch     image    row  image      var dump  image  gives    string           JFIF  x x       ZExif  MM             J        Q       Q      tQ      t                  C               C                                      1AQa q2      B    R     3br       amp     456789 CDEFGHIJSTUVWXYZcdefghijstuvwxyz                                                                                                                                                                                    length 60766

User · Accepted Answer

Try Like this   For Inserting into DB   db   mysqli connect  localhost   root      DbName      keep your db name  image   addslashes file get contents   FILES  images    tmp name        you keep your column name setting for insertion  I keep image type Blob   query    INSERT INTO products  id image  VALUES      image        qry   mysqli query  db   query     For Accessing image From Blob   db   mysqli connect  localhost   root      DbName      keep your db name  sql    SELECT   FROM products WHERE id    id    sth    db- gt query  sql    result mysqli fetch array  sth   echo   lt img src  data image jpeg base64   base64 encode   result  image         gt      Hope It will help you   Thanks

User · Answer

Since I have to store various types of content in my blob field column  I am suppose to update my code like this   echo  data   mime   result   data       where   mime can be an image of any kind  text  word document  text document  PDF document  etc    content datatype is blob in database

User · Answer

This is what I use to display images from blob   echo   lt img src  data image jpeg base64   base64 encode  image- gt load          gt

[php] PHP display image BLOB from MySQL

Examples related to php

Examples related to mysql