Hi Hope someone can advice on how am I to write a php code to track unique user count for every click. Thinking of creating a table about counting with the fields as id, count and clicked. ID - Article ID Count - Counting the number of clicks Clicked - Track userid from another table How am I to insert the userid from another table into the clicked field when the user clicks on count button? What I am saying is that a user has read an article and once finish reading, he will click on the count button to record as 1 count and his userid will be recorded in the clicked field. This clicked field will be checked again when another user click on the count button to ensure that it is not the same user. Once verify not the same user, it will record the userid in the clicked field. Example: ID Count Clicked 01 2 21, 53 02 5 5, 23, 49 For ID - 01, it has 2 counts and Clicked by userid 21, 53. For ID - 02, it has 5 counts and clicked by userid 5,23, 49. Any help will be greatly appreciated.
To record userid or whatever have a session variable and insert that session variable into this table once they click the button. To check if its unique do a query looking for their userID and that documents ID. Then using mysql_num_rows see if it has 0 - if so then add one to the count and record userID etc.
You could save the IP address of the user in a separate row, and check against that when adding a new user, to make sure clicks are unique.
My problem is that I do not know how to write the program to add the ip address in the IP Field and check for unique click. Also, how to program it to write a new IP address in the same IP Field for the same article ID. I am really lost how to do it.