我正在使用php和mysql从数据库上传和检索图像。我试过下面的代码,但它返回了很多加密字符。mysql中图像的数据类型为longblob。
while ($getRows = mysql_fetch_array($iQuer)){
$yyy = $getRows['user_id'];
$get = mysql_query("SELECT * FROM users where id ='".$yyy."'");
$divider = mysql_fetch_array($get);
$getName = $divider['user_name'];
$getImage = $divider['profile_pic'];
echo "<tr>";
echo "<td><div id = 'postsdiv'>" . "<img src = ".$getImage."/> <strong>". $getName ."</strong><br>". $getRows['post'] . "</div><br>";
echo "</tr>"; }
我还尝试了另一种语法,但一无所获:
while ($getRows = mysql_fetch_array($iQuer)){
$yyy = $getRows['user_id'];
$get = mysql_query("SELECT * FROM users where id ='".$yyy."'");
$divider = mysql_fetch_array($get);
$getName = $divider['user_name'];
$getImage = $divider['profile_pic'];
echo "<tr>";
echo "<td> <img src='data:image/png;base64,'" . base64_encode($getImage) . " />'"
echo "<td><div id = 'postsdiv'>" . "<strong>". $getName ."</strong><br>". $getRows['post'] . "</div><br>";
echo "</tr>";
}
你能试试吗?
$getImage = $divider['profile_pic'];
header("content-type:image/jpeg"); // Can you add this line
echo $getImage;