phpmyadmin blob php image out encrypted, 想在网页上显示blob图片

Question

问题出在这里:

代码是加密的，所以我无法在网页上显示 blob 图像，我希望 blob 显示为图像:

<?php
//connect to server
$connect = mysql_connect("localhost","root","");

//connect to database
mysql_select_db("website");

//query the database
$query = mysql_query("SELECT * FROM homepage");

//fetch results of database and convert to an array

while($rows = mysql_fetch_array($query)):
//

    echo "<div class = 'productBox1'>";
        echo "<img class = 'pImg1' src='{$rows['image']}' />";
        echo "<div class = 'pDesk1'>" . "<p>" . $rows['description'] . "</p>" . "</div>";
    echo "</div>";
//
endwhile;

?>

Answer 1

尝试将其插入到您的 php 代码中

$rows['image'] = base64_decode($rows['image']);

编辑:确保您使用

将图像放入数据库

$image = base64_encode($image);