<?php 
require_once ('inc/core.php');

$file_id = $_GET['file_id'];

$sql = 'SELECT * FROM t_files WHERE file_id='.$file_id;
$stmt = $dbh->prepare($sql);
$stmt->execute();
$count = $stmt->rowCount();
if ( $count > 0 ) {
	foreach($dbh->query($sql) as $row ){
		$file_extension= $row['file_type'];
		$row['file_path'] = str_replace("/home/ee/prac/desire/WWW", "/home/ee1/prac/desire/WWW", $row['file_path']);
		$file_path = $row['file_path'];
		$file_name = $row['file_title'];
		$pos1 = strrpos( $file_path, "\\" );
		$pos2 = strrpos( $file_path , "/" );
		$pos = ( $pos1 > $pos2 ? $pos1 : $pos2 );
		$file =  substr( $file_path, $pos+1 , strlen( $file_path ));
	}
}
 
switch( $file_extension )
{
  case "application/pdf": case "pdf": $ctype="application/pdf"; break;
  case "exe": $ctype="application/octet-stream"; break;
  case "zip": $ctype="application/zip"; break;
  case "application/msword": case "doc": $ctype="application/msword"; break;
  case "xls": $ctype="application/vnd.ms-excel"; break;
  case "ppt": $ctype="application/vnd.ms-powerpoint"; break;
  case "gif": $ctype="image/gif"; break;
  case "png": $ctype="image/png"; break;
  case "jpeg":
  case "jpg": $ctype="image/jpg"; break;
  default: $ctype="application/force-download";
}
header("Pragma: public"); // required
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false); // required for certain browsers 
header('Accept-Charset: UTF-8');
header('Content-Type: '.$ctype.' charset="UTF-8";');


$filename = htmlspecialchars($file_name, ENT_COMPAT, 'UTF-8');
header("Content-Disposition: attachment; filename=\"".basename($filename)."\"; charset=\"UTF-8\";" );
header("Content-Transfer-Encoding: binary");
header("Content-Length: ".filesize($file_path));
@readfile($file_path);
exit(); 
?>