如何查看从MySQL数据库获取图像 [英] How to view get image back from MySQL database
本文介绍了如何查看从MySQL数据库获取图像的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在数据库中上传了一张图片。数据类型是BLOB。现在我想在浏览器中查看此图像。我写了下面的代码，但它没有生成图像。请检查它。
I have uploaded an Image in my database. The datatype is BLOB. Now I want to view this image in my browser. I have written the following code but its not generating the image. Kindly check it.
谢谢
Thanks
<?php
include 'connect.php';
//$id= $_GET['product_id'];
$query_images = "SELECT image FROM product_images WHERE product_id=121";
if (!$query_images_result = mysql_query($query_images))
{
echo mysql_error();
}
else
{
$fetch_images = mysql_fetch_array($query_images_result);
$print_images = $fetch_images['image'];
header('Content-type:image/jpeg');
echo $print_images;
}
?>
文件2
<body>
<img src='single_product_image_show.php' alt="image" />
</body>
推荐答案
也许像这样？您可能想使用 base64编码在图片中构建
maybe something like this? You might wanna use base64 encoding to build in the image
FYI：NOT TESTED。
FYI: NOT TESTED.
$sql = "SELECT `image` FROM `product_images` WHERE `product_id`=121 LIMIT 1";
$query_images_result = mysql_query($sql);
if (!$query_images_result)
{
echo mysql_error();
}
else
{
list($print_images) = mysql_fetch_array($query_images_result);
$base64source = "data:image/jpeg;base64," . base64_encode($print_images);
echo '<img src="'.$base64source.'" alt="" />';
}
这篇关于如何查看从MySQL数据库获取图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
