display image

[kante]

into my database i have a Blob field where i stored some files.. images..

when i select on that table i would like to display all the images out in the web page.

is there any php function to display an image from his binary?

[jannoy]

definitely u cannot save images into tables fields.

Solution: Save the filename of the image to your field. Then save the image into your folder "myimage/" by using $_FILES function and imagecopy();

and if u want to display the image
call the field name of your table
then
echo "<img src=myimage/$yourfield ">

[kante]

Yes i saved the binary of the image in the field table i'm sure!

Originally posted by jannoy
definitely u cannot save images into tables fields.

Solution: Save the filename of the image to your field. Then save the image into your folder "myimage/" by using $_FILES function and imagecopy();

and if u want to display the image
call the field name of your table
then
echo "<img src=myimage/$yourfield ">

[Weedpacket]

If $yourfield is the image, then you don't want to put it in the URL. What you want to put in the URL is a script that will read $yourfield and echo it. What jannoy is saying is that you're getting your URLs mixed up with the images they represent.

[tbach2]

You most definitely can save images in a database. You also need to save the mime type in another field.

then create a script that retrieves the data and puts the correct mime type in the header, ie

<?php
// file name: image.php
$id = (int)($_GET['id']);

if($id) {
        // get data and type from database

   // snip

header("Content-type: $type");
echo $data;
}
?>

then display it with <IMG SRC="image.php?id=$id">