从数据库显示图片不起作用

Question

I wnt to show some pictures i have in a mysqli database, they are stored as blob. But all i get is a A4 page with wierd text..

this is my code that i use too show(i connect to my database above this code):

echo "<table border=1>
";
/*echo "  <tr>
";
echo "    <th>Bild</th><th>Namn</th><th>Betygsättning</th>
";
echo "  </tr>
";*/
while ($rad = mysqli_fetch_array($sql_result)) {
      echo "<tr>";
      echo "<td>";?> <img src="<?php echo $rad["Bild"]; ?>" height="100" width="100"> <?php echo "</td>";
      echo "<td>"; echo $rad["Namn"]; echo "</td>";   
      echo "</tr>";
}     
echo "</table>
";

Answer 1

If you really want to embed the image to the generated html you should write it as this here:

echo "<td>";?> <img src="data:image/jpeg;base64,<?php echo base64_encode($rad["Bild"]); ?>" height="100" width="100"> <?php echo "</td>";

Here again with a little more clean code:

echo "<table border=\"1\">
";
while($rad = mysqli_fetch_array($sql_result)) {
    echo " <tr>
";
    echo "  <td>
";
    echo "   <img src=\"data:image/jpeg;base64," . base64_encode($rad["Bild"]) . "\" height=\"100\" width=\"100\" />
";
    echo "  </td>
";
    echo "  <td>" . $rad["Namn"] . "</td>";
    echo " </tr>
";
}
echo "</table>
";

It seem that you forgot also to close your img tag.