Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- site.com/url-del-articulo/?publishers=1435356P
- <?php
- $ServerName = "localhost";
- $Username = "root";
- $PassWord = "";
- $DataBase = "visitor_publishers";
- $con = new mysqli($ServerName, $Username, $PassWord, $DataBase);
- if ($con->connect_error) {
- exit("Error de conexión: " . $con->connect_error);
- }
- if (!$con->set_charset("utf8")) {
- printf("Error cargando el conjunto de caracteres utf8: %sn", $con->error);
- exit();
- }
- function getBrowserType($user_agent){
- if (strpos($user_agent, 'Opera') || strpos($user_agent, 'OPR/')) return 'Opera';
- elseif (strpos($user_agent, 'Edge')) return 'Edge';
- elseif (strpos($user_agent, 'Chrome')) return 'Chrome';
- elseif (strpos($user_agent, 'Safari')) return 'Safari';
- elseif (strpos($user_agent, 'Firefox')) return 'Firefox';
- elseif (strpos($user_agent, 'MSIE') || strpos($user_agent, 'Trident/7')) return 'Internet Explorer';
- return 'Other';
- }
- //https://stackoverflow.com/questions/6717926/function-to-get-user-ip-address
- //https://stackoverflow.com/questions/1634782/what-is-the-most-accurate-way-to-retrieve-a-users-correct-ip-address-in-php/2031935#2031935
- //https://stackoverflow.com/questions/13646690/how-to-get-real-ip-from-visitor
- //http://itman.in/en/how-to-get-client-ip-address-in-php/
- function GetIP(){
- 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){
- if (array_key_exists($key, $_SERVER) === true){
- foreach (array_map('trim', explode(',', $_SERVER[$key])) as $ip){
- if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE) !== false){
- return $ip;
- }
- }
- }
- }
- }
- //https://stackoverflow.com/questions/12369615/serverhttp-referer-missing
- $refferer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
- function selfURL() {
- $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : "";
- $protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
- $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]);
- return $protocol."://".$_SERVER['SERVER_NAME'].$port.$_SERVER['REQUEST_URI'];
- }
- function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); }
- ?>
- <?php
- require_once('visitors_connections.php');
- $visitor_ip = GetIP();
- $visitor_browser = getBrowserType($_SERVER['HTTP_USER_AGENT']);
- $visitor_date = date("Y-m-d H:i:s");
- $visitor_refferer = $refferer;
- $visited_page = selfURL();
- $stmt = $con->prepare("INSERT INTO visitors_table (visitor_ip, visitor_browser, visitor_date,
- visitor_refferer, visitor_page) VALUES (?, ?, ?, ?, ?)");
- $stmt->bind_param("sssss", $visitor_ip,$visitor_browser,$visitor_date,$visitor_refferer,$visited_page);
- $stmt->execute();
- ?>
Add Comment
Please, Sign In to add comment