tag:blogger.com,1999:blog-36139144381078267722024-02-21T12:42:03.871+08:00lipatdua : Me trying to do something...lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3613914438107826772.post-88354599395557056002009-02-25T15:18:00.003+08:002009-02-26T11:43:16.356+08:00BLOBing me...<p>i always wanted to put files(images, pdf etc..) in MySQL database. Yesterday i manage to have the time to google it on the web...and found it at <a href="http://www.devarticles.com/c/a/MySQL/Blobbing-Data-With-PHP-and-MySQL/">devarticles</a>...modified it and succesfully test it....but then...when it comes to non-image files...it will download the php file...not the actually file...again...google it..found it at <a href="http://www.aprelium.com/forum/viewtopic.php?t=13803">here</a>...modified it...and finally succesfully test it...here is how..<br />but first..make sure these are set in your php.ini (by <a href="http://my.php.net/manual/en/function.phpinfo.php">phpinfo()</a> it): </p><ol><li><strong><span style="color: rgb(0, 255, 255);">file_uploads</span></strong> = <span style="color: rgb(0, 255, 0);">On</span> (to allows upload thru php) </li><li><b><span style="color: rgb(0, 255, 255);">upload_max_filesize</span> = </b><span style="color: rgb(0, 255, 0);">?M</span> (maximum file size allowed to be upload to the webserver eg. 2M = 2MByte file size)..i set it to 16M.. </li><li><b><span style="color: rgb(0, 255, 255);">upload_tmp_dir</span></b><b> = </b>the location where php will store the uploaded file temporary in your webserver.. </li></ol><p>and in your MySQL my.cnf </p><ol><li><span style="color: rgb(0, 255, 255);">max_allowed_packet</span> must same value with PHP's<span style="color: rgb(0, 255, 255);"> upload_max_filesize</span> value...else..your will get mysql error like "<em>MySQL server has gone away</em>" or "<em>increase max_allowed_packet</em>" message...<a href="http://dev.mysql.com/doc/refman/5.0/en/gone-away.html">here</a> for detail explaination.. </li></ol><p>Secondly, run this script in your MySQL database :<br /></p><pre style="border: 1px solid rgb(0, 128, 64); padding: 5px; overflow: auto; min-height: 40px; width: 350px; background-color: rgb(255, 255, 255);"><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=create&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">create</a> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=database&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">database</a> myFiles;<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=use&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">use</a> myFiles;<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=create&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">create</a> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=table&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">table</a> myBlobs<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;">(<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"> blobId <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=int&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">int</a> auto_increment <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=not&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">not</a> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=null&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">null</a>,<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"> blobTitle <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=varchar&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">varchar</a>(50),<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"> blobData longblob,<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"> blobType <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=varchar&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">varchar</a>(50),<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"> blobFileName <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=varchar&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">varchar</a>(255),<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=primary&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">primary</a> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=key&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">key</a>(blobId),<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"> <a style="color: rgb(0, 0, 255);" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=unique&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">unique</a> id(blobId)<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;">);</pre></pre><p>and now…create 4 php files and paste these code in it…</p><p><strong>1 - getfiles.php<br /><br /></strong></p><strong><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjG_IgvkFKdsWL7MpyHK0FBxHCWYcmFpmZRO97H9yGxpeaNUWaL-ZMKEs3FHfToAiBBdkmKeO2CFWnYd7k0smR-T6Cp55YqDHr0d7oiFfaX5lprfcHjbwytBZjg41i7p0aNCSP_m2TrMW0/s1600-h/blob_20022009_145148%5B28%5D.gif"><img title="blob_20022009_145148" style="border: 0px none ; display: block; float: none; margin-left: auto; margin-right: auto;" alt="blob_20022009_145148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghh253sjUua_k16G4_136wA_5vT2Hz1YEeqA8OI_XUN19DdnUaXzXHr1S_GXbTMnAq_q3fpb-S4pCrsCsc5dLzXs5aNgRD1bcmHyNhVbTRKXAb7Xs3Sp0Owk2KIn3MA8Y61HW2NlGGLFo/?imgmax=800" border="0" width="456" height="491" /></a> </strong><br /><pre style="border-top: 1px solid rgb(0, 128, 64); border-left: 1px solid rgb(0, 128, 64); border-right: 1px solid rgb(0, 128, 64); padding: 5px; overflow: auto; min-height: 40px; width: 500px;"><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">html</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">head</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">title</span><span style="color: rgb(0, 0, 255);">></span> Upload a File <span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">title</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">head</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">body</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">form</span> <span style="color: rgb(255, 0, 0);">enctype</span>=<span style="color: rgb(0, 0, 255);">"multipart/form-data"</span> <span style="color: rgb(255, 0, 0);">name</span>=<span style="color: rgb(0, 0, 255);">"frmUploadFile"</span> <span style="color: rgb(255, 0, 0);">action</span>=<span style="color: rgb(0, 0, 255);">"grabfile.php"</span> <span style="color: rgb(255, 0, 0);">method</span>=<span style="color: rgb(0, 0, 255);">"post"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">a</span> <span style="color: rgb(255, 0, 0);">href</span>=<span style="color: rgb(0, 0, 255);">"http://www.devarticles.com"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">img</span> <span style="color: rgb(255, 0, 0);">border</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">src</span>=<span style="color: rgb(0, 0, 255);">"http://www.devarticles.com/dlogo.gif"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">a</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">table</span> <span style="color: rgb(255, 0, 0);">border</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">cellpadding</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">cellspacing</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">bordercolor</span>=<span style="color: rgb(0, 0, 255);">"#111111"</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"100%"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"100%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FF9900"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"22"</span> <span style="color: rgb(255, 0, 0);">colspan</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span> <span style="color: rgb(255, 0, 0);">color</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;">Upload a File<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"100%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span> <span style="color: rgb(255, 0, 0);">colspan</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10; margin-right: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">br</span><span style="color: rgb(0, 0, 255);">></span>Please select a file from your local computer to upload to our web server<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;">for saving in our database. This file can be of any type you like. Once you<br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;">have chosen a file, please click on the &quot;Upload this file&quot; button below.&nbsp;<br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;">&nbsp;<span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">br</span><span style="color: rgb(0, 0, 255);">></span>&nbsp;<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"15%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;">File Description:<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"85%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">input</span> <span style="color: rgb(255, 0, 0);">type</span>=<span style="color: rgb(0, 0, 255);">"text"</span> <span style="color: rgb(255, 0, 0);">name</span>=<span style="color: rgb(0, 0, 255);">"strDesc"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"20"</span> <span style="color: rgb(255, 0, 0);">maxlength</span>=<span style="color: rgb(0, 0, 255);">"50"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(39, 39, 39);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"15%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span>File Location:<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"85%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">input</span> <span style="color: rgb(255, 0, 0);">type</span>=<span style="color: rgb(0, 0, 255);">"file"</span> <span style="color: rgb(255, 0, 0);">name</span>=<span style="color: rgb(0, 0, 255);">"fileUpload"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"20"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; color: rgb(0, 0, 0);font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"33%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">br</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">br</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);">&nbsp;<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"67%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFE3BB"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">input</span> <span style="color: rgb(255, 0, 0);">type</span>=<span style="color: rgb(0, 0, 255);">"submit"</span> <span style="color: rgb(255, 0, 0);">value</span>=<span style="color: rgb(0, 0, 255);">"Upload this file"</span> <span style="color: rgb(255, 0, 0);">name</span>=<span style="color: rgb(0, 0, 255);">"cmdSubmit"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">table</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">form</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">body</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">html</span><span style="color: rgb(0, 0, 255);">></span></pre></pre><strong>2 - grabfile.php<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6NHptGnuAu7TmB4Jm5d6IloVd5eMYRrGCNCOZVA8OMU7BvuvJBjsr97ztDa3UiYX1aWj7nE2QfbYvKxAd3UFZSsgplVtWSP2rmDF7fhOH5iga5nJtgZxTlmprmgZRD8IAH9QRZ-vHfYA/s1600-h/blob_20022009_145155%5B8%5D.gif"><img title="blob_20022009_145155" style="border: 0px none ; display: block; float: none; margin-left: auto; margin-right: auto;" alt="blob_20022009_145155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg73Gnf_dzJvRn2mWzQobSC4H7yyzQRlBsUXAsdqQI8-9hi3yjaT9iLGXno7ijUG5APs5CRoyPq3ioLdUaCNDCpv9XUnkZmAVcud7GSyNLD_YvBxvCetTChDkaWmbiVrFk4OxuDOnDfplc/?imgmax=800" border="0" width="456" height="491" /></a> </strong><br /><pre style="border-top: 1px solid rgb(0, 128, 64); border-left: 1px solid rgb(0, 128, 64); border-right: 1px solid rgb(0, 128, 64); padding: 5px; overflow: auto; min-height: 40px; width: 500px;"><pre size="12px" style="margin: 0em; color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"><?</span>php<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"><span style="color: rgb(0, 128, 0);">// GrabFile.php: Takes the details</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"><span style="color: rgb(0, 128, 0);">// of the new file posted as part</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"><span style="color: rgb(0, 128, 0);">// of the form and adds it to the</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"><span style="color: rgb(0, 128, 0);">// myBlobs table of our myFiles DB.</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$strDesc = $_POST['<span style="color: rgb(139, 0, 0);">strDesc</span>'];<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);">$fileUpload = $_FILES['<span style="color: rgb(139, 0, 0);">fileUpload</span>']['<span style="color: rgb(139, 0, 0);">tmp_name</span>'];<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$fileUpload_name = $_FILES['<span style="color: rgb(139, 0, 0);">fileUpload</span>']['<span style="color: rgb(139, 0, 0);">name</span>'];;<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);">$fileUpload_size = $_FILES['<span style="color: rgb(139, 0, 0);">fileUpload</span>']['<span style="color: rgb(139, 0, 0);">size</span>'];;<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$fileUpload_type = $_FILES['<span style="color: rgb(139, 0, 0);">fileUpload</span>']['<span style="color: rgb(139, 0, 0);">type</span>'];;<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/if">if</a>(empty($strDesc) $fileUpload == "<span style="color: rgb(139, 0, 0);">none</span>")<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(39, 39, 39);"> <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">You must enter both a description and file</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"><br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" ><span style="color: rgb(0, 128, 0);">// Database connection variables</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$dbServer = "<span style="color: rgb(139, 0, 0);">localhost</span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$dbDatabase = "<span style="color: rgb(139, 0, 0);">myFiles</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$dbUser = "<span style="color: rgb(139, 0, 0);">root</span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$dbPass = "<span style="color: rgb(139, 0, 0);"></span>";<br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$fileHandle = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/fopen">fopen</a>($fileUpload, "<span style="color: rgb(139, 0, 0);">r</span>"); <span style="color: rgb(0, 128, 0);">//open the uploaded file from temp location</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);">$fileContent = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/fread">fread</a>($fileHandle, $fileUpload_size); <span style="color: rgb(0, 128, 0);">//reads the content of the file</span><br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$fileContent = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/addslashes">addslashes</a>($fileContent); <span style="color: rgb(0, 128, 0);">//add backslash "\" to escape character ',",\,NUL to save in db</span><br /></pre><pre style="margin: 0em; font-size: 12px; color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$sConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_connect">mysql_connect</a>($dbServer, $dbUser, $dbPass)<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" >or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database server</span>");<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" ></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" >$dConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_select_db">mysql_select_db</a>($dbDatabase, $sConn)<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database $dbDatabase</span>");<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" >$dbQuery = "<span style="color: rgb(139, 0, 0);">INSERT INTO myBlobs VALUES </span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" >$dbQuery .= "<span style="color: rgb(139, 0, 0);">(0, '$strDesc', '$fileContent', '$fileUpload_type','$fileUpload_name')</span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" ></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_query">mysql_query</a>($dbQuery) or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't add file to database<br/></span>".<a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_error">mysql_error</a>());<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#272727;" ></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><h1>File Uploaded</h1></span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);">The details of the uploaded file are shown below:<br><br></span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><b>File name:</b> $fileUpload_name <br></span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><b>File type:</b> $fileUpload_type <br></span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><b>File size:</b> $fileUpload_size <br></span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><b>Uploaded to:</b> $fileUpload <br><br></span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><a href='getfiles.php'>Add Another File</a></span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"><br/><a href='showfiles.php'>Show File List</a></span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><span style="color: rgb(0, 0, 255);">?></span></pre></pre><strong>3 - showfiles.php<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKbIj0T5Z-zhajLZJBpKQtbyGu5AvW0l9pfjLxgSg3SR9ICiemjycEBEAAgkYYr9-RY_DOfXPqcMYWKKGlDsrWR_Vcu_9bXaRvdi1C8oqt_mXFnf1rMLMwENmhy_Fp0srizQeqUOQpV1I/s1600-h/blob_20022009_145346%5B10%5D.gif"><img title="blob_20022009_145346" style="border: 0px none ; display: inline;" alt="blob_20022009_145346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiELHQcyo2KaReKljWxsnNKx7tTPDLpvkx27h0E83j78ZIWUX08Nk5xbJzerVJZoGC9TdlkFltPpvOtt6b31Nz3IscmW_QuOyNcxGMA-Tuf1v2dFTDP5QC-96az86_GL0NtLFom2yqHxRU/?imgmax=800" border="0" width="509" height="387" /></a><br /></strong><br /><pre style="border-top: 1px solid rgb(0, 128, 64); border-left: 1px solid rgb(0, 128, 64); border-right: 1px solid rgb(0, 128, 64); padding: 5px; overflow: auto; min-height: 40px; width: 500px;"><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" ><span style="color: rgb(0, 0, 255);"><?</span>php<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><span style="color: rgb(0, 128, 0);">// Database connection variables</span><br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" >$dbServer = "<span style="color: rgb(139, 0, 0);">localhost</span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">$dbDatabase = "<span style="color: rgb(139, 0, 0);">myFiles</span>";<br /></pre><pre style="margin: 0em; width: 100%;font-family:consolas,'Courier New',courier,monospace;font-size:12px;color:#000000;" >$dbUser = "<span style="color: rgb(139, 0, 0);">root</span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">$dbPass = "<span style="color: rgb(139, 0, 0);"></span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000">$sConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_connect">mysql_connect</a>($dbServer, $dbUser, $dbPass)<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database server</span>");<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000">$dConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_select_db">mysql_select_db</a>($dbDatabase, $sConn)<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database $dbDatabase</span>");<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000">$dbQuery = "<span style="color: rgb(139, 0, 0);">SELECT * </span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">$dbQuery .= "<span style="color: rgb(139, 0, 0);">FROM myBlobs </span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000">$dbQuery .= "<span style="color: rgb(139, 0, 0);">ORDER BY blobTitle ASC</span>";<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727">$result = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_query">mysql_query</a>($dbQuery) or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't get file list</span>");<br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000"><span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">a</span> <span style="color: rgb(255, 0, 0);">href</span>=<span style="color: rgb(0, 0, 255);">"http://www.devarticles.com"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">img</span> <span style="color: rgb(255, 0, 0);">border</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">src</span>=<span style="color: rgb(0, 0, 255);">"http://www.devarticles.com/dlogo.gif"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">a</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">table</span> <span style="color: rgb(255, 0, 0);">border</span>=<span style="color: rgb(0, 0, 255);">"1"</span> <span style="color: rgb(255, 0, 0);">cellpadding</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">cellspacing</span>=<span style="color: rgb(0, 0, 255);">"0"</span> <span style="color: rgb(255, 0, 0);">bordercolor</span>=<span style="color: rgb(0, 0, 255);">"#111111"</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"100%"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"25%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FF9900"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#272727"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">color</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000">Description<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"25%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FF9900"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span> <span style="color: rgb(255, 0, 0);">color</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">Type<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%;" size="12px" face="consolas,'Courier New',courier,monospace" color="#000000"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"25%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FF9900"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span> <span style="color: rgb(255, 0, 0);">color</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">Filename<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"25%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FF9900"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"2"</span> <span style="color: rgb(255, 0, 0);">color</span>=<span style="color: rgb(0, 0, 255);">"#FFFFFF"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">Download<span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">b</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><?</span>php<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/while">while</a>($row = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_fetch_array">mysql_fetch_array</a>($result))<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">{<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"34%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFDCA8"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10; margin-right: 10"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"1"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><?</span>php <a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);">&nbsp;</span>".$row["<span style="color: rgb(139, 0, 0);">blobTitle</span>"]; <span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"33%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFDCA8"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"1"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><?</span>php <a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> $row["<span style="color: rgb(139, 0, 0);">blobType</span>"]; <span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"33%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFDCA8"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"1"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><?</span>php <a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> $row["<span style="color: rgb(139, 0, 0);">blobFileName</span>"]; <span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">td</span> <span style="color: rgb(255, 0, 0);">width</span>=<span style="color: rgb(0, 0, 255);">"33%"</span> <span style="color: rgb(255, 0, 0);">bgcolor</span>=<span style="color: rgb(0, 0, 255);">"#FFDCA8"</span> <span style="color: rgb(255, 0, 0);">height</span>=<span style="color: rgb(0, 0, 255);">"21"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">p</span> <span style="color: rgb(255, 0, 0);">style</span>=<span style="color: rgb(0, 0, 255);">"margin-left: 10"</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">font</span> <span style="color: rgb(255, 0, 0);">face</span>=<span style="color: rgb(0, 0, 255);">"Verdana"</span> <span style="color: rgb(255, 0, 0);">size</span>=<span style="color: rgb(0, 0, 255);">"1"</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"><</span><span style="color: rgb(128, 0, 0);">a</span> <span style="color: rgb(255, 0, 0);">href</span>=<span style="color: rgb(0, 0, 255);">"downloadfile.php?fileId=<?php echo $row["</span><span style="color: rgb(255, 0, 0);">blobId</span>"]; ?<span style="color: rgb(0, 0, 255);">></span>"><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">Download now<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">a</span><span style="color: rgb(0, 0, 255);">></span><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">font</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">td</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);"></</span><span style="color: rgb(128, 0, 0);">tr</span><span style="color: rgb(0, 0, 255);">></span><br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);"><?</span>php<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;">}<br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);"></table></span>";<br /></pre><pre style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);font-family:consolas,'Courier New',courier,monospace;font-size:12px;"><span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"></pre></pre><strong>4 - downloadfile.php<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7WQIrxDD-0upOZFpwGntjMWgK1kMl2ZkLxXHE6Vkokq7mLIn3JlmRbOXG78wmYeLSL5nUeDBTfhrE8PDcXRRGktAlDl2UaRRlNxqk-DvQgnB5YogR-9Wp4Amzm3OhbiJKrsqIUu3leqM/s1600-h/blob_20022009_145414%5B5%5D.gif"><img title="blob_20022009_145414" style="border: 0px none ; display: inline;" alt="blob_20022009_145414" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGmGAeLcZUK5UK7MJ1noXHk3rf98G_C4gPKFpWV1RPttvJZZ6Baf_Tugmd1b03Qw3Tr40xYGN74r8o3LuU3W0EdRmtgq3kJJJjclrATQkH30mZNf0k2Z3HLX8J3R-zOa9bL2T7A7aFY_Q/?imgmax=800" border="0" width="513" height="390" /></a><br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgArAVD2ijiWhcWfAH8e3izbXGah9poXTvKzThtoqLUZ136qA4h6GIfwwxwrHPxjKgtvZDD9hT8NacMsxGkJ0JHXY641FyuH6hgYnh_e9H7ios0uUkIdcsefBFy_73aY36Xh2dO8JkzpbE/s1600-h/blob_20022009_145405%5B3%5D.gif"><img title="blob_20022009_145405" style="border: 0px none ; display: inline;" alt="blob_20022009_145405" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6U6QK1_vkx827pBsa19_shz896SsptzzrP9ZAuY3OXS9zeFQylmD2X3bWnpUq05B8sN9Rrr4-J9El0EpnwlrKuU0OOy0Jbqr42n8akhXZT9RrHMoNP-Lw-ymEPWQqSUONg0kwOIi62VI/?imgmax=800" border="0" width="521" height="415" /></a><br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguFjQqPNRNVlYb-K5H2CE3ZASw13_cA_Z2fH_eMhse9fL4dZmENp2ixjuaa7OwsyjqjeJsu8L1tqR_Da7zm73vc9wm38rMcDZoh7mw3kyMZnKcq4YoROwqe0n6AY30ybACXZ2UwODltZc/s1600-h/blob_20022009_145434%5B3%5D.gif"><img title="blob_20022009_145434" style="border: 0px none ; display: inline;" alt="blob_20022009_145434" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgf_sGza320X2-5TpVLvkCxZTAUC9WxCeDFPka0ERUBobiC-QrIig-6l6usyDXs-7SQgn0oYOffmaIEq21KkIVIzjNf20PzRyfiz7bj1Ph_vwXX7g-vioSXMMX_jVQFCIn1nUmOYxgYfRc/?imgmax=800" border="0" width="525" height="496" /></a><br /></strong><br /><pre style="border-top: 1px solid rgb(0, 128, 64); border-left: 1px solid rgb(0, 128, 64); border-right: 1px solid rgb(0, 128, 64); padding: 5px; overflow: auto; min-height: 40px; width: 500px;"><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 255);"><?</span>php<br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);">$blobId = $_GET['<span style="color: rgb(139, 0, 0);">fileId</span>'];<br /></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(39, 39, 39);"></pre><pre face="consolas,'Courier New',courier,monospace" size="12px" style="margin: 0em; width: 100%; background-color: rgb(0, 0, 0);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/if">if</a>(!<a style="color: rgb(255, 165, 0);" href="http://www.php.net/is_numeric">is_numeric</a>($blobId))<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Invalid blobId specified</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"><span style="color: rgb(0, 128, 0);">// Database connection variables</span><br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">$dbServer = "<span style="color: rgb(139, 0, 0);">localhost</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">$dbDatabase = "<span style="color: rgb(139, 0, 0);">myFiles</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">$dbUser = "<span style="color: rgb(139, 0, 0);">root</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">$dbPass = "<span style="color: rgb(139, 0, 0);"></span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">$sConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_connect">mysql_connect</a>($dbServer, $dbUser, $dbPass)<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database server</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">$dConn = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_select_db">mysql_select_db</a>($dbDatabase, $sConn)<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't connect to database $dbDatabase</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">$dbQuery = "<span style="color: rgb(139, 0, 0);">SELECT * </span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">$dbQuery .= "<span style="color: rgb(139, 0, 0);">FROM myBlobs </span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">$dbQuery .= "<span style="color: rgb(139, 0, 0);">WHERE blobId = $blobId</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">$result = <a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_query">mysql_query</a>($dbQuery) or <a style="color: rgb(0, 0, 255);" href="http://www.php.net/die">die</a>("<span style="color: rgb(139, 0, 0);">Couldn't get file list</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/if">if</a>(<a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_num_rows">mysql_num_rows</a>($result) == 1)<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);">{<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> $<a style="color: rgb(255, 165, 0);" href="http://www.php.net/fileType">fileType</a> = @<a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_result">mysql_result</a>($result, 0, "<span style="color: rgb(139, 0, 0);">blobType</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> $fileContent = @<a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_result">mysql_result</a>($result, 0, "<span style="color: rgb(139, 0, 0);">blobData</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> $file_name = @<a style="color: rgb(255, 165, 0);" href="http://www.php.net/mysql_result">mysql_result</a>($result, 0, "<span style="color: rgb(139, 0, 0);">blobFileName</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Pragma: public</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Expires: 0</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Cache-Control: must-revalidate, post-check=0, pre-check=0</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Cache-Control: public</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Content-Description: File Transfer</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Content-Type: </span>".$<a style="color: rgb(255, 165, 0);" href="http://www.php.net/fileType">fileType</a>);<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> <a style="color: rgb(0, 0, 255);" href="http://www.php.net/if">if</a>($<a style="color: rgb(255, 165, 0);" href="http://www.php.net/fileType">fileType</a> == "<span style="color: rgb(139, 0, 0);">audio/mpeg</span>" $<a style="color: rgb(255, 165, 0);" href="http://www.php.net/fileType">fileType</a> == "<span style="color: rgb(139, 0, 0);">application/octet-stream</span>" )<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Content-Disposition: attachment; filename=\"$file_name\"</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"> <a style="color: rgb(255, 165, 0);" href="http://www.php.net/header">header</a>("<span style="color: rgb(139, 0, 0);">Content-Transfer-Encoding: binary</span>");<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> $fileContent;<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">}<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"><a style="color: rgb(0, 0, 255);" href="http://www.php.net/else">else</a><br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">{<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"> <a style="color: rgb(0, 0, 255);" href="http://www.php.net/echo">echo</a> "<span style="color: rgb(139, 0, 0);">Record doesn't exist.</span>";<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);">}<br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(39, 39, 39);"><span style="color: rgb(0, 0, 255);">?></span><br /></pre><pre style="margin: 0em; font-size: 12px; width: 100%; font-family: consolas,'Courier New',courier,monospace; background-color: rgb(0, 0, 0);"></pre></pre><p>Lastly, open getfiles.php…notice that, on file mime type audio/mpeg and application/octet-stream, browser will ask where to download on your pc…you can add more mime type as you like.<br /><br />Try it…and gud luck!!!<br /><br />Happy Blobing…</p>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com0tag:blogger.com,1999:blog-3613914438107826772.post-12529199769752168292009-01-17T22:01:00.003+08:002009-01-17T22:05:10.315+08:00Ask What!!<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsrfEUl6yI-H969pWFurkZrpI_JAeFJ09mRa-Dj1o6wuyx7ABqPJwuT0XnG1MOCI6ZNj0rC5VSB8tIg0ly-p9O0oBl0YNBJJlWCsmHyWue6v89EsLPmyU_QF4iix-kEvg4nF9h5f4lzeU/s1600-h/lazy.bmp"><img id="BLOGGER_PHOTO_ID_5292263355698129442" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 266px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsrfEUl6yI-H969pWFurkZrpI_JAeFJ09mRa-Dj1o6wuyx7ABqPJwuT0XnG1MOCI6ZNj0rC5VSB8tIg0ly-p9O0oBl0YNBJJlWCsmHyWue6v89EsLPmyU_QF4iix-kEvg4nF9h5f4lzeU/s400/lazy.bmp" border="0" /></a><br /><div align="center">Woit....tak buat keje ker???..huhuhuh</div>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com0tag:blogger.com,1999:blog-3613914438107826772.post-76257984786331043632009-01-16T08:47:00.004+08:002009-01-16T08:57:57.728+08:00Tagged!! (MagMyPic)<p align="center"><a href="http://www.magmypic.com/"><img src="http://b1.magmypic.com/usermags/3/d3/fc3e2fc5bc4c4cf6d604e82db6e1d_3401.jpg" border="0" /></a><br /><span style="font-size:78%;color:#ff0000;">Waaarrggghhhh!!!<br /></span><br />I'be been tag by my <a href="http://mak-amni.blogspot.com/2009/01/magmypic.html">wife</a>, hope you'll enjoy it!!<br /></p>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com1tag:blogger.com,1999:blog-3613914438107826772.post-72117574932069551162009-01-14T16:55:00.004+08:002009-01-16T08:58:53.748+08:00Metallica Rulezzz!!!<div style="TEXT-ALIGN: center"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG3KYAAJm-lnaw0mc5RC39NXxCbMwH1DuXGu6IUwJHeudQvVOJg_YPQKh_08deO2GLR_7lSi02_KuAlUDubHnbpjSrEpwwl6mTdHev5MLBYc-g9qPmlzKDBM8EzLkqibGaAvfrIvpJATY/s1600-h/DevilHornHand.jpg"><img id="BLOGGER_PHOTO_ID_5291072109337823266" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 178px; CURSOR: pointer; HEIGHT: 287px; TEXT-ALIGN: center" alt="Rock On!!" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG3KYAAJm-lnaw0mc5RC39NXxCbMwH1DuXGu6IUwJHeudQvVOJg_YPQKh_08deO2GLR_7lSi02_KuAlUDubHnbpjSrEpwwl6mTdHev5MLBYc-g9qPmlzKDBM8EzLkqibGaAvfrIvpJATY/s400/DevilHornHand.jpg" border="0" /></a><span style="COLOR: rgb(51,204,255);font-size:78%;" >The Devil's Horn</span><br /><br /><br /></div><div style="TEXT-ALIGN: center"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGI4p696mRpMlBKiQsWoKNMC7PYVCG4KLoIAFRCcRjQoGMhvRpOF6Y_oSA5VSObJhw1PSsEy1A2ZQ7B0fr-NSx2RoGAjySq0hcrsQqsHGMin5iUS1MhKs9RJmDyYeZZ-XlrnKhxy7sSg8/s1600-h/metallica-the+videos.JPG"><img id="BLOGGER_PHOTO_ID_5291072114229344370" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 117px; CURSOR: pointer; HEIGHT: 117px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGI4p696mRpMlBKiQsWoKNMC7PYVCG4KLoIAFRCcRjQoGMhvRpOF6Y_oSA5VSObJhw1PSsEy1A2ZQ7B0fr-NSx2RoGAjySq0hcrsQqsHGMin5iUS1MhKs9RJmDyYeZZ-XlrnKhxy7sSg8/s400/metallica-the+videos.JPG" border="0" /></a>Been dying to see all <a href="http://www.metallica.com/">Metallica</a> vids? <a href="http://www.metallica.com/Media/Video/misc_video.asp?id=448">Here you go!!</a><br />From "One" to the latest "All Nightmare Long"...they got it!<br /><br /></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqkOb6TTrDDQVcH84HKLyjDgrxgLTTX3LFDOMVCZH2glHbsTiXT4sPrKDTfJgCSPs6xjb1YxuMCTK5EIjxtuTt6C40n3ZK7awYwsm0xCuA4tjnmhqs2-t8-jeZ67qfWAq_RIoLi70Sgdg/s1600-h/metallica-dm_guitarbook.jpg"><img id="BLOGGER_PHOTO_ID_5291072113731001186" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: pointer; HEIGHT: 400px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqkOb6TTrDDQVcH84HKLyjDgrxgLTTX3LFDOMVCZH2glHbsTiXT4sPrKDTfJgCSPs6xjb1YxuMCTK5EIjxtuTt6C40n3ZK7awYwsm0xCuA4tjnmhqs2-t8-jeZ67qfWAq_RIoLi70Sgdg/s400/metallica-dm_guitarbook.jpg" border="0" /></a><span style="font-size:78%;"><br /></span><div style="TEXT-ALIGN: center"><span style="font-size:78%;">Death Magnetic Guitar Tablature</span><br /><br />Since the 1st day Death Magnetic out..this is the book i've been waiting for..but when i'm going to buy it huh?? </div>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com1tag:blogger.com,1999:blog-3613914438107826772.post-12095616451436599062008-12-23T14:25:00.003+08:002008-12-23T14:27:32.664+08:00Holidays!!<div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrds_3HkCSgMK_jz0-Txl24q-krMrhISwge_cY4sfT21W3Z48fzzqwaPnaqFXOTpeGKmnzLqCYvvOHN0MmB9Ix8OAgnJtoUfrq0j6PYT9nnAeh0mn71NMqmPKDUAmIcJtYc7iQ39kXxw/s1600-h/cherating_map.gif"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 307px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrds_3HkCSgMK_jz0-Txl24q-krMrhISwge_cY4sfT21W3Z48fzzqwaPnaqFXOTpeGKmnzLqCYvvOHN0MmB9Ix8OAgnJtoUfrq0j6PYT9nnAeh0mn71NMqmPKDUAmIcJtYc7iQ39kXxw/s400/cherating_map.gif" alt="" id="BLOGGER_PHOTO_ID_5282867913403605570" border="0" /></a>off we go!!<br />be back after new year.<br /></div>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com3tag:blogger.com,1999:blog-3613914438107826772.post-54498148563048462222008-12-22T10:49:00.008+08:002008-12-22T11:47:14.030+08:00Safe or Save?<div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibvQ8TFncs1P-2nFAwgTP4mx5s6vuwp2QWGR2EimWgFtPHKe4_kELHKQe_0jwOfP4Iefal3HM2AJaeidK8GzkYI3aE9cOGw5cfRVPBfcI1THm7pWCSKdbgJK53_0oqrIGUdiy7kHiQ34w/s1600-h/save+location.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 341px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibvQ8TFncs1P-2nFAwgTP4mx5s6vuwp2QWGR2EimWgFtPHKe4_kELHKQe_0jwOfP4Iefal3HM2AJaeidK8GzkYI3aE9cOGw5cfRVPBfcI1THm7pWCSKdbgJK53_0oqrIGUdiy7kHiQ34w/s400/save+location.jpg" alt="" id="BLOGGER_PHOTO_ID_5282451182797844498" border="0" /></a>is it truly safe?<br />i'm no expert, but then, is it?<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYKIIYMRrlCtdz9b0QRQ0iHShe98FSDDQGC3sdgo8j7LfzOOtbMJ78EX4WaIWPoSO6x-wn0gsovL2xjtzv2d-VcM6EgJif7LqdilM9AExxMub5iYnnMC46ND8EdeNoaupLlKql83raduU/s1600-h/not+safe+location.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 280px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYKIIYMRrlCtdz9b0QRQ0iHShe98FSDDQGC3sdgo8j7LfzOOtbMJ78EX4WaIWPoSO6x-wn0gsovL2xjtzv2d-VcM6EgJif7LqdilM9AExxMub5iYnnMC46ND8EdeNoaupLlKql83raduU/s400/not+safe+location.jpg" alt="" id="BLOGGER_PHOTO_ID_5282452005250415538" border="0" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTTlILhkHA6mY4dsvos0Eb-mggWwiqOyIRopdayRUXUk9D99sZDaq4kEnDqVe9vTwy81UqGlCU-ZmI20SDg1ktrep8JDth7HSUJhPjwgageD4lzBm_lZtvfFexcLgJPjJrdPgn08KV7sE/s1600-h/not+safe+location%28info%29.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 250px; height: 164px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTTlILhkHA6mY4dsvos0Eb-mggWwiqOyIRopdayRUXUk9D99sZDaq4kEnDqVe9vTwy81UqGlCU-ZmI20SDg1ktrep8JDth7HSUJhPjwgageD4lzBm_lZtvfFexcLgJPjJrdPgn08KV7sE/s400/not+safe+location%28info%29.jpg" alt="" id="BLOGGER_PHOTO_ID_5282455674149236706" border="0" /></a><br />or it just to save?<br /><br /><span style="font-size:78%;">(credit to <a href="http://thestar.com.my/news/story.asp?file=/2008/12/21/nation/2867796&sec=nation">the star</a> for the graphics)</span><br /></div>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com2tag:blogger.com,1999:blog-3613914438107826772.post-18122298030926689952008-12-20T16:11:00.002+08:002008-12-21T00:19:11.561+08:00first contact..<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-ZOvi5dXlnWQR06GzkYJiCfVf7xn1bGgv8hUi6-Vn1_DX6lKuteimMdmPooO3RRY0ugCcpLXGdJN5ncfnSolsj_DJIF2i7Tsf7QcjMyU9tbQVS_X_lJ40SETdCr2TVRz-h3pY7suxJx4/s1600-h/first+contact.jpg"><img id="BLOGGER_PHOTO_ID_5281907498621671282" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 282px; CURSOR: hand; HEIGHT: 400px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-ZOvi5dXlnWQR06GzkYJiCfVf7xn1bGgv8hUi6-Vn1_DX6lKuteimMdmPooO3RRY0ugCcpLXGdJN5ncfnSolsj_DJIF2i7Tsf7QcjMyU9tbQVS_X_lJ40SETdCr2TVRz-h3pY7suxJx4/s400/first+contact.jpg" border="0" /></a><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfe5SDlffOPaYJImw1pT6jQ1YSMKLVC83anDeNecnlfNGDDlNI_Zw9S-KFqBzSiKf9E-vx4MSydbG92BkxU545Ssa3Z8fCx9uchPAOil4iliOTpE6tLwVFrAjg5AuDkPihKGQtCv7Yopk/s1600-h/first+contact.jpg"></a><br /><br /><p align="center"></p></div>lipatdua lagihttp://www.blogger.com/profile/14047374969176659358noreply@blogger.com2