How can I display image in PHP using image link stored in MySQL database?

Question

I have the image URL saved in my mySQL database.($imageid). How can I display images using their respective id? I want to display different images attached to different blog posts,as we see in regular blogs.

Thank you.

$pic = "<img src='".$row['row_in_question']."'>"; echo $pic; basically. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 17, 2014 at 20:05
Hey,thanks,the solution was simple. All the answers provided here worked. — Susan
– Susan, Commented Mar 17, 2014 at 20:10

Matt The Ninja · Accepted Answer · 2014-03-17 20:05:34Z

1

Unsure what stage you are, bit you need to query your 'table' for a single result, perhaps the ID? If the column was Imageid then you could display it like below in an array of results.

$con=mysqli_connect("localhost","user","pass","my_db");

$result = mysqli_query($con,"SELECT * FROM table");

while($row = mysqli_fetch_array($result))
  {
  echo '<img src="' . $row['Imageid']  . '">';
  }

mysqli_close($con);

answered Mar 17, 2014 at 20:05

Matt The Ninja

2,7315 gold badges33 silver badges62 bronze badges

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

3 Comments

Popnoodles Over a year ago

You would store an image URL in a column named Imageid?

Matt The Ninja Over a year ago

Is that not what the OP has stated?

Susan Over a year ago

Yes I stored the image URL in a column named imageid.

Collectives™ on Stack Overflow

How can I display image in PHP using image link stored in MySQL database?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related