Trying to retrieve image from database using phpadmin

Asked May 18 '16 at 17:31

Active May 18 '16 at 17:32

Viewed 26 times

This is my php file.

        $con=mysql_connect("localhost","root","");
        mysql_select_db("food",$con);

         $SQL = "SELECT image FROM info WHERE Type='Fruit Pizza' ";
         $RESULT = mysql_query("$SQL");


        $ROW = mysql_fetch_assoc($RESULT);

          header("Content-type: image/png");
          echo $ROW['image'];

    ?>

This is how i add the image into database.

 $data = addslashes(file_get_contents('dinner2.png'));

mysql_query("INSERT INTO info(image, Name, Price, type) VALUES('$data','Fruit Pizza','8', 'png')");

Is there anything wrong with my code?? The problem is everytime i try to retrieve the image it show a small grey box instead of the picture.Anyone can help??

edited May 18 '16 at 17:32

asked May 18 '16 at 17:31

ron

http://stackoverflow.com/questions/7793009/how-to-retrieve-images-from-mysql-database-and-display-in-an-html-tag – Felippe Duarte May 18 '16 at 17:32
3

The `mysql_*` api is deprecated. – ʰᵈˑ May 18 '16 at 17:32
What does `$ROW['image']` actually output? My guess is that if it returning anything useful is that the path isn't correct. – j08691 May 18 '16 at 17:34
And you're adding text `$data`, change `'$data'` to `"$data"` or just $data, without apostrophes – Goover May 18 '16 at 17:34
@Goover i cant add into database if without apostrophes – ron May 18 '16 at 17:40
@j08691 ['image'] is column in my table – ron May 18 '16 at 17:41
@ron oh yes, I'm sorry I've misread the line, didn't saw opening `"` – Goover May 18 '16 at 17:47

Trying to retrieve image from database using phpadmin

0 Answers0