Display an image from database?

Question

I'm trying to display image from the database. But nothing is going to display. My code is as below: In the photo database, I have made one table named:photo inside that table there is two field id and photo. Id is auto increment. in photo .image location is saved.

<?php
$con = mysql_connect("localhost","root","");
$db = mysql_select_db("photo",$con);

$sql_image = "select * from photo";
$sql_select =  mysql_query($sql_image);

while($data = mysql_fetch_array($sql_select)) {
    echo '<img src="/images/'.$data->photo.'"/>';
}
?>

You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Feb 06 '13 at 11:06
So what output do you get? What output do you expect? Are you getting real URLs in the output? What do you get if you request them (404? 500? 403?)? — Quentin, Feb 06 '13 at 11:06

score 4 · Answer 1 · answered Feb 06 '13 at 11:06

4

mysql_fetch_array returns an array, not an object. Use $data['photo'] to access it.

answered Feb 06 '13 at 11:06

Niet the Dark Absol

320,036
81
464
592

i have used but no getting result... – user2028580 Feb 06 '13 at 11:08

Devang Rathod · Answer 2 · 2013-02-06T11:39:35.333

2

Replace echo '<img src="/images/'.$data->photo.'"/>';

To echo '<img src="/images/".$data[photo]."/>';

edited Feb 06 '13 at 11:39

answered Feb 06 '13 at 11:06

Devang Rathod

6,650
2
23
32

@user2028580 , now check my edited code. hope this will work for you. – Devang Rathod Feb 06 '13 at 11:40
and also check your directory path from where you want to display image. – Devang Rathod Feb 06 '13 at 11:40

score 0 · Answer 3 · answered Feb 06 '13 at 11:07

0

Instead of

while($data = mysql_fetch_array($sql_select)) {
        echo '<img src="/images/'.$data->photo.'"/>';
    }

Try this:

while($data = mysql_fetch_array($sql_select)) {
    echo '<img src="/images/'.$data['photo'].'"/>';
}

answered Feb 06 '13 at 11:07

Engineer

5,911
4
31
58

here is a folder name where th images are uploaded... – user2028580 Feb 06 '13 at 11:30
Nothing works man.....i tried this – user2028580 Feb 06 '13 at 11:34
Are you giving the correct path insrc...I mean is image really there?? – Engineer Feb 06 '13 at 11:35

Display an image from database?

3 Answers3