[ Milan M. Radovic @ 11.12.2012. 16:56 ] @
Treba mi pomoc....

Imam polje IMAGE u MS SQL bazi i pokusavam da ga prikazem u PHP-u.
Kada se prebaci u HEX, polje izgleda ovako:

Code:


FFD8FFE103FA45786966000049492A000800000011000001030001000000290100000101030001000000C50200000201030003000000DA0000000601030001000000020000000F01020009000000E00000001001020010000000E90000001201030001000000010000001501030001000000030000001A01050001000000F90000001B0105000100000001010000280103000100000002000000310102001E0000000901000032010200140000002701000013020300010000000200000098820200050000003B010000A5C407001C0000004001000069870400010000005C0100009403000008000800080046554A4946494C4D0046696E6550697820533935303020200080FC0A001027000080FC0A001027000041646F62652050686F746F73686F70204353352E312057696E646F777300323031323A31303A31392031363A34323A35320020202020005072696E74494D00303235300000020002000100000001010000000024009A82050001000000120300009D820500010000001A03000022880300010000000200000027880300010000009001000000900700040000003032323003900200140000002203000004900200140000003603000001910700040000000102030002910500010000004A03000001920A00010000005203000002920500010000005A03000003920A00010000006203000004920A00010000006A0300000592050001000000720300000792030001000000050000000892030001000000000000000992030001000000100000000A920500010000007A03000000A00700040000003031303001A00300010000000100000002A00400010000002901000003A0040001000000C50200000EA2050001000000820300000FA20500010000008A03000010A20300010000000300000017A20300010000000200000000A30700010000000300000001A30700010000000100000001A40300010000000100000002A40300010000000000000003A40300010000000000000006A40300010000000000000008A40300010000000000000009A4030001000000000000000AA4030001000000000000000CA403000100000000000000000000000A000000B40000006801000064000000323030383A31323A31302031323A35323A313800323030383A31323A31302031323A35323A313800140000000A000000A8010000640000007201000064000000750000006400000000000000640000002C010000640000007805000064000000470A000001000000470A000001000000000006000301030001000000060000001A01050001000000E20300001B01050001000000EA0300002801030001000000020000000102040001000000F20300000202040001000000000000000000000048000000010000004800000001000000FFED0C9A50686F746F73686F7020332E30003842494D040400000000003D1C015A00031B25471C015A00031B25471C0200000200021C0237000832303038313231301C023C000B3132353231382B303030301C0274000420202020003842494D0425000000000010F5ED7C5684F04754E5DA5575153B6D803842494D043A000000000093000000100000000100000000000B7072696E744F75747075740000000500000000436C7253656E756D00000000436C7253000000005247424300000000496E7465656E756D00000000496E746500000000436C726D000000004D70426C626F6F6C010000000F7072696E745369787465656E426974626F6F6C000000000B7072696E7465724E616D6554455854000000010000003842494D043B0000000001B200000010000000010000000000127072696E744F75747075744F7074696F6E7300000012000000004370746E626F6F6C0000000000436C6272626F6F6C00000000005267734D626F6F6C000000000043726E43626F6F6C0000000000436E7443626F6F6C00000000004C626C73626F6F6C00000000004E677476626F6F6C0000000000456D6C44626F6F6C0000000000496E7472626F6F6C000000000042636B674F626A630000000100000000000052474243000000030000000052642020646F7562406FE000000000000000000047726E20646F7562406FE0000000000000000000426C2020646F7562406FE000000000000000000042726454556E744623526C74000000000000000000000000426C6420556E744623526C7400000000000000000000000052736C74556E74462350786C40520000000000000000000A766563746F7244617461626F6F6C010000000050675073656E756D00000000506750730000000050675043000000004C656674556E744623526C74000000000000000000000000546F7020556E744623526C7400000000000000000000000053636C20556E74462350726340590000000000003842494D03ED000000000010004800000001000200480000000100023842494D042600000000000E000000000000000000003F8000003842494D03F200000000000A0000FFFFFFFFFFFF00003842494D040D0000000000040000001E3842494D04190000000000040000001E3842494D03F3000000000009000000000000000001003842494D040A00000000000100003842494D271000000000000A000100000000000000023842494D03F5000000000048002F66660001006C66660006000000000001002F6666000100A1999A0006000000000001003200000001005A00000006000000000001003500000001002D000000060000000000013842494D03F80000000000700000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03E800000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03E800000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03E800000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03E800003842494D0408000000000010000000010000024000000240000000003842494D041E000000000004000000003842494D041A000000000385000000060000000000000000000002C500000129000000280038003500300033003200340020004100490052005700490043004B0020006600720065007300680020006D006100740069006300200032003500300020006D006C002D0064006F00700075006E0061000000010000000000000000000000000000000000000001000000000000000000000129000002C500000000000000000000000000000000010000000000000000000000000000000000000010000000010000000000006E756C6C0000000200000006626F756E64734F626A6300000001000000000000526374310000000400000000546F70206C6F6E6700000000000000004C6566746C6F6E67000000000000000042746F6D6C6F6E67000002C500000000526768746C6F6E670000012900000006736C69636573566C4C73000000014F626A6300000001000000000005736C6963650000001200000007736C69636549446C6F6E67000000000000000767726F757049446C6F6E6700000000000000066F726967696E656E756D0000000C45536C6963654F726967696E0000000D6175746F47656E6572617465640000000054797065656E756D0000000A45536C6963655479706500000000496D672000000006626F756E64734F626A6300000001000000000000526374310000000400000000546F70206C6F6E6700000000000000004C6566746C6F6E67000000000000000042746F6D6C6F6E67000002C500000000526768746C6F6E67000001290000000375726C54455854000000010000000000006E756C6C54455854000000010000000000004D7367655445585400000001000000000006616C74546167544558540000000100000000000E63656C6C54657874497348544D4C626F6F6C010000000863656C6C546578745445585400000001000000000009686F727A416C69676E656E756D0000000F45536C696365486F727A416C69676E0000000764656661756C740000000976657274416C69676E656E756D0000000F45536C69636556657274416C69676E0000000764656661756C740000000B6267436F6C6F7254797065656E756D0000001145536C6963654247436F6C6F7254797065000000004E6F6E6500000009746F704F75747365746C6F6E67000000000000000A6C6566744F75747365746C6F6E67000000000000000C626F74746F6D4F75747365746C6F6E67000000000000000B72696768744F75747365746C6F6E6700000000003842494D042800000000000C000000023FF00000000000003842494D0414000000000004000000033842494D042100000000005900000001010000000F00410064006F00620065002000500068006F0074006F00730068006F00700000001500410064006F00620065002000500068006F0074006F00730068006F00700020004300530035002E003100000001003842494D0FA000000000010C6D616E6949524652000001003842494D416E4473000000E000000010000000010000000000006E756C6C0000000300000000414653746C6F6E6700000000000000004672496E566C4C73000000014F626A63000000010000000000006E756C6C0000000200000000467249446C6F6E67663020190000000046724741646F7562403E0000000000000000000046537473566C4C73000000014F626A63000000010000000000006E756C6C0000000400000000467349446C6F6E6700000000000000004146726D6C6F6E67000000000000000046734672566C4C73000000016C6F6E6766302019000000004C436E746C6F6E670000000000003842494D526F6C6C0000000800000000000000003842494D0FA100000000001C6D6672690000000200000010000000010000000000000001000000003842494D04010000000002A400060000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000170000000100000000000000000000000000000000000000010000DB760038629F0000DB760038629F0000DB760038629F00010002F8B600170EEA0002F8B600170EEA0002F8B600170EEA00010005B85700045FFD00091A580001D9A5000C7C5AFFFF534F00010015C9DD000055D70015C9DD000055D70015C9DD000055D700010056E87400035D730056E87400035D730056E87400035D73000100808F220005E3CB00808F220005E3CB00808F220005E3CB000100E8CAE7000C744800E8CAE7000C744800E8CAE7000C7448000100EDDDE9000BF30300EDDDE9000BF30300EDDDE9000BF303000100F4A1EB0014074E00F72B6C001FA47A00F9B4ED002B41A5000100FA212D00283A0900FC3E6E003D6F4E00FE5BAE0052A493000100FF6A4F0067D9D800FFD68F007A0780010042CF008C3529000100FF342F00B49AA000FDB94E00BDB17400FC3E6E00C6C849000100F7618C00EE2B3600F3C96B00F5BE3C00F0314900FD5143000100EE4A2900FE53CC00ED3B8800FED51100EC2CE800FF5655000100E6416600FE53CC00E6416600FE53CC00E6416600FE53CC000100CC09DD00FDD28700CC09DD00FDD28700CC09DD00FDD28700010058CF9400FFD79A0058CF9400FFD79A0058CF9400FFD79A00010056461300FE53CC0056461300FE53CC00564613


Ne mogu da prikazem sliku pa da ga ubijes...
Onaj ko je stavljao u bazu kaze da je format JPEG, ali mene buni sto pise Photoshop CS3 tu negde.
Probao sam razne nacine da prikazem, od encodiranja, secenja stringa i ne znam ni ja ko zna cega - ali nece.


[ PHPovac @ 11.12.2012. 17:02 ] @
Code (php):

function hexToStr($hex)
{
    $string='';
    for ($i=0; $i < strlen($hex)-1; $i+=2)
    {
        $string .= chr(hexdec($hex[$i].$hex[$i+1]));
    }
    return $string;
}
 

i onda staviš header i echouješ rezultat
[ PHPovac @ 11.12.2012. 17:04 ] @
Ja kada dekodujem dobijem ovo
Code:

ÿØÿáúExifII*)ÅÚ àéù(1 2'˜‚;¥Ä@i‡\”FUJIFILMFinePix S9500 €ü '€ü 'Adobe Photoshop CS5.1 Windows2012:10:19 16:42:52 PrintIM0250$š‚‚"ˆ'ˆ0220"6‘‘J’ R’Z’ b’ j’r’’ ’ ’z 0100  ) Å¢‚¢Š¢¢££¤¤¤¤¤ ¤ ¤ ¤ ´hd2008:12:10 12:52:182008:12:10 12:52:18 ¨drdudd,dxdG G âê(òHHÿí šPhotoshop 3.08BIM=Z%GZ%G720081210< 125218+0000t 8BIM%õí|V„ðGTåÚUu;m€8BIM:“ printOutputClrSenumClrSRGBCInteenumInteClrmMpBlboolprintSixteenBitbool printerNameTEXT8BIM;²printOutputOptionsCptnboolClbrboolRgsMboolCrnCboolCntCboolLblsboolNgtvboolEmlDboolIntrboolBckgObjcRGBCRd doub@oàGrn doub@oàBl doub@oàBrdTUntF#RltBld UntF#RltRsltUntF#Pxl@R vectorDataboolPgPsenumPgPsPgPCLeftUntF#RltTop UntF#RltScl UntF#Prc@Y8BIMíHH8BIM&?€8BIMò ÿÿÿÿÿÿ8BIM 8BIM8BIMó 8BIM 8BIM' 8BIMõH/fflff/ff¡™š2Z5-8BIMøpÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿèÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿèÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿèÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿè8BIM@@8BIM8BIM…Å)(850324 AIRWICK fresh matic 250 ml-dopuna)ÅnullboundsObjcRct1Top longLeftlongBtomlongÅRghtlong)slicesVlLsObjcslicesliceIDlonggroupIDlongoriginenum ESliceOrigin autoGeneratedTypeenum ESliceTypeImg boundsObjcRct1Top longLeftlongBtomlongÅRghtlong)urlTEXTnullTEXTMsgeTEXTaltTagTEXTcellTextIsHTMLboolcellTextTEXT horzAlignenumESliceHorzAligndefault vertAlignenumESliceVertAligndefault bgColorTypeenumESliceBGColorTypeNone topOutsetlong leftOutsetlong bottomOutsetlong rightOutsetlong8BIM( ?ð8BIM8BIM!YAdobe PhotoshopAdobe Photoshop CS5.18BIM  maniIRFR8BIMAnDsànullAFStlongFrInVlLsObjcnullFrIDlongf0 FrGAdoub@>FStsVlLsObjcnullFsIDlongAFrmlongFsFrVlLslongf0 LCntlong8BIMRoll8BIM¡mfri8BIM¤Ûv8bŸÛv8bŸÛv8bŸø¶êø¶êø¶ê¸W_ý XÙ¥ |ZÿÿSOÉÝU×ÉÝU×ÉÝU×Vèt]sVèt]sVèt]s€"ãË€"ãË€"ãËèÊç tHèÊç tHèÊç tHíÝé óíÝé óíÝé óô¡ëN÷+l¤zù´í+A¥ú!-(: ü>n=oNþ[®R¤“ÿjOgÙØÿ֏z€BÏŒ5)ÿ4/´š ý¹N½±tü>nÆÈI÷aŒî+6óÉkõ¾<ð1IýQCîJ)þSÌí;ˆþÕì,èÿVUæAfþSÌæAfþSÌæAfþSÌÌ Ýý̠҇Ýý̠҇ÝýÒ‡XÏ”ÿךXÏ”ÿךXÏ”ÿךVFþSÌVFþSÌVF
[ Milan M. Radovic @ 11.12.2012. 17:06 ] @
Ma ideo sam ja to, nego opet ne mogu da saznam zasto ne prikazuje :/
Probao sam u UNIX shellu da iskoristim Type ali ni on ne vidi iz tog HEX-a koji je fajl tip... Trebalo bi da je JPEG

[Ovu poruku je menjao Milan M. Radovic dana 11.12.2012. u 18:17 GMT+1]
[ PHPovac @ 11.12.2012. 17:31 ] @
Deluje mi kao da je sama slika oštećena, odnosno da je prekoračen broj karaktera prilikom upisa hex podataka.
[ Milan M. Radovic @ 11.12.2012. 17:36 ] @
I meni sad gledam, tako deluje, jer je broj karaktera ni vise ni manje nego 4096 :)
Isecena pre ce biti...

Code:

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096


[Ovu poruku je menjao Milan M. Radovic dana 11.12.2012. u 18:51 GMT+1]