Guest User

Untitled

a guest
Aug 9th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.74 KB | None | 0 0
  1. site.com/url-del-articulo/?publishers=1435356P
  2.  
  3. <?php
  4. $ServerName = "localhost";
  5. $Username = "root";
  6. $PassWord = "";
  7. $DataBase = "visitor_publishers";
  8.  
  9. $con = new mysqli($ServerName, $Username, $PassWord, $DataBase);
  10. if ($con->connect_error) {
  11. exit("Error de conexión: " . $con->connect_error);
  12. }
  13. if (!$con->set_charset("utf8")) {
  14. printf("Error cargando el conjunto de caracteres utf8: %sn", $con->error);
  15. exit();
  16. }
  17.  
  18. function getBrowserType($user_agent){
  19. if (strpos($user_agent, 'Opera') || strpos($user_agent, 'OPR/')) return 'Opera';
  20. elseif (strpos($user_agent, 'Edge')) return 'Edge';
  21. elseif (strpos($user_agent, 'Chrome')) return 'Chrome';
  22. elseif (strpos($user_agent, 'Safari')) return 'Safari';
  23. elseif (strpos($user_agent, 'Firefox')) return 'Firefox';
  24. elseif (strpos($user_agent, 'MSIE') || strpos($user_agent, 'Trident/7')) return 'Internet Explorer';
  25. return 'Other';
  26. }
  27.  
  28. //https://stackoverflow.com/questions/6717926/function-to-get-user-ip-address
  29. //https://stackoverflow.com/questions/1634782/what-is-the-most-accurate-way-to-retrieve-a-users-correct-ip-address-in-php/2031935#2031935
  30. //https://stackoverflow.com/questions/13646690/how-to-get-real-ip-from-visitor
  31. //http://itman.in/en/how-to-get-client-ip-address-in-php/
  32. function GetIP(){
  33. foreach (array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR') as $key){
  34. if (array_key_exists($key, $_SERVER) === true){
  35. foreach (array_map('trim', explode(',', $_SERVER[$key])) as $ip){
  36. if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE) !== false){
  37. return $ip;
  38. }
  39. }
  40. }
  41. }
  42. }
  43.  
  44. //https://stackoverflow.com/questions/12369615/serverhttp-referer-missing
  45. $refferer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
  46.  
  47. function selfURL() {
  48. $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : "";
  49. $protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
  50. $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]);
  51. return $protocol."://".$_SERVER['SERVER_NAME'].$port.$_SERVER['REQUEST_URI'];
  52. }
  53. function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); }
  54. ?>
  55.  
  56. <?php
  57. require_once('visitors_connections.php');
  58.  
  59. $visitor_ip = GetIP();
  60. $visitor_browser = getBrowserType($_SERVER['HTTP_USER_AGENT']);
  61. $visitor_date = date("Y-m-d H:i:s");
  62. $visitor_refferer = $refferer;
  63. $visited_page = selfURL();
  64.  
  65.  
  66. $stmt = $con->prepare("INSERT INTO visitors_table (visitor_ip, visitor_browser, visitor_date,
  67. visitor_refferer, visitor_page) VALUES (?, ?, ?, ?, ?)");
  68. $stmt->bind_param("sssss", $visitor_ip,$visitor_browser,$visitor_date,$visitor_refferer,$visited_page);
  69. $stmt->execute();
  70. ?>
Add Comment
Please, Sign In to add comment