About file links in the Mysql database

[Anon]

Hi,

Im storing the links of the files in the mysql database after the user uploads the file via a form. I want to find out whether the user clicked that link before or not after the file was uploaded. In other words I want to verify whether that particular file was viewed or not after uploading. Is there a way to do this in PHP???

Thanks in advance for your help.

Jason

[[deleted]]

You'll have to make some sort of redirecting script.
meaning: when you print the link, you don't actually print the link, but you print a link to a script that will redirect the user to the real URL.

That script can then first update a counter or a database field to store the "click", and then it can send a redirect to let the user view the real URL.