Advertisement
Gerst20051

Ruben's Link Clicks

Jul 1st, 2011
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!DOCTYPE html>
  2. <html lang="en" dir="ltr">
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Find Clicks</title>
  6. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js"></script>
  7. </head>
  8. <body>
  9. <a class="track" href="http://www.rbns.co.cc/" target="_blank">RBNS</a>
  10. <script>
  11. $(document).ready(function() {
  12.     $(".track").click(function() {
  13.         $.get('tracking_file.php?link='+$(this).attr('href'));
  14.     });
  15. });
  16. </script>
  17. </body>
  18. </html>
  19.  
  20. <?php
  21. if (isset($_GET['link']) && !empty($_GET['link'])) {
  22. $mysql = mysql_connect('localhost','user','pass');
  23. mysql_select_db('dbname');
  24. $query = 'UPDATE table_name SET clicks = clicks + 1 WHERE link = '.$_GET['link'];
  25. // OR
  26. $query = 'INSERT INTO table_name (link,clicks) VALUES ("'.$_GET['link'].'",1) ON DUPLICATE KEY UPDATE clicks=clicks+1';
  27. mysql_query($query) or die(mysql_error());
  28. mysql_close($mysql);
  29. }
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement