Jump to content

Archived

This topic is now archived and is closed to further replies.

kritikia

Display Images -PHP/MySQL

Recommended Posts

Hello all,

I am a newbie,,and I am trying to retrieve & display my blob data-my all images from the DB,
but with no great succes:(The only that I manage is to display 1 image

The code to display the first image:
<?php
$conn=mysql_connect("localhost","admin","");
mysql_select_db("Images") or die(mysql_error());

$sql="SELECT content FROM tbl_1";
$result=mysql_query($sql) or die("Invalid Query:" . mysql_error());
header("Content-type: image/jpeg");
$data=@mysql_result($result,0,"content");
echo $data;
mysql_close($conn);
?>

How can I modify this code to display all the images that are stored in the DB,
instead of only one(,that I define which one)
Can you help  me??Any idea?
Thanks!!

Kritikia

Share this post


Link to post
Share on other sites
Replace....

[code=php:0]
$data=@mysql_result($result,0,"content");
echo $data;
[/code]

with...

[code=php:0]
while ($data = mysql_result($result,0,"content")) {
    echo $data;
}
[/code]

Share this post


Link to post
Share on other sites
Hello thorpe,

I did it,but still the same result.. :(
It displays only one image,the first.

kritikia

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.