How to load image from the database in html?

Question

This is my code.

<img src="getimage.php?id=1" alt="Delicious World" />

This is getimage.php

<?php

  $id = $_GET['id'];
  // do some validation here to ensure id is safe

  $link = mysql_connect("localhost", "root", "");
  mysql_select_db("db_cupcake");
  $sql = "SELECT image FROM item WHERE id=$id";
  $result = mysql_query("$sql");
  $row = mysql_fetch_assoc($result);
  mysql_close($link);

  header("Content-type: image/jpeg");
  echo $row['0'];
?>

I have directly stored the image in the database. I want to load those images in the webpage. Help me out.

Please use mysqli/PDO instead of mysql. mysql has option for vulnerabilities. — alagu, Jul 30 '15 at 07:08
Duplicate of http://stackoverflow.com/questions/7793009/how-to-retrieve-images-from-mysql-database-and-display-in-an-html-tag — Disha V., Jul 30 '15 at 07:09
@Snickbrack I already wrote comment regarding unsafe friend. — alagu, Jul 30 '15 at 07:30

score 0 · Answer 1 · edited Jul 30 '15 at 07:33

0

You need to echo $row[image]; not echo $row[0];

edited Jul 30 '15 at 07:33

Piotr Olaszewski

6,017
5
38
65

answered Jul 30 '15 at 07:10

Yang Dipertua Nasrin

1
1

user3814927 · Accepted Answer · 2015-07-30T07:26:51.923

0

First things first . If you are passing variables in the mysql query , then use quotations .Only then mysql will execute the query . your query :- $sql = "SELECT image FROM item WHERE id=$id"; Instead use this query :- $sql = "SELECT image FROM item WHERE id='$id'"; And to display the image you can use

echo $row['image'];

edited Jul 30 '15 at 07:26

answered Jul 30 '15 at 07:20

user3814927

31
5

php-coder · Answer 3 · 2015-07-31T09:26:40.580

-1

<?php
$id = $_GET['id'];

// do some validation here to ensure id is safe

$link = mysql_connect("localhost", "root", "", "db_cupcake");  

$result = mysql_query("SELECT image FROM item WHERE id=$id");

$row = mysql_fetch_assoc($result);  

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

echo $row['image'];

mysql_close($link);

?>

edited Jul 31 '15 at 09:26

answered Jul 30 '15 at 07:32

php-coder

955
1
12
23

Hi, 0 is not string. Please remove single quotes from 0. echo $row[0] is right or $row['image'] – alagu Jul 30 '15 at 07:47

How to load image from the database in html?

3 Answers3