Srodne teme
Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Slika iz MSSQL baze

[es] :: PHP :: Slika iz MSSQL baze

[ Pregleda: 1822 | Odgovora: 5 ] > FB > Twit

Postavi temu Odgovori

Autor
Pretraga teme: Traži
Markiranje Štampanje RSS

Milan M. Radovic
Web Developer
Pančevo

Član broj: 16959
Poruke: 743
82.117.198.*



+25 Profil

icon Slika iz MSSQL baze11.12.2012. u 16:56 - pre 138 meseci
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.


I don't need a girl for sex , All I Need is Binary and HEX
 
Odgovor na temu

PHPovac

Član broj: 300013
Poruke: 168
*.dynamic.isp.telekom.rs.



+19 Profil

icon Re: Slika iz MSSQL baze11.12.2012. u 17:02 - pre 138 meseci
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
 
Odgovor na temu

PHPovac

Član broj: 300013
Poruke: 168
*.dynamic.isp.telekom.rs.



+19 Profil

icon Re: Slika iz MSSQL baze11.12.2012. u 17:04 - pre 138 meseci
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
Prikačeni fajlovi
test79.php test79.php - 8.29k
 
Odgovor na temu

Milan M. Radovic
Web Developer
Pančevo

Član broj: 16959
Poruke: 743
82.117.198.*



+25 Profil

icon Re: Slika iz MSSQL baze11.12.2012. u 17:06 - pre 138 meseci
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]
I don't need a girl for sex , All I Need is Binary and HEX
 
Odgovor na temu

PHPovac

Član broj: 300013
Poruke: 168
*.dynamic.isp.telekom.rs.



+19 Profil

icon Re: Slika iz MSSQL baze11.12.2012. u 17:31 - pre 138 meseci
Deluje mi kao da je sama slika oštećena, odnosno da je prekoračen broj karaktera prilikom upisa hex podataka.
 
Odgovor na temu

Milan M. Radovic
Web Developer
Pančevo

Član broj: 16959
Poruke: 743
82.117.198.*



+25 Profil

icon Re: Slika iz MSSQL baze11.12.2012. u 17:36 - pre 138 meseci
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]
I don't need a girl for sex , All I Need is Binary and HEX
 
Odgovor na temu

[es] :: PHP :: Slika iz MSSQL baze

[ Pregleda: 1822 | Odgovora: 5 ] > FB > Twit

Postavi temu Odgovori

Srodne teme
Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.