PHP retrieve image from Mysql database

[webmechanic]

I was able to insert images into mysql stored as binary data. How do I
retrieve it. Please provide thorough explanation. Thanks.

[Norman Peelman]

"webmechanic" <dm*******@yahoo.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

I was able to insert images into mysql stored as binary data. How do I
retrieve it. Please provide thorough explanation. Thanks.

Do your SELECT:

$query = "SELECT blobfield FROM table WHERE ????";

$result = mysql_query($query, $dbc);
$result_data = mysql_fetch_array($result, MYSQL_ASSOC);
$img = imagecreatefromstring($result_data['blobfield']);

---

Just lookup the exact function parameters as that is just off the top off my
head...

Norm
--
FREE Avatar hosting at www.easyavatar.com

[lorento]

"webmechanic" wrote :

I was able to insert images into mysql stored as binary data.

because its a binary data you can just echo the content data. Try like
this :

<?php
$query = "SELECT blobfield FROM table WHERE ????";
$result = mysql_query($query, $dbc);
$result_data = mysql_fetch_array($result, MYSQL_ASSOC);
header("Content-type: image/jpeg") ;
echo $result_data['blobfield'];

?>

regards,

Lorento
--
http://blogs.deshot.com
http://www.mastervb.net
http://www.immersivelounge.com