MySQL中BLOB存放的图片在页面中显示

最新推荐文章于 2024-04-26 16:37:52 发布

yuzhengyang0720

最新推荐文章于 2024-04-26 16:37:52 发布

阅读量2k

点赞数

分类专栏： PHP 文章标签： mysql database query user object table

本文链接：https://blog.csdn.net/yuzhengyang0720/article/details/5967640

版权

PHP 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

pic.php

PHP code

   
   
    
    
    
    <?
    
    php
  $host="localhost"
    
    ;
  $user="root"
    
    ;
  $password="123456"
    
    ;
  $database="teacher"
    
    ;
  $table_name="student"
    
    ; 
  $conn=mysql_connect($host,$user,$password
    
    );
  echo "1111"
    
    ;
  if(!mysql_connect($host,$user,$password
    
    ))
  die("connect erroring..... ".mysql_error
    
    ());   
  mysql_select_db($database,$conn
    
    );
//  mysql_query("SET NAMES 'GB2312'"); //blob 类型是二进制的，不需要设置语言编码
    
    

    
    $result=mysql_query("select * from student where picnum=$_GET[picnum]"
    
    );
  $row=mysql_fetch_object($result
    
    );
  Header("Content-type:image/gif"
    
    );
echo $row->
    
    pic;   
?>

主程序

PHP code

   
   
    
    
    
    <html>
    
    

    
    <HEAD>
    
    
  
    
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    
    

    
    <HEAD>
    
    

    
    <body>
    
    

    
    <?
    
    php
  $host="localhost"
    
    ;
  $user="root"
    
    ;
  $password="123456"
    
    ;
  $database="test1"
    
    ;
  $table_name="teacher"
    
    ; 
  $conn=mysql_connect($host,$user,$password
    
    );
  if(!mysql_connect($host,$user,$password
    
    ))
  die("connect erroring..... ".mysql_error
    
    ());   
  mysql_select_db($database,$conn
    
    );
  mysql_query("SET NAMES 'GB2312'"
    
    );
  $v_find="select picnum from teacher"
    
    ;
  $result=mysql_query($v_find,$conn
    
    ) ;

  while($row=mysql_fetch_object($result
    
    ))
{
echo "<img src='pic.php?picnum=".$row->picnum."'>"
    
    ;
}
?>
    
    

    
    </body>
    
    

    
    </html>