php5 Problem display image from database

DMonster

i'm using php5, and I had try alot of codes to take image out from database to web browser but it didn't work at all, but when i change to php4 it work fine can any1 send me the code that can take image from DB in php5 ( php5 not 4 thanks for any help)

DaveRandom

Please post your existing code that works in php4 and not in php5.

DMonster

<?php
$connect = mysqli_connect('localhost','root','','register');
$rs = mysqli_query($connect,"select * from uploader");
while($row = mysqli_fetch_array($rs,MYSQLI_ASSOC)){
$imagebytes = $row['image'];
header('Content-type: image/jpeg');
echo $imagebytes;

}
?>

code above is to view the image from database ($row[image] is the tmp file saved to database)
if i delete the header('Content-type: image/jpeg') it will echo C:\wamp\tmp\php2074.tmp
is there anyproblem in my code that can't take image out?
thanks for any help

DaveRandom

Try replacing

echo $imagebytes;

with

readfile($imagebytes);

It looks like the column 'image' holds the path to the image, not the image data itself.

Don't forget to make sure the file exists before trying to access it!

DMonster

Warning: readfile(C:\wamp\tmp\php5037.tmp) [function.readfile]: failed to open stream: No such file or directory in C:\wamp\www\viewer.php on line 8
i tried that error echo out when i deleted the header(content-type:image/jpg)
any ideas or help?

bradgrafelman

Were these images uploaded? If so, it looks like you never called [man]move_uploaded_file/man to move the uploaded files to a permanent location.

If you do not move the files to a permanent location, PHP will automatically delete the uploaded file at the end of the upload script's execution.

DMonster

i checked my image in db is fine just a problem is that can't display it to web browser.
In my database have 2 columns first is name to take image name like :'Error.png'. The second is longblog like this: [BLOB - 23B] the thing i echo to browser is image
however the longblog is still the random tmp files saved to my db like ."C:\wamp\tmp\php5037.tmp" i still dont understand why i echo this C:\wamp\tmp\php5037.tmp thing to take a image like other people showed me
column like below

<?php 
$connect = mysqli_connect('localhost','root','','register'); 
$rs = mysqli_query($connect,"select * from uploader"); 
while($row = mysqli_fetch_array($rs,MYSQLI_ASSOC)){ 
$imagebytes = $row['image']; 
header('Content-type: image/jpeg'); 
echo $imagebytes; 

} 
?>

anyway if u have any codes that worked plz show me .Thanks for any help