Show blob images in the database. my images do not show showimage. php & lt ;? Php & nbsp; include_once & nbsp; dirname (dirname & nbsp; (& nbsp ;__ FILE __& nbsp ;))). displays blob images in the database.
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"];
}
}
?>
What is my problem? PHP newcomers, I don't know where the mistake is:
------ Solution --------------------
Reference:
Quote: reference:
The picture cannot be displayed. Is it a program error? Or the path is incorrect.
Print it first to see if there is any data. If yes, check whether the displayed path is correct.
Run php3 to print the image. it is normal and no error is reported.
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 );