Re: Simple Example of Passing on a file through a PHP script

From: Date: Wed, 03 Jul 2002 20:56:09 +0000
Subject: Re: Simple Example of Passing on a file through a PHP script
Groups: php.general 
Request: Send a blank email to php-general+get-105302@lists.php.net to get a copy of this message
>I want to show info when my docs are viewed though my stats program. I have >decieded the best way would be to put the info into a DB through php file >then output the PDF, Excel, Zip or Powerpoint file. > >Only trouble is I have no Idea how to do this Stuffing the actual data into your database doesn't really give you much added value to tracking who is viewing it... Write something like this: ---------- display.php ---------------------- <?php $query = "update stats set count = count + 1 where filename = '$filename'"; mysql_query($query) or error_log(mysql_error()); # If it's the first time this file has ever been displayed... if (mysql_affected_rows() < 1){ $query = "insert into stats(filename, count) values('$filename', 1)"; mysql_query($query) or error_log(mysql_error()); } readfile($filename); ?> --------------------------------------------- You can then put your PDF files *outside* your web-tree so nobody can read them, except like: http://yourserver.com/display.php?filename=foo.pdf -- Like Music? http://l-i-e.com/artists.htm

« previous php.general (#105302) next »