PHP - How To Download Audio Files From Direcotry According To The Id's From Database In Php?

Hi Guys I trying to download files and I have this error message, hopelly you guys can help me please Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 15

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 17

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/12746204/html/Digital/core/inc/init.inc.php:6) in /home/content/04/12746204/html/Digital/download.php on line 18     This is the code I use to force the download

<?php
include('core/inc/init.inc.php');
   if(isset($_GET['file_id'])) {  
     $file_id=(int)$_GET['file_id'];    
     $file=mysql_query("SELECT file_name, file_expiry FROM files WHERE file_id=$file_id");    
     if(mysql_num_rows($file)!=1){   
       echo'Invalid file Id';
     }else{
       $row=mysql_fetch_assoc($file);
       if ($row['file_expiry']<time()){
          echo'This file has expired'; 
       }else{
              $path="core/files/{$row['$file_name']}";
              header('Content-Type:application/octet-stream');
              header('Content-Description:File Transfer');
              header('Content-Transfer-Encoding:binary');
              header("Content-Disposition:attachment;filename=\"{$row['file_name']}\"");
              header('Content-Length:'.filesize($path));
              readfile($path);
       }
     }
}
?>

Thank you for your help.....

Hi guys i am kinda stuck at a part where i want a download button to prompt out two download windows in a click. Currently i am able to prompt out one download window only. I have tried putting another header line of Content Disposition but it doesn't work..i will appreciate if you guys can help me out, thanks!

The desired scenario will be WinSCP.exe download prompt will appear first, follow by auditgroup.bat


$file1 = "WinSCP.exe";
$file = "auditgroup.bat";
     //Set headers
     header("Cache-Control: private");
     header("Expires: 0");
     header("Pragma: cache");
     header("Content-Description: File Transfer");
     header("Content-Disposition: attachment; filename=$file");
     header("Content-Type: application/octet-stream");
     header("Content-Transfer-Encoding: ASCII");
     //Read the file from disk
     readfile($file);

Hi PHP Community,
I have this class in my DOCMAN script and would like to add aditional functionality to watermark existing PDF files:

Code: [Select]
class DOCMAN_File
{
/**
* @access public
* @var string
*/
    var $path = null;
/**
* @access public
* @var string
*/
    var $name = null;
/**
* @access public
* @var string
*/
    var $mime = null;
    /**
* @access public
* @var string
*/
    var $ext = null;
   
    /**
* @access public
* @var string
*/
    var $size = null;
   
    /**
* @access public
* @var string
*/
    var $date = null;
   
    /**
* @access private
* @var string
*/
    var $_err    = null;

/**
* @access private
* @var boolean
*/
var $_isLink;

function DOCMAN_File($name, $path)
{
$path = mosPathName( $path );
if (!is_dir( $path )) {
$path = dirname( $path );
}

$this->name = trim($name);
$this->path = $path;

if( strcasecmp( substr( $this->name , 0, _DM_DOCUMENT_LINK_LNG ) , _DM_DOCUMENT_LINK )==0){
$this->_isLink = true;
$this->size    = 0;
$this->mime    = 'link';
}else{
$this->_isLink = false;
$this->size = filesize($this->path."/".$this->name);
$this->mime = DOCMAN_MIME_Magic::filenameToMIME($this->name, false);
}

$this->ext  = $this->getExtension();
}


/**
*    Download or view a file from the server
*    @desc This is the function handling files downloading using HTTP protocol
*    @param void
*    @return void
*/

    function download()
    {
$user_agent = (isset($_SERVER["HTTP_USER_AGENT"]) ) ?
$_SERVER["HTTP_USER_AGENT"] : $HTTP_USER_AGENT;

//Fixed [#2534] clean all output buffers (needs PHP > 4.2.0)
  /* while (ob_get_level()) {
      * ob_end_clean();
    }*/
// Fix [3164]
while (@ob_end_clean());

if( $this->_isLink ){
header( "Location: " . substr( $this->name , 6 ) );
return;
}

$fsize = filesize($this->path."/".$this->name);
$mod_date = date('r', filemtime( $this->path.'/'.$this->name ) );

$cont_dis = 'attachment;';
if(isset($_REQUEST['mode']))
$cont_dis = ($_REQUEST['mode'] == 'view') ? 'inline;' : 'attachment;';

        header("Pragma: public");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Expires: 0");

        header("Content-Transfer-Encoding: binary");
header('Content-Disposition:' . $cont_dis .'";'
. ' filename="' . $this->name . '";'
. ' modification-date="' . $mod_date . '";'
. ' size=' . $fsize .';'
); //RFC2183
        header("Content-Location: ". $this->path . '/' . $this->name );
        header("Content-Type: "    . $this->mime ); // MIME type
        header("Content-Length: "  . $fsize);

  // No encoding - we aren't using compression... (RFC1945)
// header("Content-Encoding: ");

        readfile($this->path."/".$this->name);
        // The caller MUST 'die();'
    }
   
function exists() {
if( $this->_isLink ){
return true;
}
    return file_exists($this->path."/".$this->name);
    }

function isLink(){
return $this->_isLink ;
}
   
    /**
*    Get file size
*
*    @desc Gets the file size and convert it to friendly format
*    @param void
*    @return string Returns filesize in a friendly format.
*/

function getSize()
    {
if( $this->_isLink ){
return 'Link';
}
        $kb = 1024;
        $mb = 1024 * $kb;
        $gb = 1024 * $mb;
        $tb = 1024 * $gb;
       
        $size = $this->size;
       
        if ($size) {
            if ($size < $kb) {
                $file_size = "$size Bytes";
            }
            elseif ($size < $mb) {
                $final = round($size/$kb,2);
                $file_size = "$final KB";
            }
            elseif ($size < $gb) {
                $final = round($size/$mb,2);
                $file_size = "$final MB";
            }
            elseif($size < $tb) {
                $final = round($size/$gb,2);
                $file_size = "$final GB";
            } else {
                $final = round($size/$tb,2);
                $file_size = "$final TB";
            }
        } else {
  if( $size == 0 )
    $file_size = "Empty!";
  else
            $file_size = "ERROR";
        }
        return $file_size;
    }
   
    /**
*    @desc Gets the extension of a file
*    @return string The file extension
*/
   
    function getExtension()
    {
if( $this->_isLink )
return "lnk";

        $dotpos = strrpos($this->name, ".");
        if ($dotpos < 1)
            return "unk";

        return substr($this->name, $dotpos + 1);
    }
   
    function getDate($type = 'm')
    {
if( $this->_isLink ){
return "";
}

    $date = '';
   
    switch($type)
    {
    case 'm' :
    $date = filemtime($this->path."/".$this->name);
    break;
    case 'a' :
    $date = fileatime($this->path."/".$this->name);
    break;
    case 'c' :
    $date = filectime($this->path."/".$this->name);
    break;
    }
   
    return date ("m.d.y - H:i:s", mosFormatDate($date));
    }
}

I found this function on the net and it works fast. But because I'm newbie I have problem in implementing it correctly to class:

Code: [Select]
        function WaterMark($filename){
                $tempfile=tempnam('/path/to/directory/tmp,'temp.pdf');
                $watermark = "/path/to/directory/htdocs/components/com_docman/includes_frontend/water.pdf";
                system("pdftk $filename stamp $watermark output $tempfile dont_ask", $errcode);
                if (!$errcode && $ih=fopen($tempfile, 'r')) {
                header('Content-Type: application/pdf');
                fpassthru($ih);
                fclose($ih);
                } else {
                print "Whoops";
                }
                unlink($tempfile);
        }


Here is frontend use of class.

Code: [Select]
$downloadDoc = new DOCMAN_File($document->dmfilename,$_DOCMAN->getCfg('dmpath'));
$downloadDoc->download();

For now I only managed to get it working to watermark PDF file for view mode but not before download mode as attachment.
Function is working fine by itself but not when integrated in class. I'm getting really frustrated . Please help me!?!
Thank you everybody.
Al

Hey guys,

im starting out on my php journey with a small question.

I have a small uploading site and i want to allow php uploads. Once uploaded, you get a direct upload link, and i want the file to download, rather than execute.

How can this be done?

Thanks!

Hi, how much bandwidth is used for 1000 downloads per day or for each download? Is it safe to have no download limits? Thanks

Hi Guys,

I'm putting together a project which requires members of a site to upload files(mostly word files) into a mysql db.
I can get the files uploaded successfully but when it comes to downloading them i do have a bit of trouble. When i click on the download link i just get a file called 'download.php' instead of the actual file in the database.

I have been working on this link for the past two weeks and think maybe its time for some help, here's my code if you wouldn't mind having a look?




upload.php:

<?php

session_start();

?>

<html>
<head>

<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<!-- start header -->
<div id="header">
   
</div>

<div id="menu">
   <ul>
      <li><a href="#">Home</a></li>
      <li><a href="member.php">Member</a></li>
      <li><a href="logout.php">Log Out</a></li>
   </ul>
</div>


<div id = "content">
   
      <form method="post" enctype="multipart/form-data"/>
      <input type="hidden" name="MAX_FILE_SIZE" value="2000000"/>
      <input name="userfile" type="file" id="userfile"/>
      <input type="submit" name="upload1"  id="upload1" value=" Upload "/>
      </form>
</div>
   <?php
if(isset($_POST['upload1']) && $_FILES['userfile']['size'] > 0)
{

$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

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


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

   <div id = "nav">
   </br>
   <a href = "upload.php"><img src = "images\add-itemGreen.gif"/></a><b>Upload</b></br>
   </br>
   <a href = "download.php"><img src = "images\download.gif"/></a><b>Download</b></br>
   </br>
   <a href = "discussion.php"><img src = "images\chat-.gif"/></a><b>Discussion Board</b></br>
   </div>


<div id="footer">

</div>
</body>
</html>




View.php:
<?php
ini_set('display_errors', E_ALL);
//include "open_db.inc";
 
$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");
 
$sql = "SELECT * FROM upload ";
$sql .= "ORDER BY name ASC";
$result = mysql_query($sql, $connect);
$rows = mysql_num_rows($result);
 
echo "<table>\n";
echo " <tr>\n";
echo "  <td>id</td>\n";
echo "  <td>name</td>\n";
echo "  <td>type</td>\n";
echo "  <td>size</td>\n";
echo "  <td>Description</td>\n";
echo "  <td> </td>\n";
echo " </tr>\n";
 
while ($rows = mysql_fetch_object($result))
  {
  echo " <tr>\n";
  echo "  <td>$rows->id</td>\n";
  echo "  <td>$rows->name</td>\n";
  echo "  <td>$rows->type</td>\n";
  echo "  <td>$rows->size</td>\n";
  echo "  <td>" . stripslashes($rows->description) . "</td>\n";
  echo "  <td>( <a href='download.php?id=$rows->id'>Download</a> )</td>\n";
  echo " </tr>\n";
 
  }
 
mysql_free_result($result);
mysql_close($connect);
?>



download.php:
<?php
ini_set('display_errors', E_ALL);
if (isset($_GET['id']))
 {
 $id_files = $_GET['id'];
// include "open_db.inc";
$connect = mysql_connect ("localhost","root","") or die ("Couldn't connect!");
mysql_select_db("upload") or die ("Couldn't find db");

  $sql = "SELECT id, name, type, size, content FROM upload WHERE id=$id";
 
  $result = @mysql_query($sql, $connect);
  $dataT = @mysql_result($result, 0, "bin_data");
  $name = @mysql_result($result, 0, "name");
  $size = @mysql_result($result, 0, "type");
  $type = @mysql_result($result, 0, "size");
 
  header("Content-type: $type");
  header("Content-length: $size");
  header("Content-Disposition: attachment; name=$name");
  header("Content-Description: PHP Generated Data");
  header("Content-transfer-encoding: binary");
  echo $dataT;
}
else
{
echo 'id_files not set';
 
}
?>


I'm thinking that it could be something to do with the bin_data on the download.php page.
Any help would be great.

Thanks

Hi PHP freaks!!   I have manage to make a script to upload file in database and its working. I will share to you the codes so for other viewers and readers to use also.

if($result){
			if($_FILES['LRCard']['name'] != ""){
				$filename = $_FILES['LRCard']['name'];
				$ext = strrchr($filename,".");
				$LRCardname = $student_id;
				$LRCardname .="_". $filename; 
				if($ext ==".jpg" || $ext ==".jpeg" || $ext ==".JPG" || $ext ==".JPEG" || $ext ==".gif" || $ext ==".GIF"){
					$size = $_FILES['LRCard']['size'];
					if($size > 0 && $size < 5000000){
						$archive_dir = "LRCards";
						$userfile_tmp_name = $_FILES['LRCard']['tmp_name'];
						if(move_uploaded_file($userfile_tmp_name, "$archive_dir/$LRCardname")){
							/*
								if LRC is successfully uploaded then LRC is stored in database.
							*/
							mysql_query("update student_information set LRCard='$LRCardname' where student_id='$student_id'", $link_id); 
							$flag = "success"; 
							if(mysql_error()!=null){
								die(mysql_error());
							}

						}
						else{
							if(file_exists('LRCard/' . $LRCardname)) {
								unlink('LRCards/' . $LRCardname); 
							}
							rollbackData();
						}
					}
					else{
						if(file_exists('LRCards/' . $LRCardname)) {
							unlink('LRCard/' . $LRCardname); 
						}
						rollbackData();
						die("You can upload LRCard of 5 MB size only. Please, try again.");
					}
				}
				else{
					if(file_exists('LRCards/' . $LRCardname)) {
						unlink('LRCards/' . $LRCardname); 
					}
					rollbackData();
					die("You can upload LRCard of .jpg, .jpeg, .gif extensions only. Please, try again. ");
				}
			} 	
		}
		else{
			$flag="error";
		}
		if($flag == "success"){
			mysql_query(" COMMIT ");
			$flag="success";
			if(mysql_error() != null){
				die(mysql_error());
			}
	    }

Now, my problem is how to make a Php script to DOWNLOAD this uploaded file considering the 1. file path 2. file name 3. file extension. 4. student_id (to determine the specific file from a specific student)   My plan is to make a download button which hyperlink to download.php and after clicking that button the specified file to a specific student id will automatically be downloaded by the browser.  

Hi Guys,
            I have been contacted by a client who wants me to develop an application which performs the following functionality:

Lets say the domain name is xyz.com . We provide an email of our domain to the person who signup on our website for our services. Lets say the email that is given to the customer is email@xyz.com

The client wants to built PHP application in which if an email is sent to email@xyz.com it gets downloaded and is stored in the MySql Database. After the download there is going to be a set of algorithms which will decided whether to forward this email to the client or not on his email address.

I have no idea how to accomplish this functionality. Any suggestions would be appreciated.

Thanks

Sadan Masroor.

Hi, this is my first post:) pretty sure i will be posting here in the future. Anyway i am having trouble with a php script which downloads a file from a mysql database.

This php script works for text files and should work for most files from what i understand. When downloading a text file, the whole file is downloaded from the server. When downloading an mp3 file, only 16kb are downloaded and the file does not play. When looking at the data in the database, it displays that the full file is there (correct amount of bytes, so there is nothing wrong with my upload php script). Does anyone have any suggestions as to what I can change to make this work?

Code: [Select]
<?php
if(isset($_GET['id'])) 
{
// if id is set then get the file with the id from database
$link=mysql_connect('localhost', 'root', '');
@mysql_select_db('filemgr') or die ("<p>Could not connect to mysql!</p>");

$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
         "FROM upload WHERE id = '$id'";

$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) =  mysql_fetch_array($result);

header("Content-length: $size");
header("Content-type:$type");
header("Content-Disposition: attachment; filename=$name");
echo $content;

mysql_close($link);
exit;
}
?>

This is my first post so please correct me if somethings wrong

Basically im creating a shopping cart with the help of a guide but there is no database written in the guide so i'm not sure how to proceed. My database wont work...
Guide:
https://jameshamilto...g-cart-tutorial

Error message
http://gyazo.com/a20...b096b7727410dfd

Index:

  <?php session_start(); ?>
   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   <html xmlns="http://www.w3.org/1999/xhtml">
   <head>
   <meta name="description" content="PHP Shopping Cart Using Sessions" /> 
   <meta name="keywords" content="shopping cart tutorial, shopping cart, php, sessions" />
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   <link rel="stylesheet" media="all" href="/style/style.css" type="text/css" />
   <title>Cart</title>
  
  
  <?php
  	//connect to your database here
  	
  
  $sql = 'SELECT * FROM books ORDER BY id';
  $output[] = '<ul>';
  $output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
  
  
  //connect mysql
  
  mysql_connect($server, $user, $pass) or die ("Sorry, can't conect to mysql.");
  
  //select db
  
  mysql_select_db($db) or die ("Sorry cant select the db.");
  
  
  ?>
  
  
  
  </head>
  <body>
  
  
  <?php
  
  	$product_id = $_GET[id];	 //the product id from the URL 
  	$action 	= $_GET[action]; //the action from the URL 
  
  	//if there is an product_id and that product_id doesn't exist display an error message
  	if($product_id && !productExists($product_id)) {
  		die("Error. Product Doesn't Exist");
  	}
  
  	switch($action) {	//decide what to do	
  	
  		case "add":
  			$_SESSION['cart'][$product_id]++; //add one to the quantity of the product with id $product_id 
  		break;
  		
  		case "remove":
  			$_SESSION['cart'][$product_id]--; //remove one from the quantity of the product with id $product_id 
  			if($_SESSION['cart'][$product_id] == 0) unset($_SESSION['cart'][$product_id]); //if the quantity is zero, remove it completely (using the 'unset' function) - otherwise is will show zero, then -1, -2 etc when the user keeps removing items. 
  		break;
  		
  		case "empty":
  			unset($_SESSION['cart']); //unset the whole cart, i.e. empty the cart. 
  		break;
  	
  	}
  	
  ?>
  
  
  <?php	
  
  	if($_SESSION['cart']) {	//if the cart isn't empty
  		//show the cart
  		
  		echo "<table border=\"1\" padding=\"3\" width=\"40%\">";	//format the cart using a HTML table
  		
  			//iterate through the cart, the $product_id is the key and $quantity is the value
  			foreach($_SESSION['cart'] as $product_id => $quantity) {	
  				
  				//get the name, description and price from the database - this will depend on your database implementation.
  				//use sprintf to make sure that $product_id is inserted into the query as a number - to prevent SQL injection
  				$sql = sprintf("SELECT name, description, price FROM php_shop_products WHERE id = %d;",
  								$product_id); 
  					
  				$result = mysql_query($sql);
  					
  				//Only display the row if there is a product (though there should always be as we have already checked)
  				if(mysql_num_rows($result) > 0) {
  				
  					list($name, $description, $price) = mysql_fetch_row($result);
  				
  					$line_cost = $price * $quantity;		//work out the line cost
  					$total = $total + $line_cost;			//add to the total cost
  				
  					echo "<tr>";
  						//show this information in table cells
  						echo "<td align=\"center\">$name</td>";
  						//along with a 'remove' link next to the quantity - which links to this page, but with an action of remove, and the id of the current product
  						echo "<td align=\"center\">$quantity <a href=\"$_SERVER[PHP_SELF]?action=remove&id=$product_id\">X</a></td>";
  						echo "<td align=\"center\">$line_cost</td>";
  					
 					echo "</tr>";
 					
 				}
 			
 			}
 			
 			//show the total
 			echo "<tr>";
 				echo "<td colspan=\"2\" align=\"right\">Total</td>";
 				echo "<td align=\"right\">$total</td>";
 			echo "</tr>";
 			
 			//show the empty cart link - which links to this page, but with an action of empty. A simple bit of javascript in the onlick event of the link asks the user for confirmation
 			echo "<tr>";
 				echo "<td colspan=\"3\" align=\"right\"><a href=\"$_SERVER[PHP_SELF]?action=empty\" onclick=\"return confirm('Are you sure?');\">Empty Cart</a></td>";
 			echo "</tr>";		
 		echo "</table>";
 		
 		
 	
 	}else{
 		//otherwise tell the user they have no items in their cart
 		echo "You have no items in your shopping cart.";
 		
 	}
 	
 	//function to check if a product exists
 	function productExists($product_id) {
 			//use sprintf to make sure that $product_id is inserted into the query as a number - to prevent SQL injection
 			$sql = sprintf("SELECT * FROM php_shop_products WHERE id = %d;",
 							$product_id); 
 				
 			return mysql_num_rows(mysql_query($sql)) > 0;
 	}
 ?>
 
 <a href="products.php">Continue Shopping</a>
 
 
 <?php
 
 /*
 
 products table:
 	CREATE TABLE `products` (
 		`id` INT NOT NULL AUTO_INCREMENT ,
 		`name` VARCHAR( 255 ) NOT NULL ,
 		`description` TEXT,
 		`price` DOUBLE DEFAULT '0.00' NOT NULL ,
 		PRIMARY KEY ( `id` )
 	);
 
 */
 
 ?>
 
 
 
 </body>
 </html>

products.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
  <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta name="description" content="PHP Shopping Cart Using Sessions" /> 
  <meta name="keywords" content="shopping cart tutorial, shopping cart, php, sessions" />
  <link rel="stylesheet" media="all" href="/style/style.css" type="text/css" />
  <title>Products</title>
  
 <?php
 	//connect to your database here
 		//connect to your database here
 	
 
 $sql = 'SELECT * FROM books ORDER BY id';
 $output[] = '<ul>';
 $output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
 
 
 //connect mysql
 
 mysql_connect($server, $user, $pass) or die ("Sorry, can't conect to mysql.");
 
 //select db
 
 mysql_select_db($db) or die ("Sorry cant select the db.");
 ?>
 
 </head>
 
 <body>
 
 
 <table border="1">
 
 	<?php
 		
 		$sql = "SELECT id, name, description, price FROM php_shop_products;";
 		
 		$result = mysql_query($sql);
 		
 		while(list($id, $name, $description, $price) = mysql_fetch_row($result)) {
 		
 			echo "<tr>";
 			
 				echo "<td>$name</td>";
 				echo "<td>$description</td>";
 				echo "<td>$price</td>";
 				echo "<td><a href=\"cart.php?action=add&id=$id\">Add To Cart</a></td>";
 			
 			echo "</tr>";
 		}
 		
 	?>
 </table>
 
 
 <a href="cart.php">View Cart</a>
 
 </body>
 </html>

I wrote a piece of code that lists images that don't have a match in the database:

Code: [Select]
$dir_path = '../images/productImages';
$images = scandir($dir_path);

$query = "SELECT image FROM Database_table ORDER BY name DESC";

$results = mysql_query($query);

$output  = "<h1>Missing Images</h1>";
$output .= "<div class=\"missingImages\">";
$output .= "<p>The following data was found in the Database_table.images field but not in /images/productImages:</p>";
$output .= "<div class=\"missingImg\">";
$output .= "<p class=\"fieldName\">Database_table.images:</p>";

while ($fetch = mysql_fetch_array($results)) {

$clean_fetch = str_replace("productImages/", "", $fetch);
$diff = array_diff($clean_fetch, $images);
foreach (array_unique($diff) as $key => $value) {

$output .= $value . "<br />";
}
}

$output  .= "</div>";
$output  .= "</div>";

echo $output;
Works.

Now I would like to check whether there are any files in the folder that are not in the database table.

I thought it would be as easy as swapping the array_diff parameters around but it's not.

When i swap the parameters like so - array_diff($images, $clean_fetch) it gives me a list of ALMOST all the images in the image folder, which i don't understand.

Why does it not give me only the images that are present in the folder but not in the database?

i am trying to delete files for a user, and then update the database with the new bandwhitch/free space.  here is my code:

http://pastebin.com/J2XE9Fip

i just can't figure out where i'm going wrong... 

thanks in advance

Is it better to store uploaded images as 'content' in the database? (like he http://www.techsupportforum.com/forums/f49/tutorial-upload-files-to-database-176804.html).. Or just as a regular file which is referenced in the database..?

Maybe some of the great coders here can help this noob out.
So here is what I have so far:

Code: [Select]
//set age criteria for deletion
$age = 60;

//get current date
$datenow  = date("Y-m-d");

//set the range we want to delete
$delete_range = $datenow - $age;

//get old user_id from users table
$oldusers_users = mysql_query ("SELECT user_id FROM users WHERE lastvisit < $delete_range ");

//get user_id from images table that correspond to users table
$oldusers_images = mysql_query ("SELECT user_id FROM images WHERE $oldusers_users=user_id.images ");

//find folders that correspond to the usernames and delete
$oldusers_files = mysql_query ("SELECT username FROM users WHERE lastvisit < $delete_range ");
//print out username
//$result = mysql_($oldusers_files);
$foldername = mysql_result($oldusers_files, 0);

$sigspath = "sigs/";
unlink($sigspath . $foldername . ".gif/index.php");
rmdir($sigspath . $foldername . ".gif");
//now delete user_id's from database
mysql_query("DELETE * FROM users WHERE user_id=$oldusers_users");
mysql_query("DELETE * FROM images WHERE user_id=$oldusers_images");
unset($oldusers_users, $oldusers_images, $oldusers_files, $foldername, $sigspath );
mysql_close($link);
Right now it is only returning the first entry, not the entire list that meets the criteria.  It does delete that one file though but does not remover the rows from the database.

I am sure the database stuff is jacked up I am really new to that part.  What am I doing wrong here or is there a better way to do this perhaps

Basically I would like to place a link on my website and have the user download a file, but rather than just right clicking and choosing save target as, the link must be clicked, on the next page the file is fetched and then the client can download the file. How would I go about setting this up please?

When the download appears the link that is produced doesn't show the actual download either, so users can't leech of it.

Thanks