如何在<td>中显示blob图像

Question

Here's my database connection code.

I want to display the blob image into td

<?php while ($news = mysql_fetch_assoc($content))
            {
                echo "<tr>";
                    echo "<td>" .$news['<img src = "data:image/jpg;base64,'.base64_encode($img).'"/>'].  "</td>";
                echo "</td>";

                echo "<tr>";
                    echo "<td>" .$news['title']."</td>";
                echo "</td>";

                echo "<tr>";
                    echo "<td>" .$news['content']."</td>";
                echo "</td>";

                echo "<tr>";
                    echo "<td>" .$news['date']."</td>";
                echo "</td>";

                echo "<tr>";
                    echo "<td>" .$news['author']."</td>";
                echo "</td>";
            }

            ?>

and I got a error says undefined index

Answer 1

You have a typo in your code. Change your line :

echo "<td>" .$news['<img src = "data:image/jpg;base64,'.base64_encode($img).'"/>']. "</td>";

By

echo "<td><img src='data:image/jpg;base64,".base64_encode($news['img'])."'/></td>";