add to database when user downloads a file

[enigma]

I would like to be able to add a yes/no to a field in a 'user' database when a logged in user clicks on a link to download a file.
The site I have built stores docs and applications. and my client would like to know which user has downloaded a certain application (clicked on a button to 'download' and installer file.
Is this possible?

[freshnet]

definitely. I'd do it using a form, then you can use

Code: Select all

isset($_POST['submit'])

to test whether the form has been submitted. You can then use if to run the query.

[enigma]

I am a newbie, so don't have a clue where to start with coding...

Any help greatly appreciated.

[freshnet]

Do you have your database created or a basic knowledge of PHP/SQL?

[danceinsky]

basic knowledge of PHP/SQL?



Rc Helicopters Reviews|Rc Helicopter

[NigelRen]

It would be worth creating a new database table which has the user and the file identifiers on it. Then when a user has downloaded a file you can insert a record into this table which indicates which user has downloaded which files. You could include a date as well so that you can see when they have downloaded it.
Have a go at creating the table and writing some code, if you still have problems then post your code and I'm sure someone will help.