[Resolved] images pulled from a database

kippy

Got a bit of a problem maybe some on can shed some light on.

I am developing a program that logs into a server and downloads an image that is stored in a database. The problem is that when I write this image as a file it will not display. Any advice.

Here is the output after I use the php function [trim] from the other server is, its a jpeg that was stored in a database. I am running PHP 4.2.2 and the program is using fopen to write it as a file.

HTTP/1.1 200 OK
Server: Microsoft-IIS/5.0
Date: Tue, 18 Jan 2005 18:51:37 GMT
MIME-Version: 1.0
Content-ID: 14921
Object-ID: 1
Connection: Keep-Alive
Content-Length: 17444
Content-Type: image/jpeg
Cache-control: private
ÿØÿà

$.' ",#(7),01444'9=82<.342ÿÛ
ÿÄ%&'()456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÄ
ÿÄ$4á%ñ&'()56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz‚ƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚâãäåæçèéêòóôõö÷øùúÿÚ¿Ý•8úÊ‘IwjwÌ«þñÅV¶¿·šâP—²@P9þurH!” ñ#c¦å µ·TRV4ŸëG2VtÂŠæ‡,ü»\~kþ4ÂgeÿU Áúb´Ç‹4ƒÿy—2ÇoîÇ'ü?Z”bYcýeäžßwúçYÍ÷/ºiFõsš±—r+7Qô-E_\¹eÙmvñöÀÉÿ@8íZÚWˆn´Â#–Û?êÜôúÔÕÐ$Ýä½å²Þ‘¸[îçÏ?…g\[Og'—qFÝ³Ðýz.=ÇZ´ÔmšX$åZ3ÃÂ¨ß_›µXãB‘ÖL‚ pÑK$2‰bvIðAÁ·oâ—å”$r‘÷ø Üwô5|ÄØéôËŒÄwJ¬3ÁÝúUèï Y>yqêz× ÚœP•ˆ†*ŸJ„_Á$…æI$RNG?ÀRæ $Ú¯Ø¥–;†/ŒllN†³-u‹b…ä•·ÉbkûWk©Y¥Ubq’£¥ó§„OùëýõX7BâßN·ºŒI)”È³RiÐ_]13«Â›r=N}ô£“È|ÆæÕÎ<ØÿšÎJÌ¤gIjµS’Í_%pyÇ«iÐí8•¦Ú\[‰a÷¤$çŠ‘™íbñ8xÉGìÊpE6o_iÒÇÇ—uƒ•˜sÿì%ºR$’îÎ#9 ¨5˜.÷¾W'¹Á§-Ä¾cï½Ï8¨DØÔ7F[qÈ«¶7:Œ¥!Ø ™Üà(÷¬˜üã¼ç<®zUµ…åg˜vŸ”ÞiGCz^{þ¬Jäwéÿ~Ÿ¦bÞ!Œ¹\–?Î³¯üWig+Ûivë}<d†bØQë{P›–ÂÑ-›9Ýžsëš˜^{]ÛÇä^{Æ/m¾?ÿ^{hõíôìzÖÜÑl5¾éÅG‚O#õ©ºŠozW{†â°|Aiíøþþbº‰®¨ómÿÌnSºakcs$Q!Êªüõë‘žr3X§R)ËKeÜ8ûsõ®ÏÄ6â×ÂW}}}}
KTd@Ü;×†15{ƒgá›™V5|(R¤$È Ž½«ÏVòÉ";tK@
âYGNŸÅ]ï‰[o„®xÏ)ÿórß»û«×Òº¡ð£)niê…¤0ÙIý‹k¹áóÈ¸;˜vnzwõ«¾Ô ‹]‰-t¸-Ì’ylé,‡ƒìN+Tvéê#Cþˆ+ŸãzÐÐ\Ÿ[ˆ?Ò;-S$êõ=©” gßÓš©t#ŽÜ’ nCÏqÅM_LÐß?î7¦2^{²ïd’hä%Ël.1Æ°kSKœÔðåW\ã¿ô¨}ªX°#!Aþ}jòü¯™TäœT¦81„Ø B{Í/ýökrÜÑ\˜$vœRJÊ=¦›þþ<¢MÿÊöñŸj²ƒ óŠ— cíøà«D¢‘:œ5Öw$VcÆËl€
ÁÜÇ·~jÖ›¥ÜÁ®ÛLÞqA.NAÆ+ãþ~ ýûŒ· þ^{?ñÁUí¹Zè+ÝHg<ÁžyM¥ìo1uˆc˜c¿ãZ—S¬WeòÄŸZÊ¼¹ƒlªêHø›} šÎêåYœïDã%¸©2HÃTˆgŸ˜b¦f0”„%&Øì†=ÝÃJ\KŒö(ûmÀÿx¸ºo»20ö¥WŽFËJG×¥1[Ë¾º6ûÑÆœ-ac\uéÅ/húE™rqpqÓiŸcm>Ò|¼çi\Ö¿Ù"'åP=…8DªqëíSÎÇÊÌý.áà¶[’r2GsZRŸûçþú5RÂ4{‹uç·½Yñâª”Ÿ0¢šDŸÚ“çïŸûîƒ©\gï0?ïTFÚ>sÏÖ“ÉPxcK™•©KSƒûUÑç•ÁA…†?Z¢t5‰[Œ‹ÜsHœñïG´¹nsáñœ‰ŸþøãKŠÈá¾Ó(#Ñ ?t%A<äjB£Ô?k!r!#¿¸Š%L9Ú¨£
«À»(Óº¼Œ';;øV|—¶EÁÎÝ¬ çŠÅº°»Ó.V-Z#mœì™Føßñ+Ð-§Ô¿µ ›q¾Õ€ìûYAû™8í†Ïü ÖµžÒåû=ÄI,MÎ×VîœY>Ñ¦s»¤$a@àzSÀsÔ~´ï ©ã Sí@‰›øÿ•mÉêù¥0<.}èŒÿqV0ã¯—Ÿ¥/Î ü³ Bü ò¥Þ HüÀiüòÅoH¨OÍïZ…P |FÙLŽï‘8IlƒÇ^{8Á¯ZErÕŠ4©¨iÙ„~‡å$óëÃ}iÖÚT¢uk‘œ!à§©Í8ƒÖ€†Ç2û6·üôlýE7 žõ Lˆ¦'‰ üjUÇÞ}1H

v4¤ÚÝƒ‚ÊE!”¹°}i¦4ö¤,ã<ÓS+íÇËøSD²ÓNX‡¡ÇÖ‹è:@ý‡åI»ÐŸ¦h!E(UëÍÛ\ž$Î¥HÜ

~UaKÑó§—R0S

^ ¸h’(Š‡»t8ô®z%”¶ÕÈ “Ímø_Žb*:ÑÓø3.OzpÝé@

egà1ü©ÑÂ©ÕÎipØëFÆ=è\8zaVìÆ€¸ïšBHé@ –ÝèÙÁl

=Í<sÚ€ˆÿ™€NÃ4ÍÙ\mÙÎOj…Üî

(ëšM±eÜåøÇLQbAÀãŠŒ3aJå€ü*EV%—9ã“HCH3»?§áFÅ9'žÔÓ$Šv±É'ŒÍY™Ž1»õr…FÜ±ƒÛ¯J~üis‘–Ïji9ÀV.O|b‹Œxöäà¯×4†19#ž)RP},»{Ž´h;›8ry þT«¼}íƒñ¬§Ôæ,6Û9;AáÑ¨LÇh¶rÝÀ"»LM°ãûÊ?]ãûÂ±ÅÜäö|gŸ™Å(º¸8Ûn‡=yÓô Ùþ!FO÷ÿÊXö¤m[RQ–™‡üRö+¸s²l’Ù@ïÁ<TEq’“¸Uí·8¨ÿ¨éôªa/rØny§
Æ'b•'·K£(U $ Øž1PÉ&ð÷ytéPÙåèzÚÅbÀÚ§Ü ÁÃåM‘¹ÓŒ÷¨–ï«»=ºRJ6r6úñ@ÂÊ79R@Âä´$dŸ\f ómŠ…tÿÙéÞ©EŠè†4…ˆÄ!†9Ú:SCB»¨ç¡â§3LxBŒ’ñüé|åazûSUÈûŠè_ˆ‰h[º‚ñz® ©ŒlYU°ç îûäu§C½H)a’2{š\¬wEcoû¸û¼Ó<‹rò\wî*æàQÁ=A8ÛùÔRî“'æP£³Ê"8æž–Væ2vß$Ók&cO^˜ýjuÂ)Ú[ ·}h÷‚Èl°BœÀäFy¤·‚ ýÐŽê)äªígÁ<œ1H/qP>´YØ43‰—yÍÀü)§{gæÆv§á›(‚”ÄÑçx>„wÍlf0î?>pIÇ'“Ai
·A×©§ùmž1éÒ§Ž aéøÐuÜƒƒÐp*t}:zÔ±ÆFCtÆx‘0 $^”44ÃÜ:±#öl×Ë’WvsQª–_»Üœžiì±›«p ±÷¦!è do-ŽÇzÏš9Ÿ*ÛñøZ¸.Jã(9É8Çn•Œ¤g’zŽ¾ô˜ÑSslb²àÅ€ëL!I9QÏqÅ<0<Æäp@5:RY´0 îã¥BììÁr»O¨¤vÒ–<ðßJ%P¥pp2[9©i®DÖâNL¥H=?_D$X—h$ç¾*K‚¥›©$p Q°$ÿÉÅX1°
Ž;äÓQbm,S2òScëR'›˜€_¥N°¬0p¼ôÇò©6ÚŒJµyˆ#tß¸í?ÂGôæ¬,Áˆ¤P¬62¨àtŽ‚C©'I ¦jPcvUbQ 89«H›ŒÄåJåHÆvŽ§ÐŸÎäÈr±|¬99¡§:.w²x>œSG’†×Ë0{úê„5£…w6çÝ’Ã 8ëÅ1ÃH¬@år9<çü÷§¤9Á†NìÿO·±¦ Y$thÞ,p3Œ‘ëëNÉùJŽxcŒbœ]Fù:sÇ¯×½¸=þµ Mÿù‚uvUŒç'€vŸð ²»\—u8Ús·_7Ë®7.æ<¨ 4ŒøÜŠU»dóùq@—ÍÜ6œœŸçš¡,Àž ;*CùçÔý)…Ë? žpÀñÇz®rÎÉ»ê@5"Æ$“½{Rò3›OÌªØ;IÜFxÿîp .e%”¨ €6““Ž¼bž"L+î=ò})WÊÎ99Ïæ)ˆošÅÃn˜#f;SOÑJ’>è^Þ•4(<6H$g$öéLaÆ=H c'®/4ÒKaÜ–#ž8§Ÿ¼GlåM‘FÈþ¦€°…Õ2«±ï“OpmV—~FwƒÀÿ Í2)$©Š.+ßµw>zñ’ ›åÈ õ_JUEÞ£sKŒ»uè;Ñp°èNÝÇkŒ‚zr?ýUaæ/±–Á™ªø Ç|µ%ª+Æû€<Ž´î!œù[°¤ëŽ¿!Áe €3’O¯¶)ÝOçïOòÓ'_éJáaš1°aŸ¨ çùWwð¦_3Ä×9ÆádÜð7§_Ê¸å1·hÆßë]¿Ã‘<KrT›ïÿ

mtmosier

What are you using trim to accomplish here? And please post some example php code which has the problem.

kippy

Trim was suggested to me.

Basically I read the the resposne from the server that stores the images and put it into a file.

$photo = "(image text from database)";
$image_file = fopen("database.jpg", "w");
					fwrite($image_file,$photo);
					fclose($image_file);

It creates the file fine but gives me a blank image or if I don't use trim just displays the jpeg text from above on the screen.

mtmosier

From the code you posted the only plausible issue I can see is if you're using a non-unix type system, you didn't specify the file mode to be binary. Regardless of what system you're using changing the mode to "wb" won't hurt anything, and may help. (From your earlier output I believe you are using windows.)

In general I'm getting a vibe of treating the image data as if it were text. I'd just like to point out that images are binary data, and in some cases require special care when working with them.

kippy

Well the server I am pulling from is IIS and our server is running Linux. I tried adding the wb but it's still not displaying. I also tried generating images after turning the trim option off.

mtmosier

In that case I see nothing wrong with your file write. But how do you get the image? Do you get it directly from a db? If so what kind of database, and are you sure its stored correctly? Are you using curl or perhaps fopen to get it from the other web server? Perhaps magic quotes is playing games with it. Would be nice to see this code.

You should probably also take a look at the file that you're writing. Is the file size even close to correct? Perhaps it has the html headers included. You should be able to view it with vi. Run the "file" command on it and see what kind of file the system thinks it is.

kippy

I use fsoket open to connect to the IIS server and it spits back the data but includes the http header. I remove the header and then write the file.

BTW the results come exactly the way I posted them above.

unfortunatly i can not provide the code in full.

I checked the file using "file" and it is seeing it as data and not a jpg.

kippy

Here is a piece of the code.


while (!feof($fp2)) {  

$temp_hold = fgets($fp2, 100000); 
$photo .= $temp_hold;
}

$image_file = fopen("photo.jpg", "wb");
fwrite($image_file,$photo);
fclose($image_file);

mtmosier

I have a hard time doing this without code, so I hope you'll indulge me. I put this together from the php docs.

<?php
$fp = fsockopen('us.i1.yimg.com', 80, $errno, $errstr, 30);
if (!$fp) {
    echo $errstr.' ('.$errno.')'."\n";
} else {
    $out = 'GET /us.yimg.com/i/mo/angelinabrad104.jpg HTTP/1.1'."\r\n";
    $out .= 'Host: us.i1.yimg.com'."\r\n";
    $out .= 'Connection: Close'."\r\n\r\n";

$photo = '';

fwrite($fp, $out);
while (!feof($fp)) {
    $photo .= fgets($fp, 128);
}
fclose($fp);
}

$pos = strpos($photo, "\r\n\r\n");
if ($pos !== false) {
    $photo = substr($photo, $pos + 4);
} else {
    echo 'End of headers not found'."\n";
}

$image_file = fopen('database.jpg', 'wb');
fwrite($image_file, $photo);
fclose($image_file);
?>

This works well for me, but perhaps I just got lucky on the images I chose.

How does this compare to what you're doing? Especially the stripping of the headers. Does this work with your test image?

kippy

I'm testing it out thanks for all the suggestions so far it should just be a few minutes.

kippy

I tried your code exactly the way you did it and it did not work for me, it gave me an image file but will not display the image.

That tells me something, it's just I don't know what.

kippy

Running
RH 7.1
PHP 4.2.2

mtmosier

I was using php 4.3.10. I tried it on an old redhat machine with 4.2.2, and the image was indeed getting truncated. The problem is that fgets is not binary safe in that version. (Seems it is in 4.3.10.)

Replace fgets with fread. That works here for 4.2.2.

kippy

Absolutly Amazing I was going nuts that did it. I can't belive it. Thank you so much. Oh man ... blood pressure receding... life adjusting to normal. Yes. Thank you so much for sticking with this. And again thanks.