displaying an image in php from an xampp database

[Emma17]

Ive written code in php and have managed to connect to the database and show all the information from it except the image (BLOB) file. This is the code so far.....

<?php

$con = mysql_connect("localhost","root","");
if (!$con)
{
die ('Could Not Connect:' . mysql_error());
}

mysql_select_db("membership",$con);

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

echo "<table border='1'>
<tr>
<th> headers </th>
<th> headers1 </th>
<th> headers2 </th>
<th> headers3 </th>
<th> headers4 </th>
</tr>";

while ($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['photo'] . "</td>";
echo "<td>" . <img src=\"members.php?file={$row["photo"]}\">" . "</td>";
echo "<td>" . $row['headers'] . "</td>";
echo "<td>" . $row['headers1'] . "</td>";
echo "<td>" . $row['headers2'] . "</td>";
echo "<td>" . $row['headers3'] . "</td>";
echo "<td>" . $row['headers4'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);

?>

How do I fix this please??

[Dormilich]

where is the code to display the image itself?

[Emma17]

do i need that if the image is already stored in a database?
I'm new to this and I don't quite understand how this works!!

If all the information from the table displays on the page shouldn't the image do that to?
It only displays like an icon of where the image would be....

[Dormilich]

do i need that if the image is already stored in a database?

can a browser read a database directly?

If all the information from the table displays on the page shouldn't the image do that to?

which brings us to the question: how does HTML display an image?

It only displays like an icon of where the image would be....

answer 0.5: not like it displays text, obviously …

[Emma17]

okay, well how can I fix it?

[Dormilich]

fix what?

[Emma17]

it not displaying an image...... like am i missing code or have i done something wrong?

[Dormilich]

to start from the beginning, how do you (try to) display the image?

[Emma17]

i put an <img src> tag in a row

[Niheel]

The data in $row['photo'] is a blob, it isn't an image, you can't output it. You have to take that data and then either create a script that will output it as an image, or you can write it to a file. It is data that is most likely binary(images).

Read up on how to create image files with blob data in database.

[helimeef]

Well, another potential problem would be that you don't have an opening quote before your <img> tag:

echo "<td>" . <img src=\"members.php?file={$row["photo"]}\">" . "</td>";

Should read:

echo "<td>" . "<img src=\"members.php?file={$row["photo"]}\">" . "</td>";