counter.php

<?php
    $root = $_SERVER['DOCUMENT_ROOT'];
    $root .= "/connect/config.php";
    require_once($root);

    @$db = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

    if($db == true){
        ////Counter sofern eine Verbindung zur db besteht
        ////Variabeln
        $tag     = date("d");
        $monat   = date("m");
        $jahr    = date("Y");
        $datum   = $tag . "." . $monat . "." . $jahr;
        $timestamp = time();
        $zeit = $timestamp-900; /// 15 Minuten
        $timenow = mktime(0,0,0,$monat,$tag,$jahr);
        $gestern = strtotime("-1 day");
        $alter_tag = date("d.m.Y",$gestern);
        $ort     = $_SERVER["REQUEST_URI"];
        $woher   = $_SERVER["HTTP_REFERER"];
        $browser = $_SERVER["HTTP_USER_AGENT"];
        $ip      = $_SERVER['HTTP_X_FORWARDED_FOR'];

        /// MySQL Abfragen
        $counter_new       = $db->query("SELECT * FROM `counter` WHERE `ip` = '$ip'");
        $counter_yesterday = $db->query("SELECT * FROM `counter_stats` ORDER BY id DESC");

        /// Ergebnisse
        $menge       = $counter_new->num_rows;
        $yesterday   = $counter_yesterday->fetch_array();

        /////Eintragung neuer Gaeste
        if($menge == 0){
            $db->query("INSERT INTO `counter`(`ip`,`browser`,`woher`,`ort`,`timed`) VALUES ('$ip','$browser','$woher','$ort','$timestamp')");
        }
        elseif($menge == 1){
            $db->query("UPDATE `counter` SET `timed`='$timestamp', `ort`='$ort', `browser`='$browser' WHERE `ip`='$ip'");
        }

        /// Ausgabe der Werte
        /// Abfrage fuer Ausgabe
        $counter_stats = $db->query("SELECT * FROM `counter` ORDER BY `id` DESC");
        $sql_online = $db->query("SELECT * FROM `counter` WHERE `timed` > '$zeit'");

        /// Ausgabe der Datenbankwerte
        $heute   = $counter_stats->num_rows;
        $gesammt = $counter_stats->fetch_array();
        $online  = $sql_online->num_rows;
        $gestern = $yesterday['guests'];

        $total = $gesammt['id'];
        $ausgabe = "Today: $heute | Total: $total | Online: $online | Yesterday: $gestern ";
        echo $ausgabe;
    }
    else{
        ////Variabeln setzen
        $ausgabe  = "Datenbank ist nicht erreichbar!";
        /// echo $ausgabe;
    }


    mysqli_close($db);
?>