image stored in mysql

[oll3i]

I want to display image from mysql in php page
but i have headers already sent this is what it says
will i have to change the included headers file to display images form mysql?

thank You

[Markus]

Post your code and we'll tell you wherre you've gone wrong.

[oll3i]

public function displayLogo($ID_CLIENT){
 
 
    $result=mysql_query("SELECT logo,logo_type FROM ".$this->tables['clients']." WHERE ID_CLIENT='$ID_CLIENT'")or die ("SELECT ERROR:(table clients)".mysql_error());
    $type = MYSQL_RESULT($result,0,"logo_type");
    $data = MYSQL_RESULT($result,0,"logo");
    header("Content-type: $type");
 
    echo $data;
    }
 

logo is blob

then on the site

<td>
<? echo $client->displayLogo($ID_CLIENT); ?>
</td>


but i get
Warning: Cannot modify header information - headers already sent by (output started at /home/aa24985/domains/purcon.pl/public_html/exec-jobs/config/vert_menu.php:15) in path_here/client.php on line 138
‰PNG  IHDRÁ@Ł®ábKGD˙˙˙ ˝§“ pHYs  
šśtIME×
$ń�IDATxÚíťůsG˛Ç?}÷ôÜŁ‡KĚe{íÝőFĽˆ÷—íźö‡ 6>Ö ˇűÍ}OUő~h�‘Fb×&¶ż„Ä„şŞ¦ŞľY™Y™9šRJ‘ Áż1ôd $$H� !A‚ $HH� AB‚ $H�� A‚„ $$H� !A‚˙ž0Ďú€¤’H!‘J˘¤BCCi S7‘J˘Łƒh`X¦i˘ë/ß;ÔžqB‰—ĚÔ‘HĐŔÔL4]Ă4Í‘gG C”TH%ŃĐâvC3⟦�aż="BĽě×ĐŹăą â~č#Áp0$ #"Ĺs†Â˛,LŰÄMą˜¦‰eZo5)$‘ˆˇ@ú’®ßŤ×HJtMǶmÜ´÷gščĆ ›e`†!âąTń\ꚎeY§zţđřD$PęĐúhńú蚎ahşöÇ&A»Ů¦V«1ě ŮÚݢ^Żˆ€l&ËŤë7Čć˛čč„Qˆô%ť~‡(ŚČĺsŚOŚS*•0íßşö† Tv+Ô[uęőz<éJ`&ąLŽŇX‰b©ČřŘ8†mś<¸v·wi´´mú˝~L, ŮcĹ1&¦&(N÷iŐ[TjüˇŹišd˛&Ć&p<çÜ礂V«EuŻJŁÚ C,Ç"•JaZ&†n „`0Đét@A*ťbbl‚l!‹k¸¸ž‹ĺZ'o®PŇn·©V«ôý˜Xş…c:(M!ť ~‡v§Ťřx)Ź‰‰ f.Í�Ée0-óXTv+ńřŰ úƒ>ČX¨Ýľu›‹3ĎD„p˛µµĹp8¤^ŻÓď

etc

[hsriat]

Similar question was asked earlier by someone. Have a look at this.

[oll3i]

but when i add header("Content-type: $type; charset=windows-1250");
where the type is
$type=$client->getLogoType($ID_CLIENT); <--- returns image type

it tries to download it istead of displaying it

thank You

[oll3i]

$image = imagecreatefromstring($data); doesnt work neither

[hsriat]

$image = imagecreatefromstring($data); doesnt work neither

You have to make a new PHP file for displaying images.

In that PHP file, give header of image type and print all the image data afterwards.[php]<?php
//filename: image.php
if ($_GET['img']=="")
die ('Invalid Parameter');
header("Content-type:image/jpeg");//whatever is the extension
$data = mysql_fetch_array(mysql_query("SELECT `image` FROM ...... WHERE `id`='".$_GET['img']."'"));
print($data['image']);
?>[/php]And in your HTML file, where you need to display that image, write[HTML]<img src="image.php?img=abc" alt="abc" />[/HTML]

[oll3i]

i have

<?
include('../config/config.php');
$config = new config();
$config->mysql_server_connect();
 
$result=mysql_query("SELECT logo_name,logo_size,logo_type,logo FROM ".$config->tables['clients']." WHERE ID_CLIENT=$ID_CLIENT") or die("SELECT Error(table clients): ".mysql_error());
 
list($name, $type, $size, $data) = mysql_fetch_array($result);
 
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
echo $data;
 
?
 

but how do i now pass that id_client to that file and display the image

[oll3i]

sorry i didnt notice that you actually wrote it :)

[oll3i]

but still i get X instead of logo

[hsriat]

but still i get X instead of logo

Right click on the X thingy, and click on view image.
You may see what's the error.

[oll3i]

it doesnt display the error but i know it passes the right id_client

[oll3i]

maybe there is something wrong in my download.php file

include('../config/config.php');
$config = new config();
$config->mysql_server_connect();
 
$result=mysql_query("SELECT logo_name,logo_size,logo_type,logo FROM ".$config->tables['clients']." WHERE ID_CLIENT='$ID_CLIENT'") or die("SELECT Error(table clients): ".mysql_error());
 
list($name, $size, $type,  $data) = mysql_fetch_array($result);
 
 
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
 
echo $data;
 

[oll3i]

okey it works now :) i had mistake in the path to config class
thank You a lot for Your help