Help display images from MySQL

maxegon

I have a table containing image info:
Field names and types:
img_id int(11) Primary Key auto_increment
binary_junk blob
filename varchar(50)
filesize int(11)
filetype varchar(50)

The following code displays all the table data correctly EXCEPT for the images, i.e. when the browser displays the results of the query, the cell that is supposed to contain the image only contains characters.
Can someone help me correct this? Thank you.

<pre>
<?
$db = @mysql_connect(localhost, root, "")
or die ("Can't connect to server.");
@mysql_select_db ("testimages", $db) or die ("Can't select database.");
$query = "select * from testpics3";
$result = mysql_query($query) or die ( mysql_error());

$number_cols = mysql_num_fields($result);

echo "<b>query: $query</b>";
echo "<table border =1>\n";
echo "<tr align=center>\n";

for ($i=0; $i<$number_cols; $i++)
{
echo "<th>" . mysql_field_name($result, $i). "</th>\n";
}
echo "</tr>\n";
while ($row = mysql_fetch_row($result))
{
echo "<tr align=left>\n";
for ($i=0; $i<$number_cols; $i++)
{
echo "<td>";
if (!isset($row[$i]))
{ echo "NULL";}
else
{echo $row[$i];}
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>";

?>
</pre>

yelvington

Of course it won't work. This is a basic HTML problem and not a PHP problem. You simply can't do what you are trying to do. Images MUST be separate objects from text.

You need to write a separate script to retrieve the image data from the database. It should start out with a call to header() setting the Content-type appropriately.

Where you want the image displayed, your HTML table should contain a standard HTML <IMG SRC="/some/path/to/imagescript.php"> tag.

Anon

There is a good article on this at http://www.phpbuilder.com/columns/florian19991014.php3

Really helped me 🙂

maxegon

Thanks. I'll experiment some more.

maxegon

Yes, I read that article by Florian Dittmar and it helped. Uploading images into the table was not a problem. Neither was viewing them one at a time by specifying the individual number by modifying his lines of code:
($get_image_result,1,"filename");
($get_image_result,1,"filetype");

The problem I can't figure out is how to display ALL of them (the images) on the page at once rather than individually one at a time. Sorry for my lack of knowledge. I'm VERY new.

yelvington

You view them all the same way you view all of the text: First query the database with a SELECT, then loop through the result set. For each result, you print out the textual data and the appropriate <IMG src="script?id=$whatever"> tag.

The $whatever comes from your database. There should be a column in your table that contains a unique ID, auto-incrementing. (If not, fix that first.) Pass that ID to the image script tag, and use it to retrieve the image.

maxegon

Thanks. I'll work on it.

Anon

I've managed to loop through an array as you suggest in main script. Each '?id=$whatever' is sent to another script to fetch the data (getdata.php). The only reason I'm doing this is because I'm having problems with Header content types. Although .jpegs are displayed, gifs are not for some reason. IWS I don't need to specify any content type for jpegs to be displayed?!

getdata script:

if($id) {
include("open_db.inc");
$query = "select bin_data,filetype,description
from binary_data where id=$id";

$result = @($query);
$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");
$desc = @MYSQL_RESULT($result,0,"description");

Header( "Content-type: $type");

echo "$data";

}

sample script from main page:

Anyone shed light on this.

Anon

Yeah! But what about creating thumbnails from binary data in mySQL?