Linux, Apache, MySQL, PHP

Hi,

I am trying the URL rewriting for the first time on mysql server (Dreamhost).

I have create .htaccess file with the following:

RewriteEngine on
RewriteRule ^contact$ /contact.php [L]
RewriteRule ^team$ /team.php [L]


I suppose this will show www.mydomain.com/contact.php as www.mydomain.com/contact (without the extension) and that's what I want..

and it's working fine.. when I type www.mydomain.com/contact I am getting the page BUT.... I also get www.mydomain.com/contact.php when I type? so is there anyway NOT to show it with .php and just /contact?

hope i explained it well..

$url = "https://www.google.com/accounts/AuthSubSessionToken";
$token = $token;
$param['sigalg'] = "rsa-sha1";
$nonce = "15948".time()."49418";  // any random no(20 digit)
$param['data'] = "GET https://www.google.com/accounts/AuthSubSessionToken ".time()." ".$nonce;		
$private_key = "MY_PRIVATE_KEY";
		
$kvpairs = array();
foreach ($param as $k => $v) {
array_push($kvpairs, ($k . '=' . $v));
}		
	$query_string = '';
	$query_string = implode('&', $kvpairs);
	$base_string = 'GET'.'&'.$url .'&'.$query_string;
	$param['sig'] =  base64_encode(hash_hmac('sha1', $base_string, $private_key, true));
	uksort($param, 'strcmp');
	$header = 'Authorization: AuthSub token="'.$token.'" ';
        foreach ($param as $k => $v) 
        {
        	$header .= $k . '="' .$v. '" ';
        }
        
        $header = trim($header," ");
	$headers[]= $header;
	$ch = curl_init();
	curl_setopt($ch, CURLOPT_URL,$url);
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
	curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
	curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
	$responce = curl_exec($ch);
	curl_close($ch);

Database: file_management

Tables: file_details, file_data

file_details:
FileID - int(10) AUTO_INCREMENT
FileTypeID - int(10)
FileType - varchar(60)
FileName - varchar(255)
FileDescription - varchar(255)
FileSize - bigint(20)
FileUploadDate - datetime
FileUploadBy - int(5)

file_details:
FileDataID	 - int(10) AUTO_INCREMENT
FileID - int(10)
FileData - BLOB

<?php

/* Processing for streaming files to the client */

ini_set('display_errors',1);
error_reporting(E_ALL & ~E_NOTICE);

$strDB=mysql_connect("localhost","username","password")or die ("Error connecting to mysql.. Error: (" . mysql_errno() . ") " . mysql_error());
$database=mysql_select_db("file_management",$strDB);

if (isset($_GET["id"])) {

	// List of nodes representing each 64kb chunk
	$nodelist = array();
		
	// Pull file meta-data
	$sql_GetFileDetails = "
	SELECT 
	FileID,
	FileTypeID,
	FileType,
	FileName,
	FileDescription,
	FileSize,
	FileUploadDate,
	FileUploadBy
	FROM file_details WHERE FileID = '".$_GET["id"]."';";
	
	$result_GetFileDetails = mysql_query($sql_GetFileDetails) or die ("No results for this FileID.<br>Your Query: " . $sql_GetFileDetails . "<br> Error: (" . mysql_errno() . ") " . mysql_error());
	
	if (mysql_num_rows($result_GetFileDetails) != 1) { die ("A MySQL error has occurred.<br>Your Query: " . $sql_GetFileDetails . "<br> Error: (" . mysql_errno() . ") " . mysql_error()); }
	
	// Set the file object to get details from
	$FileDetailsArray = mysql_fetch_assoc($result_GetFileDetails);
	
	// Pull the list of file inodes
	$sql_GetFileDataNodeIDs = "SELECT FileDataID FROM file_data WHERE FileID = ".$_GET["id"]." order by FileDataID";
	
	if (!$result_GetFileDataNodeIDs = mysql_query($sql_GetFileDataNodeIDs)) { die("Failure to retrive list of file inodes<br />Your Query: " . $sql_GetFileDataNodeIDs . "<br /> Error: (" . mysql_errno() . ") " . mysql_error()); }
	
	while ($row_GetFileDataNodeIDs = mysql_fetch_assoc($result_GetFileDataNodeIDs)) {
		$nodelist[] = $row_GetFileDataNodeIDs["FileDataID"];
	}
	
	
	$FileExtension = explode(".",$FileDetailsArray["FileName"]);
	$FileExtension = strtolower($FileExtension[1]);
	
	// Determine Content Type 
	switch ($FileExtension) { 
	
		case "mp3":		$ctype="audio/mp3"; break;
		case "wav":		$ctype="audio/wav"; break;
		case "pdf":		$ctype="application/pdf"; break;
		//case "exe":		$ctype="application/octet-stream"; break;
		case "zip":		$ctype="application/zip"; break;
		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="application/force-download"; break; // This forces download, instead of viewing in browser.
		case "png":		$ctype="application/force-download"; break; // This forces download, instead of viewing in browser.
		case "jpeg":	$ctype="application/force-download"; break; // This forces download, instead of viewing in browser.
		case "jpg":		$ctype="application/force-download"; break; // This forces download, instead of viewing in browser.
		default: 		$ctype="application/force-download"; 		// This forces download, instead of viewing in browser.
	} 
	
	// Send down the header to the client
	

	header("Date: ".gmdate("D, j M Y H:i:s e", time()));
	header("Cache-Control: max-age=2592000");
	//header("Last-Modified: ".gmdate("D, j M Y H:i:s e", $info['mtime']));
	//header("Etag: ".sprintf("\"%x-%x-%x\"", $info['ino'], $info['size'], $info['mtime']));
	header("Accept-Ranges: bytes");
	//header("Cache-Control: Expires ".gmdate("D, j M Y H:i:s e", $info['mtime']+2592000));
	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("Content-Description: File Transfer");
	header("Content-Disposition: attachment; filename=\"".$FileDetailsArray["FileName"]."\"");
	header("Content-Transfer-Encoding: binary");
	header("Content-Type: ".$FileDetailsArray["FileSize"]);

	ob_end_clean();
	ob_start();
	ob_start("ob_gzhandler");
	
		$sql_GetFileDataBlobs = "SELECT FileData FROM file_data WHERE FileID = ".$_GET["id"]." ORDER BY FileDataID ASC;";
		
		if (!$result_GetFileDataBlobs = mysql_query($sql_GetFileDataBlobs)) { die("Failure to retrive list of file inodes<br />Your Query: " . $sql_GetFileDataBlobs . "<br /> Error: (" . mysql_errno() . ") " . mysql_error()); }
		
		while ($row_GetFileDataBlobs = mysql_fetch_array($result_GetFileDataBlobs)) {
			echo $row_GetFileDataBlobs["FileData"];
		}

	
	ob_end_flush();
	header('Content-Length: '.ob_get_length());
	ob_end_flush();
		
}
?>