Page 1 of 1

files wont open

Posted: Tue Jul 01, 2008 7:46 am
by ma5ect
I have a download script which holds files which have been uploaded by the users.. the files are shown on this page but once i try to open them, nothin happens...any1 help

script

Code: Select all

<?php require_once('Connections/mysql_connect.php'); ?>
<?php
if(isset($_GET['name']))
{
 
   $name    = $_GET['name'];
   $query   = "SELECT type, size, content FROM uploadfiles WHERE name = '$name'";
   $result  = mysql_query($query) or die('Error, query failed');
   list($name, $type, $size, $content) = mysql_fetch_array($result);
 
   header("Content-Disposition: attachment; filename=$name");
   header("Content-length: $size");
   header("Content-type: $type");
   echo $content;
 
   exit;
}
mysql_select_db($database_mysql_connect, $mysql_connect);
$query_Recordset1 = "SELECT * FROM uploadfiles";
$Recordset1 = mysql_query($query_Recordset1, $mysql_connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
 
mysql_free_result($Recordset1);
 
?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
 
<body>
<?
 
$query  = "SELECT name FROM uploadfiles";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
   echo "Database is empty 
";
} 
else
{
   while(list($name) = mysql_fetch_array($result))
   {
?>
   <a href="download.php?id=<?=$id;?>"><?=$name;?>[/url] 
 
<?      
   }
}
 
?>
</body>
</html>

Re: files wont open

Posted: Tue Jul 01, 2008 8:00 am
by jaoudestudios
maybe...

permissions or ownerships?

linux & php commands: chmod & chown