How to read blob data from database

jamal8t2

i have inserted blob data in database , but i am not able to access back that data to the browser. i have php script but it does not work proprly.
our script is below

Expand|Select|Wrap|Line Numbers

 
if ($_REQUEST[gim] == 1) {

    header("Content-type: image/jpeg");

    print $bytes;

    exit ();

}

but it does not work correctly.
the Question is now that how i will read blob data to the browser
Thanksss

ak1dnar

Only thing you need to set up the correct header.

Expand|Select|Wrap|Line Numbers

 
<?php

$con = mysql_connect('localhost', 'root', 'dba') or die ("Could not connect to the Database");

mysql_select_db('mytable', $con) or die (mysql_error()); 

$query = 'SELECT content FROM blobdata';

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)){

header("Content-type: image/jpeg");

echo $row['content'];

}

?>

How to read blob data from database

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ