php ,mysql image is not displaying from database

Question

image is not displaying from the database it show just showing broken image

<?php
$con = mysql_connect('localhost', 'root', ''); //Update hostname
mysql_select_db("postad", $con); //Update database name
$query = "SELECT path1 FROM img_tbl";
$result = mysql_query($query) or die('Error : ' . mysql_error());
$row = mysql_fetch_array($result);
$photo = $row['path1'];
 echo "<center><img src=$photo alt=Profile Photo>";
?>

Did you do any basic debugging, like a view source to see the (broken) html you generated? deprecated means "don't use this anymore. it's obsolete and will be removed from PHP in a future version" — Marc B
– Marc B, Commented Sep 25, 2015 at 16:09
@HawasKaPujaari: that's broken. '-strings don't interpolate variables. — Marc B
– Marc B, Commented Sep 25, 2015 at 16:11

Pranavadurai · Accepted Answer · 2015-09-25 16:18:55Z

4

$photo is path right

then try this

echo '<center><img src='.$photo.'alt="Profile Photo"></center>';

answered Sep 25, 2015 at 16:18

Pranavadurai

1,0302 gold badges13 silver badges28 bronze badges

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

Comments

DirtyBit · Accepted Answer · 2015-09-25 16:26:51Z

2

Moving from the comments, this is the fix you need:

echo '<center><img src= '.$photo.' alt="Profile Photo"></center>';

answered Sep 25, 2015 at 16:26

DirtyBit

16.8k5 gold badges37 silver badges56 bronze badges

Comments

DEVENDRA SINGH SHEKHAWAT · Accepted Answer · 2017-12-21 06:46:46Z

1

Change second last line with this

echo '<center><img src="'.$photo.'" alt="Profile Photo"></center>';

This will work if $photo path is correct...

edited Dec 21, 2017 at 6:46

answered Sep 25, 2015 at 16:20

DEVENDRA SINGH SHEKHAWAT

215 bronze badges

Collectives™ on Stack Overflow

php ,mysql image is not displaying from database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related