BLOBS (Binary Large Objects) is a data type in a MYSQL database. I have the following forms/code inside a Web Baker template. See below
Upload a file form -
<form method="POST" enctype="multipart/form-data" action="upload.php">
<table width="350" cellspacing="1" cellpadding="1" border="0" class="box">
<tbody>
<tr>
<td width="246"><input type="FILE" name="userfile" id="username" /></td>
<td width="80"><input type="submit" value="Upload" name="upload" /></td>
</tr>
</tbody>
</table>
</form>
///---Inserts the file into the MYSQL database
include 'library/config.php';
include 'library/opendb.php';
//replace the above two string's with your database specific values
$sql="SELECT id, name ";
$sql .="FROM Upload.upload";
$sql_results = mysql_query($sql);
echo "<TABLE BORDER=1 cellspacing=0 cellpadding=5>";
echo "<TR><TD>File Link</TD><TD>Name</TD></TR>";
while ($rs = mysql_fetch_array($sql_results))
{
echo "<TR><TD><a href=download.php?id=".$rs[0].">". $rs[1]."</a></TD>";
echo "<TD>". $rs[1] ."</TD>"; //Name
}
echo "</table>";
echo "<P></P>* Click on the file name to download the file";
//----Downloads the file stored in the MYSQL Database. When this happens and this code is incorporated in a web baker template the attachment/save as file is corrupted with template data - corrupting the file in the process.
include 'library/config.php';
include 'library/opendb.php';
$id=$_GET['id'];
$sql = "SELECT content, type, name, ";
$sql .="size FROM Upload.upload WHERE id=$id";
$result = @mysql_query($sql);
mysql_result($result, 0);
$data = @mysql_result($result, 0, "content");
$type = @mysql_result($result, 0, "type");
$name = @mysql_result($result, 0, "name");
$size = @mysql_result($result, 0, "size");
include 'library/closedb.php';
header("Content-type: $type");
header("Content-length: $size");
header("Content-Disposition: attachment; filename=$name");
header("Content-Description: PHP Generated Data");
echo $data;
//---
The download code above extracts the file correctly, but is corrupted with the template data when it saves the file. Is there anyway to filter out the web baker template code from the attachment. I modified the code template to a blank template, but a small piece of code still gets attached to the attachment if that makes sense upon downloading and saving the file from the database. Any help would be appreciated.
Thanks.
Author
