Displaying an image in PHP from MYSQL?

Question

I am trying to display an image using php. The image is stored in MYSQL table. I am able to retrieve the information from mysql in my php code, but i am having trouble displaying the image.

   $db_link = mysql_connect($host_name, $user_name, $password) or die("Could not connect to $host_name");

   mysql_select_db("gameportal") or die("Could not select database $db_name");

   $query = "select * from gamesinfo;";
   $result = mysql_query($query, $db_link) or die("Could not select");

   $Row = mysql_fetch_row($result);

   echo "$Row[0]<br>";

   echo "$Row[1]<br>";

   echo "<img src="$Row[7]" class="body" alt="" /> <br>";//image

   echo "$Row[5]<br>";

Row 7 contains the location of the image (in this case a weblink). When i try to display the webpage, the page is blank, nothing shows, but when i remove that line with the pic, the webpage shows with the remaining info. What am i doing wrong?

Can you post an example HTML output of the image. Will give a bit more insight. — Matt Shirley
– Matt Shirley, Commented Mar 4, 2015 at 0:40
Use mysqli instead of mysql. Object oriented will save you typing. — StackSlave
– StackSlave, Commented Mar 4, 2015 at 0:54

Eugen Rieck · Accepted Answer · 2015-03-04 01:16:31Z

1

This is the culprit:

echo "<img src="$Row[7]" class="body" alt="" /> <br>";

You use unquoted double quotes inside double quotes ;-). Try

echo "<img src='$Row[7]' class='body' alt='' /> <br>";

EDIT

The point is not the double quotes inside double quotes, but unquoted double quotes inside double quotes - this should work as well:

echo "<img src=\"$Row[7]\" class=\"body\" alt=\"\" /> <br>";

edited Mar 4, 2015 at 1:16

answered Mar 4, 2015 at 0:42

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lhoppe Over a year ago

i think it should actually be echo "<img src='".$Row[7]."' class='body' alt='' /> <br>";

Eugen Rieck Over a year ago

@lhoppe this should be the same!

ShadowViper Over a year ago

@EugenRieck thanks, that worked, didn't realize i needed to sue single quotes.

lhoppe Over a year ago

@A22asin you just can't mix them up. If you echo with double quotes, use single quotes within, and vice-versa.

Matt Shirley · Accepted Answer · 2015-03-04 00:46:10Z

0

I missed this the first time but:

<?php

$db_link = mysql_connect($host_name, $user_name, $password) or die("Could not connect to $host_name");

mysql_select_db("gameportal")bor die("Could not select database $db_name");

You've got bor instead of or. Make sure to turn PHP errors on.

answered Mar 4, 2015 at 0:46

Matt Shirley

4,2151 gold badge18 silver badges19 bronze badges

Comments

Muthupriya · Accepted Answer · 2015-03-04 05:45:23Z

0

Try this

Images is a directory where the images are stored.

$dir="images/";

**

echo "<img src='$dir/$row[image]' width=100px height=100px>";

**

It works fine.

edited Mar 4, 2015 at 5:45

answered Mar 4, 2015 at 5:39

Muthupriya

3431 silver badge10 bronze badges

Comments

LearningToCode · Accepted Answer · 2015-03-04 05:50:45Z

0

Not an exact answer.... but a small piece of advice. I have written an answer because I don't have the reputation for commenting. You can turn on error reporting with this line at the top of php script.

    error_reporting(-1);

Such kinds of errors would be displayed on screen and you would be able to debug yourself. When your work is done you can simply do this...

    error_reporting(0);

Refer this link: PHP error reporting

answered Mar 4, 2015 at 5:50

LearningToCode

6511 gold badge12 silver badges24 bronze badges

Collectives™ on Stack Overflow

Displaying an image in PHP from MYSQL?

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related