53
i used a code from a website that allows you to display images. however everything works fine from storing the image to the database but it does not display the image.
the following code is the one i have used.
Storing the images:
[PHP]<HTML>
<HEAD><TITLE>Store binary data into SQL Database</TITLE></HEAD>
<BODY>
<?php
if (isset($_REQUEST['submit'])) {
mysql_connect("localhost","root","");
mysql_select_db("binary_data");
$data = addslashes(fread(fopen($_FILES['form_data']['tmp_name'], "r"), $_FILES['form_data']['size']));
$result= mysql_query("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
"VALUES ('".$form_description."','".$data."','".$_FILES['form_data']['name']."','".$_FILES['form_data']['size']."','".$_FILES['form_data']['type']."')");
$id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";
mysql_close();
} else {
?>
<form method="post" action="store.php" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data">
<p><input type="submit" name="submit" value="submit">
</form>
<?php
}
?>[/PHP]
Getting the image from database :
[PHP]<?php
if($id) {
mysql_connect("localhost","root","");
mysql_select_db("binary_data");
$query = "select bin_data,filetype from table where id='$id'";
$result = mysql_query($query);
$data = mysql_result($result,0,"bin_data");
$type = mysql_result($result,0,"filetype");
header( "Content-type: $type");
header( "Content-type: image/pjpeg");
echo $data;
};
?>[/PHP]
displaying the image:
[PHP]<html>
<head>
<title>images retrieved from database</title>
</head>
<body>
<img src="getdata.php?id=3">
</body>
</html>[/PHP]
if someone can help i would greatly appreciate it.
thanks
ashraf
