Problem with PDF download script and database
Posted: Tue May 09, 2006 6:29 pm
This script works fine, except it does 2 inserts for every 1 PDF download. I can't figure out why. Any help would be greatly aprreciated.
Code: Select all
<?php
session_start();
header("Cache-control: private");
$_SESSION['validuser'] = "validuser";//for testing
if(isset($_SESSION['validuser'])){
$hostname = xxx;
$username = xxx;
$password = xxx;
$database = xxx;
$mysql_link = mysql_pconnect($hostname,$username,$password) or die (mysql_error());
mysql_select_db($database, $mysql_link) or die (mysql_error());
$q2 = "insert into pdflog (user_id, pdf_id, access_date) values ('30','3', NOW())";
$res2 = mysql_query($q2, $mysql_link);
$path = '/www/pdfs/'."test.pdf";
header('Content-Type: application/pdf');
$fp = fopen($path, 'rb');
fpassthru($fp);
}else{
echo "error";
exit;
}
?>