Display an Image from PHP mysql table

Question

I have a PHP script to echo the contents of a Mysql table. I'm using it as a small CMS for a static page.

What I want to know is how can I go about displaying an Image in my PHP script. I have a form that submits the Date, Title, Message, and Image.

I'm using the Image field to insert the URL of an image. Whats the correct way of displaying the image on a page.

Below is my code:

<?php
$con = mysql_connect("localhost","name","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("databaseName", $con);

$result = mysql_query("SELECT * FROM Blog");


while($row = mysql_fetch_array($result))
  {
  echo $row['Date'];
  echo "<br />";
  echo $row['Title'];
  echo "<br />";
  echo $row['Message'];
  echo "<br />";
  echo $row['Image'];
  echo "<br />";
  echo "<br />";
  echo "<br />";
  }

mysql_close($con);
?>

This is the outcome:

17th Feb
Title
Here is my Message
http‍://vickybeeching.com/blog/wp-content/uploads/2011/09/canthearyou.jpeg

18th Feb
Title
Here is my Message
http‍://vickybeeching.com/blog/wp-content/uploads/2011/09/canthearyou.jpeg

but I want the page to display the image not the URL. I'm guessing just using the <img></img> tags, but I'm not sure where in the PHP.

Welcome to Stack Overflow! Please, don't use mysql_* functions in new code. They are no longer maintained and the deprecation process has begun on it. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Madara's Ghost
– Madara's Ghost, Commented Nov 3, 2012 at 9:02

Hkachhia · Accepted Answer · 2012-11-03 08:58:53Z

2

You can write code in image tag instead of echo directly.

Try this code.

echo "<img src='".$row['Image']."'/>";

answered Nov 3, 2012 at 8:58

Hkachhia

4,5458 gold badges44 silver badges79 bronze badges

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

Comments

Sona Rijesh · Accepted Answer · 2012-11-03 11:39:49Z

2

Try this code, but give image folder path perfectly

<?php
  $imagepath = "../uploads/";
  echo "<img src='".$imagepath.$row['Image']. "' alt='' height='200' width='200' /> ";
?>

According to need , you can change height and width of the image. but clarity differs.

Thanks

edited Nov 3, 2012 at 11:39

answered Nov 3, 2012 at 9:58

Sona Rijesh

1,0377 gold badges35 silver badges64 bronze badges

Comments

Iridium · Accepted Answer · 2012-11-03 09:01:29Z

0

 echo $row['Image'];

replace like this

 echo '<img src="'.$row['Image'].'" alt="" />';

edited Nov 3, 2012 at 9:01

Iridium

23.8k6 gold badges55 silver badges77 bronze badges

answered Nov 3, 2012 at 8:56

Man Programmer

5,3662 gold badges24 silver badges21 bronze badges

Collectives™ on Stack Overflow

Display an Image from PHP mysql table

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