DISPLAYING an image from MySQL database into HTML table.

[DarnStuckAgain]

Not really sure how to get the images I have stored in MySQL into a html form. I can call-up the text fields from the database but it cannot seem to find the index for the images.

 

Here is my code:-

 

<?php

session_start();

mysql_connect("localhost","root","abc") or die ("Error! Cannot connect to database");

mysql_select_db("theimageworks") or die ("Cannot find database");

$query = "SELECT * FROM jobs";

$result = mysql_query($query) or die (mysql_error());

?>

 

 

<?php

//display data in html table

echo "<table>";

echo "<tr><td>Username</td><td align='center'>Message</td><td>Product Image</td></tr>";

 

while($row = mysql_fetch_array($result)) {

echo "</td><td>";

echo $row['username'];

echo "</td><td>";

echo $row['message'];

echo "</td></tr>";

echo $row['image'];

    }

echo "</table>";

?>

 

The error message I get is "Notice: Undefined index: image in....."

 

Thanks in advance!

[chriscloyd]

are you actually trying to store an image in the database or just a link to the image its self?

[dcro2]

Well, it seems that the table `jobs` does not have an `image` field, so check that table. Shouldn't you be also be putting it in an <img> tag?

[DarnStuckAgain]

Yes I am storing images in a database for learning purposes (I know it's not recommended).

 

You were right I wrote the wrong table name sorry about that -.-

 

The code is changed to this now :-

 

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

 

but I am getting a huge screen filled with random symbols like "HªG<Œ€:”®ì[vW¬¬e•™L¡K»Ô⩾y$M¹Q›owuŒ›Ir"

 

 

[PFMaBiSmAd]

What you are doing has been done countless times before. Please see replies #4 and #5 at the following link - http://www.phpfreaks.com/forums/index.php?topic=356903.msg1686788#msg1686788

[dcro2]

If you'd rather not use another script for images, you could embed them into your page with the data URI scheme. There's obvious downsides to that though.

 

echo "<img src='data:image/jpeg;base64,".base64_encode($row['jobimage'])."'>";

 

EDIT: just read that other post, that's one downside.

[DarnStuckAgain]

Problem solved thanks guys! I used the base64_encode solution