BLOB image not rendering

Question

Hi I saved a jpg image in BLOB format in mysql. I am having problem rendering the image using PHP onto my view page. When I use

header('Content-type: image/jpeg')

it gives a message on my page as Image cannot be displayed because it contains errors. When I print without header function is displays me some garbage text. Here is my code :

function loadImage(){
//connect to db
mysql_select_db('aaa',$conn);
$query = mysql_query("SELECT * FROM asdf WHERE UserName='".$userName.");
$row = mysql_fetch_array($query);
$content = $row['ProfileImage'];
header('Content-type: image/jpeg');
echo $content;
}

Here is the html code :

<img src='loadImage.php?func=loadImage' />

If the image is displayed then I plan to use

loadImage.php?func=loadImage?id=number'

But image itself is not displaying. Any help greatly appreciated.

You need to pass $conn to the function otherwise it has no connection as that is outside the scope of the function. Also where are you getting $username from? The same applies for it. — user1592648
– user1592648, Commented Jan 29, 2013 at 4:57
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — user1592648
– user1592648, Commented Jan 29, 2013 at 4:58
$conn is set. I am getting $username as well. I didnt post the connection code thats all. When I echo $row it prints as 'Array' on the page. When I print $content it prints garbage text.I am getting data from DB but just the image is not rendering — Anil Kumar
– Anil Kumar, Commented Jan 29, 2013 at 5:56

swati · Accepted Answer · 2013-05-14 10:11:20Z

2

hope this helps someone...

assuming the image is already uploaded in blob format then you can use this

first fetch the records whose images you want to display using query and store blob image in $blobimg

then use this to convert blob file

echo '<img src ="data:image/jpeg;base64,'.base64_encode($blobimg).'"/>';

answered May 14, 2013 at 10:11

swati

215 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vijay Choudhary · Accepted Answer · 2013-01-29 04:57:00Z

1

Why saving image in database.

The best practise is save your image in some folder and give your image a unique name. Then save image name into the database.

While displaying the image use

<img src='path/to/image/image_name' />

answered Jan 29, 2013 at 4:57

Vijay Choudhary

8481 gold badge9 silver badges18 bronze badges

4 Comments

Anil Kumar Over a year ago

I am not sure of this approach. Any idea where I can find a good tutorial ?

Vijay Choudhary Over a year ago

Do you want to first upload a image and then show it. Or you already have an image and just want to show it.

Vijay Choudhary Over a year ago

Please check this link. link

Confidant Over a year ago

It would be more helpful if you simply answered the question instead of telling him to do it a different way. I found this page because I want to use blobs, not rewrite all the code I inherited.

Tony Sepentulevski · Accepted Answer · 2013-01-29 05:27:09Z

0

check if you are getting any other errors on the page by commenting out header('Content-type: image/jpeg');

if your script is set to output errors then the image will not be rendered properly

answered Jan 29, 2013 at 5:27

Tony Sepentulevski

111 bronze badge

1 Comment

Anil Kumar Over a year ago

If I comment out header function nothing is displayed. I checked in firefox with firebug as well, no response text. However if I echo $row,$content it prints as 'Array and some garbage text...'. I use PHP Designer for editing php. It doesn;t show any errors as well.

Collectives™ on Stack Overflow

BLOB image not rendering

3 Answers 3

Comments

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related