1

<?php




function get_client_ip() {
    $ipaddress = '';
    if (isset($_SERVER['HTTP_CLIENT_IP']))
        $ipaddress = $_SERVER['HTTP_CLIENT_IP'];
    else if(isset($_SERVER['HTTP_X_FORWARDED_FOR']))
        $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
    else if(isset($_SERVER['HTTP_X_FORWARDED']))
        $ipaddress = $_SERVER['HTTP_X_FORWARDED'];
    else if(isset($_SERVER['HTTP_FORWARDED_FOR']))
        $ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
    else if(isset($_SERVER['HTTP_FORWARDED']))
        $ipaddress = $_SERVER['HTTP_FORWARDED'];
    else if(isset($_SERVER['REMOTE_ADDR']))
        $ipaddress = $_SERVER['REMOTE_ADDR'];
    else
        $ipaddress = '123.123';
    return $ipaddress;
}


function CountVisits(){
//besøgsTæller
$server = "127.0.0.1";
$dbname = "test";
$username = "root";
$pass = "";

try{

    $con = new PDO("mysql:host=127.0.0.1;dbname=test", "root", "");
    $con->Setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


}
catch(PDOexception $e){

    echo "Connection failed:".$e->GetMessages();

}



$ip = get_client_ip();



$statement = $con->prepare("SELECT * FROM visits WHERE ip=:ip");
$statement->execute(array(":ip"=>$ip));
$checkip = $statement->rowCount();

if($checkip == 0 ){

    $statement = $con->prepare("INSERT INTO visits (ip) VALUES (:ip)");
    $statement->execute(array(":ip"=>$ip));
}



}
function CountVisitsGet(){
    $server = "";
    $dbname = "";
    $username = "";
    $pass = "";
    try{

        $con = new PDO("mysql:host=127.0.0.1;dbname=test", "root", "");
        $con->Setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


    }
    catch(PDOexception $e){

        echo "Connection failed:".$e->GetMessages();

    }

    $statement = $con->prepare("SELECT * FROM visits");
    $statement->execute();
    $cnt = $statement->rowCount();

    return $cnt;


}


?>