i wrote a download system in php so that my downoad links look like
i also wrote further code so that the user's ip address, the date of the download, and the file downloaded are recorded in a database which i can view from a php page i made to pull this data from the database. problem is, the code i use to log all this doesn't work. the code is below. someone plz help.
| Quote: |
| http://www.mysite.frih.net/download.php?file=100 |
| Code: |
| $datetime = date('d M Y h:i:s a');
$ip = $_SERVER['REMOTE_ADDR']; $querystat = "INSERT INTO stats (id, ip, date/time) VALUES('$file','$ip','$datetime')"; $resultstat = mysql_query($querystat); if (!$result){ echo("Database Error"); |
