dongtang1997 2011-11-20 09:37
浏览 47

无法将blob存储的图像转换为图像格式(MySql AND php)?

I am trying to get the image which is stored in the blob format in Mysql Database.I am using the following code.
index.php

<img src='image.php?questionid=questionid&question=question1&answer=answer1&author=myname' />

image.php

<?php
require_once('dbconfiguration.php');
$sql="SELECT image FROM tablename WHERE questionid='{$_GET['questionid']}' and question='{$_GET['question']}' and answer='{$_GET['answer']}' and author='{$_GET['author']}'";
$STH = $DBH->query($sql);  
$STH->setFetchMode(PDO::FETCH_ASSOC);  
$row = $STH->fetch();  
ob_clean();
header("content-type: image/jpg") ; 
echo $row['image'] ; 
?>

In index.php I didn't get any image.So When I enter the URL for image.php I am getting the following error in forefox.

The image “URL” cannot be displayed because it contains errors.

I am using php5.3 and mysql 5.1.36 .

What I did wrong.I went through almost all forums and no clues.Please help me on this.

  • 写回答

1条回答 默认 最新

  • dqluw20882 2011-11-20 10:18
    关注

    It should be:

    <?php
    require_once('dbconfiguration.php');
    $sql="SELECT image FROM tablename WHERE questionid='{$_GET['questionid']}' and question='{$_GET['question']}' and answer='{$_GET['answer']}' and author='{$_GET['author']}'";
    $STH = $DBH->query($sql);  
    $STH->setFetchMode(PDO::FETCH_ASSOC);  
    $row = $STH->fetch();  
    ob_clean();
    header("content-type: image/jpg") ; 
    echo $row['image'] ; 
    ?>
    

    As your database field is called image not Efaq_image

    评论

报告相同问题?

悬赏问题

  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)