adam291086 Posted March 11, 2009 Share Posted March 11, 2009 how do you update a mediumblob data type with php. I have turned the image into binary but the database is refusing it here is the binary file GIF89a00÷ÿû÷η°êÛ%ÿúúKŒ64ŠüHGד–Ó´±I˜ýkLQz4ÿäPöï‘H‡U—(†þ|UšQ% víá,S“Kgÿ úQ>ÕÓÅþô…¦xôìyö#Ö̆üJ;6f²¿©kžfU‹ªqPû-6þû2(Xô--üC5x£r9…ôéT&xþb]ÿü#éÚþÚÚýhgÿü*ÿ¯.X¢w²öâÝŠÓwzüeJýƒYçÛwù2,þ¸¹úVAÿÜ÷ò¨þ“cÿÓEûô-þ””ú=2óê0w üô#ôìk„Ÿgÿ!)ìã4ÿúÀɺþ‡,ýˆˆùõ»þ).*iý}}eaš#~ Þ€‚Ƨ–ôé"þˆ\[’ýrrû]D6zÉËÄK’ñäýtQDþÃÄö11ÿîîýbFýûEû>FóòäûRSå\bÿšíãEþD8x—Zv® þ¬óè*ÉÖÂœ¶–ÿÜl¬õê<þü;ÿÏÏa›ZÔÆÇÿããýy*ùò4ÕÍ»ü]^þu4àØXf’9õ$*¡W'ÿÅ(€ÿØ#õ92ìN2ñ|hþ ˜ªƒádhú6/ÜÒsùîØáÔ”²Ž¼ŽuöF+ðä%k¡ óŠyåX\ñèKö§šÎÊ íQ4õéüûäÝÕ¦Š …îßèCEApújröèùíó;’ú>?ðå/õ 'øK;þ`k—GúV[ùó;gˆD¯‰`¢þÏÐýQLøî!ÒÒÏüJPc©büñýXTðç4ì-6ÿ×èLRïèeÿÓeŸòé\øF8ý¢j¦ýb6ûoOï'.÷@5þZIÿÌ"ðgQ{÷ï'ú“ô˜‰¤¹Ÿ÷*(ÿÇî\DäÚDøì4Ò}€ü¦¨þ†Jþ—Eÿš^ùv}ö5=ßknø9=à}kÿ7?ÄпìÞ×ýÉÊùÈÀñs^úÑÊèïæý}WÿçéüR)@Ž9ž¯øµ«p”R”<ÿÑ׋|o§ äÐÇîä:ÔÔÔ!ùÿ,00ÿÿ H°à@@[è˜Äð¸œH±â@ZŒAkƒ£c«Ž8Ú´!æé€D‹( "€³±ÕÇXhнz….…—!‰í#”2%:p´òP+\»@’&M#ã¶WmZirRICω½$-‘Ï6¤JÊÐNÕ#¼•ºJPT!Rm™·4Ý»xï&•qLÚlÿ‰¹• Å<æZ̸±cÆiñ+àX¯žPn…0|); C‹-:)R“ýºlqðæb.]b§«vm?¸së¶ K¤Ä@{%Í ìõƒ§ß™çУKï÷ïcÃ+ä¨(©pƒë @ÿYGè‡ùóèÓ£w7¥ý”Éì5`+Š+hÿ(`€?¼'D{Ÿ'À'¬Är à’‡6"ÀL$f¨á†2s ‚¸D§ õAAÀLÀ˜‚É‹ylaÄŒ4Öh#Ø€"„<:ÐÁ)% ‡U=ˆÂ,®À¦à²…PF)å”R‚Ò#K¸¤wœ(TqÅ\0 hr‰l¶éæ›m–“MtÒÙ‚–[zÃZwb6P¦#ºB&ª|a衈&j¨*йÄðá†d”(Ÿ@øT!f™¸ðǧ#dRȤ–:Ãä˜jj!³„2ÊŒÿ² ¥@VP‰`„qðJA=XðG µÔRȱ/¼PˆD¸Ü8ãC"TÀ/–¼-¹ÜNçuw»¢¹+xï=‰PAA”nºéhBÅ64þx0Ä»%¼ÜA7hž@šÀßMlã%*ÄQ:ÈLGPBÉ6±4~ /±W¿µkÇa˜áÊîà»ò{ßÛPr„ *,‚üú ¯%>´^Á5×Äþı+qí9ØófHl@Àݱ€ä;ßœŒõ!ÁŽàƒèÍO J¸ŸõwX„Bÿ Q@3 ° >8Â@ ˆ 0¤c@P0z°¸F5x?òbXÀÿÌ\ü∹€€ BiÔX„!`õÅ!‚ï‹…(r¨hЋE¸VóZ±ˆ{Hc.l03ôÍ*3ô0LÃŽjÀÀ"ÀeP‚q°(BŸàEÀ ƒ@ þ!‰3æb7¸ÁrÑƾ9b0DÀ †NvrQ0@à@†L% ‹ù€ðÂ##9I%2Ñ Âv €^*€—¿ÜlhJT¦'(äÐ :`X€d$›10ñ²Ãž¡nz³›;PC¤±G’Æ„ N0ˆaf Ú °ÐŒHÞ X°&Žÿ5( h@Ÿ± s‹§4æð‚Ä™HF"É|*‚ ÒÈÀ*2H £hA—‘‚-žàèD';‘ðN‚ˆ@žXàGêPQ}Jÿ”ä!öTPH* $œT¥'ýÆ&Âx!2 éE—„gè”XÍ*Våñ0È¢¤F=éIû0ˆo„‚"½p¦8ÁV‹Ra`xº@׺֕ePÃWE1Œ±ž€¬ƒhéD €/xXð‚>e¡†2ð`ld» È |íƒfû`‹oÑ"@„S »ØÆva¨Mmjg!d³ÃèÃÖÐÙ²ˆ¡'¡•',§jZÕúv•½¬(ü1Û΂H˜¡…Ë–^4•·„«U{ªÕ–ÁµÒH„(œ0>x)0-˜˜GÈB—¼|†~¹)Ìq¦À‚Êà |Ò‹-h$hÆ2d‘ –Å2‘‚m@#ó0EpT¤ÁŽ±ˆÑ€`c€îI/ IÀÁž€ƒCLÒ «; is it just a matter of INSERT INTO `persons` VALUES ('GIF89a00÷ÿû÷η°êÛ%ÿúúKŒ64ŠüHGד–Ó´±I˜ýkLQz4ÿäPöï‘H‡U—(†þ|UšQ% víá,S“Kgÿ úQ>ÕÓÅþô…¦xôìyö#Ö̆üJ;6f²¿©kžfU‹ªqPû-6þû2(Xô--üC5x£r9…ôéT&xþb]ÿü#éÚþÚÚýhgÿü*ÿ¯.X¢w²öâÝŠÓwzüeJýƒYçÛwù2,þ¸¹úVAÿÜ÷ò¨þ“cÿÓEûô-þ””ú=2óê0w üô#ôìk„Ÿgÿ!)ìã4ÿúÀɺþ‡,ýˆˆùõ»þ).*iý}}eaš#~ Þ€‚Ƨ–ôé"þˆ\[’ýrrû]D6zÉËÄK’ñäýtQDþÃÄö11ÿîîýbFýûEû>FóòäûRSå\bÿšíãEþD8x—Zv® þ¬óè*ÉÖÂœ¶–ÿÜl¬õê<þü;ÿÏÏa›ZÔÆÇÿããýy*ùò4ÕÍ»ü]^þu4àØXf’9õ$*¡W'ÿÅ(€ÿØ#õ92ìN2ñ|hþ ˜ªƒádhú6/ÜÒsùîØáÔ”²Ž¼ŽuöF+ðä%k¡ óŠyåX\ñèKö§šÎÊ íQ4õéüûäÝÕ¦Š …îßèCEApújröèùíó;’ú>?ðå/õ 'øK;þ`k—GúV[ùó;gˆD¯‰`¢þÏÐýQLøî!ÒÒÏüJPc©büñýXTðç4ì-6ÿ×èLRïèeÿÓeŸòé\øF8ý¢j¦ýb6ûoOï'.÷@5þZIÿÌ"ðgQ{÷ï'ú“ô˜‰¤¹Ÿ÷*(ÿÇî\DäÚDøì4Ò}€ü¦¨þ†Jþ—Eÿš^ùv}ö5=ßknø9=à}kÿ7?ÄпìÞ×ýÉÊùÈÀñs^úÑÊèïæý}WÿçéüR)@Ž9ž¯øµ«p”R”<ÿÑ׋|o§ äÐÇîä:ÔÔÔ!ùÿ,00ÿÿ H°à@@[è˜Äð¸œH±â@ZŒAkƒ£c«Ž8Ú´!æé€D‹( "€³±ÕÇXhнz….…—!‰í#”2%:p´òP+\»@’&M#ã¶WmZirRICω½$-‘Ï6¤JÊÐNÕ#¼•ºJPT!Rm™·4Ý»xï&•qLÚlÿ‰¹• Å<æZ̸±cÆiñ+àX¯žPn…0|); C‹-:)R“ýºlqðæb.]b§«vm?¸së¶ K¤Ä@{%Í ìõƒ§ß™çУKï÷ïcÃ+ä¨(©pƒë @ÿYGè‡ùóèÓ£w7¥ý”Éì5`+Š+hÿ(`€?¼'D{Ÿ'À'¬Är à’‡6"ÀL$f¨á†2s ‚¸D§ õAAÀLÀ˜‚É‹ylaÄŒ4Öh#Ø€"„<:ÐÁ)% ‡U=ˆÂ,®À¦à²…PF)å”R‚Ò#K¸¤wœ(TqÅ\0 hr‰l¶éæ›m–“MtÒÙ‚–[zÃZwb6P¦#ºB&ª|a衈&j¨*йÄðá†d”(Ÿ@øT!f™¸ðǧ#dRȤ–:Ãä˜jj!³„2ÊŒÿ² ¥@VP‰`„qðJA=XðG µÔRȱ/¼PˆD¸Ü8ãC"TÀ/–¼-¹ÜNçuw»¢¹+xï=‰PAA”nºéhBÅ64þx0Ä»%¼ÜA7hž@šÀßMlã%*ÄQ:ÈLGPBÉ6±4~ /±W¿µkÇa˜áÊîà»ò{ßÛPr„ *,‚üú ¯%>´^Á5×Äþı+qí9ØófHl@Àݱ€ä;ßœŒõ!ÁŽàƒèÍO J¸ŸõwX„Bÿ Q@3 ° >8Â@ ˆ 0¤c@P0z°¸F5x?òbXÀÿÌ\ü∹€€ BiÔX„!`õÅ!‚ï‹…(r¨hЋE¸VóZ±ˆ{Hc.l03ôÍ*3ô0LÃŽjÀÀ"ÀeP‚q°(BŸàEÀ ƒ@ þ!‰3æb7¸ÁrÑƾ9b0DÀ †NvrQ0@à@†L% ‹ù€ðÂ##9I%2Ñ Âv €^*€—¿ÜlhJT¦'(äÐ :`X€d$›10ñ²Ãž¡nz³›;PC¤±G’Æ„ N0ˆaf Ú °ÐŒHÞ X°&Žÿ5( h@Ÿ± s‹§4æð‚Ä™HF"É|*‚ ÒÈÀ*2H £hA—‘‚-žàèD';‘ðN‚ˆ@žXàGêPQ}Jÿ”ä!öTPH* $œT¥'ýÆ&Âx!2 éE—„gè”XÍ*Våñ0È¢¤F=éIû0ˆo„‚"½p¦8ÁV‹Ra`xº@׺֕ePÃWE1Œ±ž€¬ƒhéD €/xXð‚>e¡†2ð`ld» È |íƒfû`‹oÑ"@„S »ØÆva¨Mmjg!d³ÃèÃÖÐÙ²ˆ¡'¡•',§jZÕúv•½¬(ü1Û΂H˜¡…Ë–^4•·„«U{ªÕ–ÁµÒH„(œ0>x)0-˜˜GÈB—¼|†~¹)Ìq¦À‚Êà |Ò‹-h$hÆ2d‘ –Å2‘‚m@#ó0EpT¤ÁŽ±ˆÑ€`c€îI/ IÀÁž€ƒCLÒ «' Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/ Share on other sites More sharing options...
rhodesa Posted March 11, 2009 Share Posted March 11, 2009 usually I use a TEXT type instead of BLOB and just base64_encode() it before inserting Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782106 Share on other sites More sharing options...
Mchl Posted March 11, 2009 Share Posted March 11, 2009 Do you get any error messages? Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782108 Share on other sites More sharing options...
adam291086 Posted March 11, 2009 Author Share Posted March 11, 2009 yeah i know this is an anal way of doing it. Its a uni project and we are not allowed to touch the database data types Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782109 Share on other sites More sharing options...
adam291086 Posted March 11, 2009 Author Share Posted March 11, 2009 ok i have been here http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/uploading-files-to-mysql-database.aspx am slowly narrowing it down. Some images are messing up the sql if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $fp = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp); $contents = "'".$content."'"; $query = "INSERT INTO persons (photo) VALUES ('".$contents."')"; echo $query; and when i upload a file i get this INSERT INTO persons (photo) VALUES (''GIF89a4\00\0÷ÿ\0´\0ýzýqý}\0ÓŠt¦„x·–Šý…\0ZJým\0–!ýiýYî‘Tò*\0ý™FS\0¼\"\0ýÄýa\0ýŽEý ÔÍÉ›?Ô¼´“jZý‘@ ñk:DÖÐËý¢ì*\0ýµ”\0ý¥ƒÇ³ªõÄ0þ1\0UÍų#ý•Ÿ{mÌ*ã,ý¨{ȸ±sD7ýž: \0Ü+\0ïÃUý±áÉ™ÞȪýQ\08\0ì´fuÔ+¬#ýF\0ýV\0ýf\0¼¤™Ä#\0Ó%\0ýB\0ýÊåˆCý=\0[ýK\0ýL\0ÐÊÇýT\0÷¶&Aýˆ\0ý^\0Ù4k\0ý8\0ì0ýºAý@\0÷l\'ý\\\0ýt\0I< <ý>\0ý‚\0ýw\0Mþ.\0‹ýd\0ý‹\0B \0ýH\0ýO\0ý€\0ý¾ýÔé·ubf5&> \0W(ýR\0Ì$\0ÔÒÑG}ýD\0ý:\0ò2ÐÀ¹ù– \0ª\0þ6\0L ìÁk=ý4\0ÿ4\0K\0;\0Ùͼ⩑Û&\0÷/\0ô‡6ý^ý‰D¬£Ù¹; pý6Bú57\0= \0ýIù1¡\"ýDCþ;9 \0Š\0Ýʲÿ:`f\0ýUÌ¿»ýOߺ¢ýc=ý€ŸugýwçÒxI ®ƒþ?Â(9\07\0ý>€\0ÿ8þ8F\0ýK¿¨ ýLý=gý„ýGýPýSD\0þV\0Ø»¯Oþ^\0ú¢k+GûÇCÿ7´\'k½(ÐÅÀä›{ØÆÁúG½>!ÜÆ´ì¨c㯌丑þQ\0R@ \0ý8þL\0¨J3^/\"ø*\0ûª÷Š(÷›&♂`/ ë}PÕ°¤þH\0Óµ©Ýµ§Øµ©ý[yK@ü7ýgýe\0 pA2ú¿>ýŠõZ&ü¸ `B\0AÔÔÔ!ù\0\0ÿ\0,\0\0\0\04\00\0\0ÿ\0ÿ H° Áƒ*\\ˆ¥ ïÖmøÃ\"Ë1 «¦îƒ¾kò]Á&Á+_,0ª$˜gU/Ǻ…c—„Ì DŽI4#‚·x³¢¬dbÛ£j(Xa@ÄÍ>]² r€¤E ¾m²ó\"ÕP„«Ì™# A¥Dî@’¤É #ð…%‘1š°øU mÊ\0&Ò¥RÜ´*ÕŽ¹œ°ñ‡OÌ 4úf;·¦Š`†éYùB¤Ç¶¡ÞÆÀ#ˆ.¯o i%kÖP€:T¨r`p᳤M³m’åšH\0”ÀZ§R¥1ø* ’Ç2t{~ºˆ•ÒkÛfÿQÆιø±uãtéÔf+\'†‹ p/|˜(mˆG^G´V—ì!›Ó-Âõ=àB}ÆŸˆ95D}WrËE`{ÏâuL¢ÐÈ C}÷y6€e—VxÄG•r38Q‚îÉÆ…ãuÐ$ ËÙU ý ’·c3¨§‰(¢TÒ >ôcå1 ˜€Ý}‘ôF£aú\'œxÆ‘£S ¹œÂ‹&·$h\"\\àƒ‚A;læ‹Øi§_\0oÚ¨V€9¢±š‰Øâƒ7”è• PP)Àah‹jN¸F`3ÖHAp8Žwk!ZÿŠ©—„É…,ÄâêТîææ…K5uZ¡¸—rX)²e¦ ÔÚ(u¼@Pº¤šÁÊ8Vh«‚7œ²x0ëÄ&}f:†´LxN…¯J¦ ,›‹’•\0=á>ZSqå%‡¥@z &L‡WoÚ’¬®Á+ƒòÀ2õ¦¹&~«Êê¸8±Ó¿(«7SÇ,¹.2o¯¿JH!ÅM—v,qSYÈüXp: 0¡z3<3 ÿä‘ÃÚúÕš: %`_hñŠã‡ªd`NŸðìà(ÈDU/D™/Â@Û澃±)IEAhÁrV\0Š :ðÔ@BpÙ‘êyôílÔ¹)ãZ€ ÿ-ÁB.`\"kÅÃ_ÝîFB(ÉWI»×ùf¶C À£4¿F€±Ä\0BH’a#遲€$è\0/‚,b:€\"·LU…ý¤Í?ê‚[:ƒZxâÁ8ƒ1†‚ ®N°A ´9N‘0¶K PAŒõ bpÓø£)Â`ŒâYz0ò CÁìMòVY`±b(¦-ºðC¦¡\0†ÁTb3š‚A!„P$Û#+Æ*-ºÅB¬ÃðÉî!ÒZ ‘Ì°Ó¤Hc?¶ã×+¹¡P\\Bµc0’%ZPý°ÿòóU Öt…æŠÀŠ†}ÈjQÿKSœ™‡Ôì‘’‹ü@7m†+\0‹U²x„\'¶ FC™+\0h3ô t%rÀO<\0þ at the end we are missing a ") how can i stop it from doing this? Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782123 Share on other sites More sharing options...
adam291086 Posted March 11, 2009 Author Share Posted March 11, 2009 it wont even let me concatenate things to the end of the variable Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782152 Share on other sites More sharing options...
rhodesa Posted March 11, 2009 Share Posted March 11, 2009 try this: <?php if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $content = file_get_contents($tmpName); $content = mysql_real_escape_string($content); $query = "INSERT INTO persons (photo) VALUES ('".$content."')"; echo $query; } ?> Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782164 Share on other sites More sharing options...
adam291086 Posted March 11, 2009 Author Share Posted March 11, 2009 solved it by doing $binary = file_get_contents($_FILES['photo']['tmp_name']); $binary = base64_encode($binary); then injected that into an sql statement. thanks for the help Link to comment https://forums.phpfreaks.com/topic/148952-solved-php-and-medium/#findComment-782170 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.