ilch.de :: Forum :: Allgemein :: HTML, PHP, SQL,...

Sonderanfertigung für dich ;-)

Die Datei per require_once('statistic.php'); einbinden (am Anfang des Scripts!) und die Box per require('stats.php'); an beliebiger Stelle einfügen.
Benötigte Tabellen:
- stats
- counter

statistic.php

<?php
session_start();
@mysql_connect('host', 'user', 'pass') or die ('Falsche Connection Daten');
@mysql_select_db('database') or die ('Falsche Datenbank');
 
 
function site_statistic_get_browser($useragent) {
          if (preg_match("=MSIE [0-9]{1,2}.[0-9]{1,2}.*Opera.([0-9]{1})=", $useragent, $browser)) {
              return "Opera ".$browser[1]." (als IE)";
          } elseif (preg_match("=MSIE ([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser)) {
              return "Internet Explorer ".$browser[1];
          } elseif (preg_match("=Opera/([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser)) {
              return "Opera ".$browser[1];
          } elseif (preg_match("=Konqueror=", $useragent)) {
              return "Konqueror";
          } elseif (preg_match("=Netscape/7.[0-9]{1,2}=", $useragent)) {
              return "Netscape Navigator 7";
          } elseif (preg_match("=^Mozilla.*Firefox\/(.*)$=", $useragent, $browser)) {
        return ("Firefox ".$browser[1]);
      } elseif (preg_match("=Mozilla/5.[0-9]{1,2}=", $useragent)) {
              return "Netscape Navigator 6";
          } elseif (preg_match("=Mozilla/([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser)) {
              return "Netscape Navigator ".$browser[1];
          } else {
              return 0;
          }
}
 
function site_statistic_get_os($useragent){
          if (preg_match("=Windows NT 5\.0|Windows 2000=", $useragent)) {
              return "Windows 2000";
          } elseif (preg_match("=Windows NT 5\.1|Windows XP=", $useragent)) {
              return "Windows XP";
            } elseif (preg_match("=Windows NT 6\.0|Windows Vista=", $useragent)) {
              return "Windows Vista";
            } elseif (preg_match("=Windows NT 5\.2|Windows Server 2003|Windows XP x64=", $useragent)) {
              return "Windows Server 2003\\Windows XP x64";
          } elseif (preg_match("=Windows NT 4\.0|Windows NT|WinNT4\.0=", $useragent)) {
              return "Windows NT";
          } elseif (preg_match("=Windows 98=", $useragent)) {
              return "Windows 98";
          } elseif (preg_match("=Windows 95=", $useragent)) {
              return "Windows 95";
          } elseif (preg_match("=Mac_PowerPC|Macintosh=", $useragent)) {
              return "Macintosh";
          } elseif (preg_match("=Linux=", $useragent)) {
              return "Linux";
          } elseif (preg_match("=SunOS=", $useragent)) {
              return "SunOS";
 
          } else {
              return 0;
          }
}
 
function site_statistic_get_referer ( $referer ) {
            if ( ! empty ($referer) ) {
              $refzar = parse_url($referer);
              $refspa = 'http://'.$refzar['host'].$refzar['path'];
            return $refspa;
          } else {
              return 0;
            }
}
 
if (!array_key_exists('ilchCMSstati',$_SESSION)) {
    $_SESSION['ilchCMSstati'] = 'geloggt';
    $d = date('j');
    $m = date('n');
    $y = date('Y');
    if ($_SERVER["HTTP_X_FORWARDED_FOR"]) $ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
    else $ip = $_SERVER["REMOTE_ADDR"];
    $ergResul = mysql_result(mysql_query("SELECT COUNT(ip) FROM stats WHERE ip = '".$ip."' AND `day` = ".$d." AND mon = ".$m." AND yar = ".$y ),0);
    if ( $ergResul == 0 ) {
        $os = site_statistic_get_os($_SERVER['HTTP_USER_AGENT']);
        $br = site_statistic_get_browser($_SERVER['HTTP_USER_AGENT']);
        $wt = date('w');
        $st = date('G');
        $ur = ( isset ($_SERVER['HTTP_REFERER']) ? site_statistic_get_referer($_SERVER['HTTP_REFERER']) : '' );
        mysql_query("INSERT INTO stats (wtag,stunde,`day`,mon,yar,os,browser,ip,ref)
            VALUES(".$wt.",".$st.",".$d.",".$m.",".$y.",'".$os."','".$br."','".$ip."','".$ur."')");
 
        $dc = ( strlen ($d) == 1 ? '0'.$d : $d );
        $mc = ( strlen ($m) == 1 ? '0'.$m : $m );
        $cdate = $y.'-'.$mc.'-'.$dc;
        $query = "SELECT COUNT(date) FROM `counter` WHERE `date` = '".$cdate."'";
        if ( mysql_result(mysql_query($query),0) == 0 ) {
            mysql_query('INSERT INTO `counter` (`date`,`count`) VALUES ( "'.$cdate.'" , "1" ) ' );
        } else {
            mysql_query('UPDATE `counter` SET `count` = `count` +1 WHERE `date` = "'.$cdate.'"');
        }
    }
}
?>

stats.php

<?php
$heute = date ('Y-m-d');
     
$ges_visits = @mysql_result(mysql_query("SELECT SUM(count) FROM counter"),0);
$ges_heute  = @mysql_result(mysql_query("SELECT count FROM counter WHERE date = '".$heute."'"),0);
$ges_gestern = @mysql_result(mysql_query('SELECT count FROM counter WHERE date < "'.$heute.'" ORDER BY date DESC LIMIT 1'),0);
 
     
echo 'Insgesamt: '.$ges_visits.'<br />';
echo 'Heute: '.$ges_heute.'<br />';
echo 'Gestern: '.$ges_gestern;
?>

install.sql (importieren)

CREATE TABLE `counter` (
  `date` date NOT NULL,
  `count` smallint(5) NOT NULL default '0'
) TYPE=MyISAM;
 
CREATE TABLE `stats` (
  `wtag` tinyint(2) NOT NULL default '0',
  `stunde` tinyint(2) NOT NULL default '0',
  `day` tinyint(2) NOT NULL default '0',
  `mon` tinyint(2) NOT NULL default '0',
  `yar` int(4) NOT NULL default '0',
  `os` varchar(50) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `ref` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

Zuletzt modifiziert von Ithron am 09.07.2008 - 18:16:58

Geschlossen

	Zurück zu HTML, PHP, SQL,...

Beitrag zur Merkliste hinzufügen

ilch Forum » Allgemein » HTML, PHP, SQL,... » Pre-Page Code