php mysql help--cant retrieve an image from database

salmander · #1 (**permalink**) 10-18-10, 03:08 PM

hello there, Please help me this....
I am quite new to php....i am trying to develop this php page which uploads the image then it saves it in a mysql database. The data that is saved in database is saved as a mediumblob type but when I try to retrieve the image it doesnot shows an image instead a small box with a question mark in it.
this is my code:
index.php

PHP Code:


			
<html>
<head>
<title>Image Upload</title>
</head>

<body>

<form action="index.php" method="POST" enctype="multipart/form-data">
File: 
<input type="file" name="myfile">
<br>
<input type="submit" value="upload">
</form>

<?php
// conecting to database

mysql_connect("localhost","root","") or die("cant connect to server.");
mysql_select_db("databaseimage") or die("cant connect to database");



// file properties

/* here we are declaring a variable which uses a builtin function of $_FILES and the first part of it is the name of the image, which we have selected in input name ="image" section. and the second part is the temporary name and location where the file is being uploaded, usually its the temp folder of the server....you can check it by writing echo before the $file */

echo "name: ";
echo $name = $_FILES['myfile']['name'];
echo "<BR>";
echo "type ";
echo $type = $_FILES['myfile']['type'];
echo "<BR>";
echo "Size: ";
echo $size = $_FILES['myfile']['size'];
echo "<BR>";
echo "temp: ";
echo $temp = $_FILES['myfile']['tmp_name'];
echo "<BR>";
echo "error code: ";
echo $error = $_FILES['myfile']['error'];
echo "<BR>";
echo "<BR>";
echo "file contents: "; // this will be used to save in database as BLOB (Binary Large Object) data type.


echo $file_contents = addslashes(file_get_contents($_FILES['myfile']['tmp_name']));

echo "<BR>";

// now inserting the data into database

if (!$insert = mysql_query("INSERT INTO store VALUES ('','$name','$file_contents')"))
 echo "problem uploading file";
 
 else
 {

$last_id = mysql_insert_id();
echo "Image uploaded.";
echo "<BR>";
echo "<img src=get.php?id=$last_id>";

 }

?>
</body>
</html>

-----get.php----

<?php

PHP Code:


			

// conecting to database

mysql_connect("localhost","root","") or die("cant connect to server.");
mysql_select_db("databaseimage") or die("cant connect to database");



$id = addslashes($_REQUEST['id']);
$image = mysql_query("SELECT * FROM store WHERE id = $id");
$image = mysql_fetch_assoc($image);
$image = $image['image'];


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


echo $image;

?>

job0107 · #2 (**permalink**) 10-18-10, 07:02 PM

Your going about this the wrong way.
You don't want to save the image data in the database, just the file name of the image.
And save the image on the server in a file.
Use PHP's move_uploaded_file() command to save the file.
And then save the image's file name (and path) in the database.
Then you can display the image using an <img scr="path/imageFileName.jpg"> element.

salmander · #3 (**permalink**) 10-18-10, 07:06 PM

Quote:

Originally Posted by job0107

Your going about this the wrong way.
You don't want to save the image data in the database, just the file name of the image.
And save the image on the server in a file.
Use PHP's move_uploaded_file() command to save the file.
And then save the image's file name (and path) in the database.
Then you can display the image using an <img scr="path/imageFileName.jpg"> element.

ya i think, I have to take this approach because I am fed up with saving the data to the database...and then retrieving it...it is not working at all...i have followed the tutorials again and again...just to make sure that if i am not doing anything wrong... but the question is why it is not working??