Dysan Posted November 15, 2007 Share Posted November 15, 2007 Every time a link is clicked, how do I keep a record of the number of clicks a link has received, and store the results in a database? Link to comment https://forums.phpfreaks.com/topic/77469-log-amount-of-clicks/ Share on other sites More sharing options...
kratsg Posted November 15, 2007 Share Posted November 15, 2007 Make all links go to "log.php" which contains source code to update the database with all the relevant details, then redirect the page to the URL provided. IE: http://www.yoursite.com/log.php?url=games.php However, downfalls for this include that you cannot go to games.php?id=5 without more extensive coding. Link to comment https://forums.phpfreaks.com/topic/77469-log-amount-of-clicks/#findComment-392170 Share on other sites More sharing options...
khalidorama Posted November 15, 2007 Share Posted November 15, 2007 HI, your code should query the column in the table. and then load the stored value to memory , just increment it and update the value in the table... so simple to do.. Link to comment https://forums.phpfreaks.com/topic/77469-log-amount-of-clicks/#findComment-392219 Share on other sites More sharing options...
Dysan Posted November 15, 2007 Author Share Posted November 15, 2007 I'm new to PHP, can you both give me an example on how you would achieve this? Link to comment https://forums.phpfreaks.com/topic/77469-log-amount-of-clicks/#findComment-392232 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.