search
HomeBackend DevelopmentPHP Tutorial显示数据库中blob类型的图片,我图片显示不出来

showimage.php

<?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 "<IMG SRC=\"Second.php3?Id=$Id\">"; }}?>  


Second.php3
<?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 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"];}}?>   


请问我哪里有问题?PHP新人,不知道哪里错了


回复讨论(解决方案)

1、你的 php3 类型文件能被正确解析吗?检查一下配置文件
2、如果程序文件时 utf-8 编码的,请确认都没有 BOM 头
3、Second.php3 输出图片不要用循环

1、你的 php3 类型文件能被正确解析吗?检查一下配置文件
2、如果程序文件时 utf-8 编码的,请确认都没有 BOM 头
3、Second.php3 输出图片不要用循环
我在httpd.conf文件里面加了AddType application/x-httpd-php .php .html .htm .php3
这样是不是就能正常解析php3 类型文件了?

1、你的 php3 类型文件能被正确解析吗?检查一下配置文件
2、如果程序文件时 utf-8 编码的,请确认都没有 BOM 头
3、Second.php3 输出图片不要用循环
我程序文件是gbk的

我测试了,.php3可以正常解析的,但是还是不行啊谁帮下啊

图片显示不出来,是程序报错?还是路径不对。
先打印下,看有数据没,如果有,再看下,显示的路径是否正确。

图片显示不出来,是程序报错?还是路径不对。
先打印下,看有数据没,如果有,再看下,显示的路径是否正确。
先运行php3把image打印出来了,正常的,没有报错

<?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 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"];$image= $arr_teainfo["images"];}//header('Content-type: image/jpeg ');echo $image; }

上面代码贴出来多了

 ,我程序里没有的


图片显示不出来,是程序报错?还是路径不对。
先打印下,看有数据没,如果有,再看下,显示的路径是否正确。
先运行php3把image打印出来了,正常的,没有报错

<?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 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"];$image= $arr_teainfo["images"];}//header('Content-type: image/jpeg ');echo $image; }

程序没报错,把输出的数据复制到地址栏,有图片显示没??



图片显示不出来,是程序报错?还是路径不对。
先打印下,看有数据没,如果有,再看下,显示的路径是否正确。
先运行php3把image打印出来了,正常的,没有报错

<?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 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"];$image= $arr_teainfo["images"];}//header('Content-type: image/jpeg ');echo $image; }

程序没报错,把输出的数据复制到地址栏,有图片显示没??
这个存的不是图片的地址,而是blob数据类型的

浏览器地址栏 http://localhost/Second.php3?Id=10
能开到什么?

浏览器地址栏 http://localhost/Second.php3?Id=10
能开到什么?
如果有header('Content-type: image/jpeg ');的话,是一个显示叉叉的图片,就是显示不出来,如果注释掉,就是执行echo $image; ,显示的是好多看不懂的符号乱码,因为是blob类型,肯定不能正常输出的

浏览器地址栏 http://localhost/Second.php3?Id=10
能开到什么?
我测试的id为10的图片是jpg的,所以我先写出固定的header('Content-type: image/jpeg ');

一大堆乱七八糟的?没关系,截个图

截个图都卡半天

下面还有好多好多

一大堆乱七八糟的?没关系,截个图 能看懂吗,那些乱七八糟的,不知道什么东西

你的图片格式有问题!

这样吧,你把 $image 写到文件里,比如 file_put_contents('test.jpg', $image);
然后把他发上来

<?php$query = "select * from qzt_image where id=10";$result = mysql_query($query);$row = @mysql_fetch_array($result);Header( "Content-type: image/pjpeg");echo "$row[uploadfile]";?>

我的原始版代码。
是pjpeg哦。

你的图片格式有问题!

这样吧,你把 $image 写到文件里,比如 file_put_contents('test.jpg', $image);
然后把他发上来
前几天放假了,昨天请假了,等下我传上去

你的图片格式有问题!

这样吧,你把 $image 写到文件里,比如 file_put_contents('test.jpg', $image);
然后把他发上来
可以正常写入的

原来 test.jpg是另一张图,写入后就是这张图了

<?php$query = "select * from qzt_image where id=10";$result = mysql_query($query);$row = @mysql_fetch_array($result);Header( "Content-type: image/pjpeg");echo "$row[uploadfile]";?>

我的原始版代码。
是pjpeg哦。
我用pjpeg还是显示不出来,我用的gbk的格式,请问你用的什么格式?

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How to calculate the total number of elements in a PHP multidimensional array?How to calculate the total number of elements in a PHP multidimensional array?May 15, 2025 pm 09:00 PM

Calculating the total number of elements in a PHP multidimensional array can be done using recursive or iterative methods. 1. The recursive method counts by traversing the array and recursively processing nested arrays. 2. The iterative method uses the stack to simulate recursion to avoid depth problems. 3. The array_walk_recursive function can also be implemented, but it requires manual counting.

What are the characteristics of do-while loops in PHP?What are the characteristics of do-while loops in PHP?May 15, 2025 pm 08:57 PM

In PHP, the characteristic of a do-while loop is to ensure that the loop body is executed at least once, and then decide whether to continue the loop based on the conditions. 1) It executes the loop body before conditional checking, suitable for scenarios where operations need to be performed at least once, such as user input verification and menu systems. 2) However, the syntax of the do-while loop can cause confusion among newbies and may add unnecessary performance overhead.

How to hash strings in PHP?How to hash strings in PHP?May 15, 2025 pm 08:54 PM

Efficient hashing strings in PHP can use the following methods: 1. Use the md5 function for fast hashing, but is not suitable for password storage. 2. Use the sha256 function to improve security. 3. Use the password_hash function to process passwords to provide the highest security and convenience.

How to implement array sliding window in PHP?How to implement array sliding window in PHP?May 15, 2025 pm 08:51 PM

Implementing an array sliding window in PHP can be done by functions slideWindow and slideWindowAverage. 1. Use the slideWindow function to split an array into a fixed-size subarray. 2. Use the slideWindowAverage function to calculate the average value in each window. 3. For real-time data streams, asynchronous processing and outlier detection can be used using ReactPHP.

How to use the __clone method in PHP?How to use the __clone method in PHP?May 15, 2025 pm 08:48 PM

The __clone method in PHP is used to perform custom operations when object cloning. When cloning an object using the clone keyword, if the object has a __clone method, the method will be automatically called, allowing customized processing during the cloning process, such as resetting the reference type attribute to ensure the independence of the cloned object.

How to use goto statements in PHP?How to use goto statements in PHP?May 15, 2025 pm 08:45 PM

In PHP, goto statements are used to unconditionally jump to specific tags in the program. 1) It can simplify the processing of complex nested loops or conditional statements, but 2) Using goto may make the code difficult to understand and maintain, and 3) It is recommended to give priority to the use of structured control statements. Overall, goto should be used with caution and best practices are followed to ensure the readability and maintainability of the code.

How to implement data statistics in PHP?How to implement data statistics in PHP?May 15, 2025 pm 08:42 PM

In PHP, data statistics can be achieved by using built-in functions, custom functions, and third-party libraries. 1) Use built-in functions such as array_sum() and count() to perform basic statistics. 2) Write custom functions to calculate complex statistics such as medians. 3) Use the PHP-ML library to perform advanced statistical analysis. Through these methods, data statistics can be performed efficiently.

How to use anonymous functions in PHP?How to use anonymous functions in PHP?May 15, 2025 pm 08:39 PM

Yes, anonymous functions in PHP refer to functions without names. They can be passed as parameters to other functions and as return values ​​of functions, making the code more flexible and efficient. When using anonymous functions, you need to pay attention to scope and performance issues.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment