Downloading File's From A Db Help

rrayner · November 16, 2012

I have three files which i have posted below

File 1 upload.php which uploads the file to the database.

File 2 downlaod.php just give you the list of file which are available to download

File 3 download2.php Is the file which download the file selected.

My problem is once I have downloaded the file back from the database it is saying for example when trying to open a word document "The file x.docx connot be opened because there are problems with the content"

Also when downloading images from the database they will not open ethier.

Is it I am doing wrong

/*********************************************************************************************************************/

//

// Upload script (upload.php)

//

/*********************************************************************************************************************/

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR...l1-strict.dtd">

<?php

//*******************************************************

//

// Open Connection to Database

//

//*******************************************************

include ("connection.php");

?>

<tr>

</td>

</tr>

</table>

</form>

<?php

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)

{

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

$tfileName = trim($fileName);

$ttmpName = trim($tmpName);

$tfileSize = trim($fileSize);

$tfileType = trim($fileType);

$fp = fopen($ttmpName, 'r');

$content = fread($fp, filesize($ttmpName));

$content = addslashes($content);

fclose($fp);

$tcontent = trim($content);

if(!get_magic_quotes_gpc())

{

$fileName = addslashes($fileName);

}

$query = "INSERT INTO upload (name, size, type, content ) ".

"VALUES ('$tfileName', '$tfileSize', '$tfileType', '$tcontent')";

mysql_query($query) or die('Error, query failed');

echo "<br>File $fileName uploaded<br>";

}

?>

/*********************************************************************************************************************/

//

// Download script which give you a list of files which you can download (downloadfile.php)

//

/*********************************************************************************************************************/

<html>

<head>

<title>Download File From MySQL</title>

</head>

<body>

<?php

include ("connection.php");

$query = "SELECT id, name FROM upload";

$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)

{

echo "Database is empty <br>";

}

else

{

//while(list($id, $name) = mysql_fetch_array($result))

while ($list = mysql_fetch_array($result))

{

$id = $list["id"];

$name = $list["name"];

echo "ID = $id ,Name = $name";

echo "<a href='downloadfile2.php?list=$id'>$name</a> <br>";

}

?>

</body>

</html>

/*********************************************************************************************************************/

//

// Download script which downloads the file (downloadfile2.php)

//

/*********************************************************************************************************************/

<?php

include ("connection.php");

$list = (isset($_GET['list'])) ? $_GET['list'] : '';

echo "$list";

//if(isset($_GET['id']))

if(isset($list))

{

// if id is set then get the file with the id from database

$id = $list;

$query = "SELECT `name`,`type`,`size`,`content` FROM upload WHERE id = '$id'";

$result = mysql_query($query) or die('Error, query failed');

$list2 = mysql_fetch_array($result);

$name = $list2["name"];

$type= $list2["type"];

$size= $list2["size"];

$content= $list2["content"];

$tcontent = trim($content);

header("Content-Transfer-Encoding: binary");

header("Content-length: $size");

header("Content-type: $type");

header("Content-Disposition: attachment; filename=$name");

echo "$tcontent";

exit;

}

?>

Muddy_Funster · November 16, 2012

...

Is it I am doing wrong

...

Yip. Once you try and open the file, and then read the content into the database, anything that the original program attached to the file to identify it ias openable by that application will be lost. You shouldn't really be storing the contents of the files in this way anyway. What you want to do is store the information about the file in the database, and store the actual file in on the filesystem(it's what it's designed for after all) of the server.

Sign In

Downloading File's From A Db Help

Recommended Posts

rrayner

Link to comment

Share on other sites

Muddy_Funster

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information