显示数据库中blob类型的图片，小弟我图片显示不出来

程序员文章站 2022-05-06 18:09:38

...

显示数据库中blob类型的图片，我图片显示不出来
showimage.php


include_once dirname(dirname (dirname ( __FILE__ ))). '/yeqztsys1.0/utilityfunction/SqlHelp.class.php';

include_once dirname(dirname (dirname ( __FILE__ ))). '/yeqztsys1.0/Comm.class.php';


$SqlHelper = new SqlHelp ( 'read', 'qztoa' );

$sql = "select * from qzt_image";

$query = $SqlHelper->query($sql );

$query_num = $SqlHelper->num_rows ($query );


$rows = array ();  

$retarr = array (); 

$query =$SqlHelper->query ( $sql );

if($query)

{

$arr_teainfo2 = array ();

while ( $arr_teainfo = $SqlHelper->fetch_assoc($query) ) {

$arr_teainfo2 [] = $arr_teainfo;

$Id=$arr_teainfo["Id"];

echo $arr_teainfo["Id"];

echo ""; 


}

}




?>

Second.php3


include_once dirname(dirname (dirname ( __FILE__ ))). '/yeqztsys1.0/utilityfunction/SqlHelp.class.php';

include_once dirname(dirname (dirname ( __FILE__ ))). '/yeqztsys1.0/Comm.class.php';


$SqlHelper = new SqlHelp ( 'read', 'qztoa' );

$sql = "select * from qzt_image where Id=10";

$query = $SqlHelper->query($sql );

$query_num = $SqlHelper->num_rows ($query );


$rows = array ();  

$retarr = array (); 

$query =$SqlHelper->query ( $sql );

if($query)

{

$arr_teainfo2 = array ();

while ( $arr_teainfo = $SqlHelper->fetch_assoc($query) ) {

$arr_teainfo2 [] = $arr_teainfo;

$Id=$arr_teainfo["Id"];

$imagetype=$arr_teainfo["imagetype"];

//echo $arr_teainfo["images"];

//Header( "Content-type: $imagetype"); 

header('Content-type: $imagetype');

echo $arr_teainfo["images"];


}

}


?>