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($I D_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:1 5) in path_here/client.php on line 138
‰PNG  IHDRÁ@Ł®ábK GD˙˙˙ ˝§“ pHYs  
šśtIME×
$ń�IDATxÚ íťůsG˛Ç?}÷ôÜŁ ‡KĚe{íÝőFĽˆ÷— íźö‡6>Ö ˇűÍ}OUő~h�‘F b×&¶ż„Ä„şŞ¦Şľ 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($I D_CLIENT); <--- returns image type

it tries to download it istead of displaying it

thank You

[oll3i]

$image = imagecreatefrom string($data); doesnt work neither

[hsriat]

$image = imagecreatefrom string($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_arr ay(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