<?
/*
ปรับปรุง : 2549-06-01
ประกอบด้วย uploadpage.htm, uploadprocess.php และ download.php
Source from http://php.dreamwerx.net/forums/viewtopic.php?t=6
Download script.. streams data from a mysql database, thru the webserver to a client browser
*/
if (isset($_GET["id"])) {
$Storage_IP = "localhost";
$Storage_Port = 3306;
$Storage_User = "root";
$Storage_Passwd = "";
$Storage_DB = "test";
$connectto = $Storage_IP . ":" . $Storage_Port;
if (!$linkid = @mysql_connect($connectto, $Storage_User, $Storage_Passwd)) {
die("Unable to connect to storage server!");
}
if (!mysql_select_db($Storage_DB, $linkid)) {
die("Unable to connect to storage database!");
}
$nodelist = array();
// Pull file meta-data
$SQL = "select * from file where id = " . $_GET["id"];
if (!$RES = mysql_query($SQL, $linkid)) {
die("Failure to retrive file metadata");
}
if (mysql_num_rows($RES) != 1) {
die("Not a valid file id!");
}
$FileObj = mysql_fetch_object($RES);
// Pull the list of file inodes
$SQL = "SELECT id FROM filedata WHERE masterid = " . $_GET["id"] . " order by id";
if (!$RES = mysql_query($SQL, $linkid)) {
die("Failure to retrive list of file inodes");
}
while ($CUR = mysql_fetch_object($RES)) {
$nodelist[] = $CUR->id;
}
// Send down the header to the client
Header ( "Content-Type: $FileObj->datatype" );
Header ( "Content-Length: " . $FileObj->size );
Header ( "Content-Disposition: attachment; filename=$FileObj->name" );
// Loop thru and stream the nodes 1 by 1
for ($Z = 0 ; $Z < count($nodelist) ; $Z++) {
$SQL = "select filedata from filedata where id = " . $nodelist[$Z];
if (!$RESX = mysql_query($SQL, $linkid)) {
die("Failure to retrive file node data");
}
$DataObj = mysql_fetch_object($RESX);
echo $DataObj->filedata;
}
} else {
echo "<form action=download.php method=get><input name=id value=1><input type=submit></form>";
}
?>
