Imagestring output from MySQL-Database

veeh

I saved a JPEG-Image to a String-column in a MYSQL-Database.
Now I want a nice form for the output in a HTML-Code.

Until now I read out some text and write it to a table. In the same table I want to place the image.

for ($i=0; $i<mysql_num_rows ($result); $i++) {
$row = mysql_fetch_object ($result)
print("<table border=0 cellspacing=1 cellpadding=1 width=660><tr><td>");
printf("<p class='ueber'>%s</p>",$row->Ueberschrift);
printf("<p class='fliesstext'>%s</p></td>\n",$row->Textteil);
printf("<td> /* here I want to insert the image */</td>\n",$row->Bild);
print("</tr>\n</table>\n");
}

the manual suggests <IMG SRC='makeimg.php?args=make_img_args'> but that does not convince me, because I have to open a new database connection, search the right row and so on. Does anybody have a better idea?

Thanx for your help!

volleytotal_ch

what about directly inserting the path to the img?

printf("<td><img src=\"path/to/img/folder/%s\"></td>\n"",$row->Bild);

but this just works if you have stored the filename of the img in your database!

veeh

Thanks for your suggestion. I already know this solution, but I'm searching for another one, which reads the Imagestring out of the database. Its perhaps less comfortable to program, but not so easy to corrupt.

Thanks again, George

volleytotal_ch

Can't get what you mean 🙁
"Imagestring out of the database"?

veeh

You can convert the data of an image to a string to save it in a database. That doesn't mean the path and so on (like c:/path/image.jpg). It means the real image data.

volleytotal_ch

ohh, i see!
as far as i know there is no way to directly output the image!
there's only the solution you posted first.

but i never learn out ....

mikeatrpi

Each php page can only output one content type. So you need two php scripts, one to do the page and one to retrieve the image. That is why the manual suggests that <img src="phpfile.php?image=dog"> syntax. phpfile.php outputs headers specifying a jpeg, gif, png, whatever and then the imagestring as you call it.

veeh

Thanks for your response, mikeatrpi. I didn't know, that PHP allows only one type of output. That explains my problems to find a solution.