Downloading Blob from MySQL Database to its original format with PHP -
Downloading Blob from MySQL Database to its original format with PHP -
i'm trying create website can upload file , afterwards can download local computer. i'm doing storing the file in blob , storing size of file , mime type of file well, working expected.
what want download blob of info , restore original format. illustration if uploaded test.docx file in database can download test.docx before.
i managing create download problem i'm having it's downloading html in page , blob bin (a lot of symbols).
download.php
<html> <head> <title>download file mysql</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $dbuser = "root"; $dbpassword = "root"; $dsn ='mysql:host=localhost;dbname=filerepository'; $dbh = new pdo($dsn,$dbuser,$dbpassword); $query = "select id,title foldersfiles"; foreach($dbh->query($query,pdo::fetch_assoc) $row) { ?> <a href="download.php?id=<?php echo $row['id'];?>"><?php echo $row['title'];?></a> <br> <?php } if(isset($_get['id'])) { $query2 = "select title,format,content,filesize foldersfiles id = ?"; $sth = $dbh->prepare($query2); $sth->execute(array($_get['id'])); $result = $sth->fetchall(pdo::fetch_assoc); foreach($result $row) { $size = $row['filesize']; $type = $row['format']; $title = $row['title']; $content = $row['content']; } require_once('/var/www/uploadfile/downloadfile.php'); download($size,$type,$title,$content); } ?> </body> </html> downloadfile.php
<?php function download($size,$type,$title,$content) { header("content-length: $size"); header("content-type: $type"); header("content-disposition: attachment; filename=\"$title\""); echo $content; } i have split them because there similar problem fixed doing still having problem.
i using ubuntu os develop website, might impact it? when download file doesn't download in format.
data beingness downloaded
<html> <head> <title>download file mysql</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> </head> <body> <a href="download.php?id=46">main</a> <br> <a href="download.php?id=65">ice</a> <br> <a href="download.php?id=66">php</a> <br> <a href="download.php?id=67">national diploma year 2</a> <br> <a href="download.php?id=68">national diploma year 1</a> <br> <a href="download.php?id=73">semester 1</a> <br> <a href="download.php?id=74">object orient programing</a> <br> <a href="download.php?id=75">presentations</a> <br> <a href="download.php?id=76">homework</a> <br> <a href="download.php?id=106">test</a> <br> <a href="download.php?id=108">test</a> <br> <a href="download.php?id=109">main</a> <br> <a href="download.php?id=111">file repository</a> <br> <a href="download.php?id=114">documentation</a> <br> <a href="download.php?id=115">documentation</a> <br> <a href="download.php?id=125">test</a> <br> pk\0\0\0\0\0!\02‘owf\0\0¥\0\0\0[content_types].xml ¢( \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0´”ËjÃ0e÷…þƒÑ¶Øjº(¥ÄÉ¢ehúŠ4ndõb£¼þ¾ã81¥$14ÉÆ ÏÜ{Ï1ƒÑÚšl µw%ë=–“^i7+Ù×ä-d&á”0ÞaÉ6€l4¼½l60#µÃ’Ís oœ£œƒxø\0Ž*•v$:Æb~‹ðû^ïk︔§Úƒ /p‰…iÙëš~7$²ì¹i¬³j&b0zŠdu¾têoj¾k(h¹íÁ¹xg Œl¨+Çvººš¨dcÓ»°ÔÅw>*®¼\\xr§mpúªÒz}í¢—€hwnmÑv¬ÐnÏ”Ã-ì\")/Òzwb`ÚÀË4¾Ýñ ®°sîdxÁôój¿Ì;a*ʈ©Ëc´Ö‰Ö\04ßþÙ[›s‘Ô9Ž> •ø±÷{£vç4p€˜ôéw×&’õÙóa½’¨Ù|»d‡?\0\0\0ÿÿ\0pk\0\0\0\0\0!\0‘·ï\0\0\0n\0\0\0_rels/.rels ¢( \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0¬’ÁjÃ0@ïƒýƒÑ½qÚÁ£n/cÐÛÙ[ilÛØj×þý<ØØ]éagËÒÓ“Ðzsœfuà”]ð–u Š½ Öù^Ã[û¼x\0•…¼¥1xÖpâ›æöfýÊ#i)ʃ‹yŠÏ‘øˆ˜ÍÀå*döå§i\")ÏÔc$³£žqu×÷˜~3 ™1ÕÖjh[{ª=e¾†ºÎ~ f?±—3-ÂÞ²]Ätꓸ2j)õ,l0/%œ‘b¬ ð¼Ñêz£¿§Å‰…, ¡ ‰/û|f\\zþçŠæ?6ï!y´_áoœ]aó\0\0ÿÿ\0pk\0\0\0\0\0!\0³¾‹\0\0¶\0\0\0word/_rels/document.xml.rels ¢( \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0¬“ÍjÃ0„ï…¾ƒØ{-;mc ‘s)\\[÷d{ýcõc¤mz¿}ej‡ÓƒŽ3bg¾…Õzó; ó½5²$†¦²uozÅöá˜\'ij©¬a#zØä÷wë7t’ÂïúÁ³b¼€Žhxqô‰Ð„—Æ:-)h×òavŸ²e¾hÓ%wÓȯ2Ù®àvõ#°bð?Ù¶iú _mµ×hèf÷h6ó!sºiÀÉibðÛ‹¨4*œõ\\}³Þìu‰.l|!8[s˘fñp”¿f6Çð“¡±† yª ÇÙšƒxŠ ñ…åûŸ“œ˜\'~õÛò\0\0\0ÿÿ\0pk\0\0\0\0\0!\0k”¸ÄÅ0\0\0ž4\0\0\0\0word/document.xmlì}ëŽã¶¶æÿæ„š?`\'-rÔæ$gtmé=én‚ó+pÙ¬²vÛ’¤êjå×~Œ3Àpžå<Ê~’!)Ë%«lëbٖ啽Ñ*s²lr}ëÊÅÅù×?sémÒ0Ž¾½aßÈ7&ñ4Œ¾½ùõ“ÿµq#¥ymƒyÑoožizó¯ßý÷ÿö/o·Óxò¸ q&±wdéíÓròíÍ,Ë–·oߦ“]é7‹p’Äi|Ÿ}3‰oãûûpbß>ÅÉô-–‘,þz&ñ„¦)û=\'ˆ¾éÍêu‹×o‹—4b7ïãddìcòðv$Ÿ—_³·/ƒ,¼çaöÌÞ-kÅkâoo“èvõŠ¯×â_¹Í;´ºßhšünþw5âß&tÎúgé,\\¾£ëÛØÍyñ’/ûñe1/ž{z\"r Ü$xb——6éþ4ÿÒbž÷|ÿ‘Ü€\"üëo4éÂæo=yaôòæ¦4¹hm÷\\}Áòá0â|ŸÄË—·…‡½í]ôyý.ÎÙ-Þµ\"ryhéaù8–Œ“ÛwqœwsÖ#f2‰ÍºÄa}ó“8wñô™_—¬™Ü.ƒ$x7ýöf³lkÖ-óf´fôÏŒ·ê«ÿxë-“nÓ_¾½‘eog²j›>$¼Ñt0bںѥ÷Áã<{ýø‡r“èŇ„_Òe0a#`÷åoä_˜‡|n1yøå‘)xÌâ›·ükŸ°_‚ù·7Æó4É[“ü‰gyÊ_™nbfçô!¦Ò¯ïøËhfvßÞ| 4•~¦oÒ/ñ\"ˆøÍ™¥•ç\'ié³ø‘ô¯â§1)zþk¥¶·«¾¼]3Ù:k\'ëô]þ¯“Šë$žÇ¼c¢Ç²ø¯:6e{=¶¼ÛÓÐ]‚‚Œ6Ë„¦4ùbo¾ói=²o4Ë¿oÅnôq”œ}Ñã\"ÿ#œ™¯\'$9»÷nz´¡ÕÈ×_èˆ[>bk>dbõ¯^~¤”?|b7@\0v¶ [´ ݽŒ†cõ×å<¦Íqkn·À?eíë\0r¹@î‡$üÎémß| éÓ[: ³¯šÃØŒ\0cæ%ŒªÃÄü·pÞÃ`0|~owæœxÁ©•jq$e3*ÝÇó)mr)ˆ¦rÂlãéù\0v\0û,æ ¤y¸³€g9¼i0™i÷ß4†³ÍÉp8ŸÎ>³¡¥e/i’…Ì–¾çŸÓð/Úܱ`°<,\'ôkÈwuséÍ$^2hkñ½Äli {µäš¶@7îݲg,Ïtº›£{»•ý>~xà¤Þ€siÌuà¼<&¾ge®²„ –¶0»”þ™t0s?Ìü+»j¿Ð‡0Írd7wmÀ`Åû)ˆ‚*’ªò°ôñ9Íè¢9œu€3Ày¨rz`<}¼k\'i¸l)§94Ø\0쳯;Ñ ™Ì]›c—ƒô‚2ýnb.9}{\'Ùè’eÖœºhÃ\'¹o¾4n]†“l \"ˆ&³8y£ÅÐtfÂ/· e÷cÖúÇŸü\'þ‘Œu¾ày¤ó†Ólv+ÿÏ fÙ-úf]f7r|;k.ž×‰°¢)ÍØkv·ÅÌÕž‹a|{ó?™ÿ¿8‰?söàýªŸ¼ƒdg!ˆ#‹>4É‘Ý®Ówù¿\'ÉÈ手ôöàÓzñjØ`ÝÚý¥cóhÚ$ˆ¤ibƒŒò”0‘â§hzà›yšzðÙ®\0è«\0´w¤˜hoÌ “fÁzúk¦Üb~ko3š°6*@ÜŸ†÷÷¬6xÄì2¥kñͦ<}e?i‹gö~ö•eðÜf9eðy´ÀwÁ<\"—jƒ}šÅ rxÇÍ9†g2,‘Îøƒ¬eÁx(›ik/ç´êw>z˜—†ÁÝ>ºq³Ëg×食+Ñöš|t‡|tðÑ‹ÖcvmÝ×x{9ƒÏÖ,$+Ølc„vo6Û»{é9~\\ycÁjˆ0Ÿ&¾—b6\0žå•ïiïÖÛg¸Ç¿2•8¥anØwž›ãÿùœ€À\'Ÿeòe1‰ ó,aÏ%¸g¯§æ“ÿ%nkÍŸ¥gqe€1Ë„&yfy\"d^g Ëû¬š{3Îàs\"®jäy5wÌc…¿rüžˆx=ÐlŠâ,¼™ï™‚x–&³ z`Ýg_ 3¡2¸a¯zo;œË%z°Åà*-®‚-~pŸb7`¬±Þ-.±ùûcÊ0/-ã%s<ú f™Çl\'´@üàs.ñwø)]2< please tell me if need more info might help :d
that info seems ok; it's ascii/utf8 interpretation of binary info remember cannot send header() if there other echo/print
so wanna place output above html start tag end end die();
php mysql download blob
Comments
Post a Comment