At 8:31 PM +0100 2/25/07, Alain Roger wrote:
Hi,
I previously sent email about process how to retrieve and save pictures in
postgreSQL DB.
Now i know how to save them in DB, however i would like to know how can i
retrieve the pictures and display them without knowing the picture extension
?
i mean that in my DB i have GIFs, JPGs pictures.
1. My following code display without problem JPEG picture but what about GIF
?
2. How can i display picture without using ==> header('Content-type:
image/jpeg'); Because this must be before displaying pictures.
3. what should i do if i want to display several types of pictures in the
PHP page ?
My code :
<?php
$dbconn = pg_connect($conn_string) or die('Could not connect: ' .
pg_last_error());
$res = pg_query("SELECT * FROM immense.photo where photo_id=20");
$raw = pg_fetch_result($res, 'photo_image');
if (!$res)
{
echo "An error occured.\n";
exit;
}
else
{
header('Content-type: image/jpeg');
echo pg_unescape_bytea($raw);
}
// Closing connection
pg_close($dbconn);
?>
That's the type of information you should store in your dB along with
the image.
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
