Images and MySQL

RabPHP

I've been wrestling with code to display images on a page. I've been trying to do this with binary_data however I can only seem to get one picture to display.

What I need, is a simple upload form, which will allow me to store the ID of the item. Then, I would like to pull and display all the images from the DB with that ID and display it on a single page.

If someone can point me to s script where I can do this, it would be appreciated. Thanks!

Here is the table information I have no problem storing the data too...

CREATE TABLE binary_data (
id int(4) NOT NULL auto_increment,
description varchar(50) default NULL,
bin_data longblob,
filename varchar(50) default NULL,
filesize varchar(50) default NULL,
filetype varchar(50) default NULL,
propid int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

All I really need is a way to take this data and push it out to a browser where I can have multiple pictures displayed at once.

Dan

herve

You need are in two steps :

first, the PHP script create the regular HTML
page. nothing special here
then come the problem of the images

In the HTML source page, the <IMG> tag should be
like an individual request for a single image,
ie :

and for another image

etc.

"x123" and "x456" are identifier use by you
for identifying (single) image in your database.
and of course those identifiers come from a
SELECT request with the "item ID" you
mentionned before.

"SELECT image_id FROM images WHERE object_id='$ID'"

$myrow=fetch_array($result);

then fetching the array of responses and
print the HTML tags

print "<IMG SRC='/php/myscript.php?image_id=".$myrow["image_id"]."'>";

Regards,
Hervé.

RabPHP

Ok, I just need to figure out how to make the script go through the table, and echo the <SRC> link for each record it finds matching that propid.

Dan