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 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?