health_html/inc/tracker.php

<?php
        $ref = $HTTP_SERVER_VARS["HTTP_REFERER"];
        $idx = strpos($ref, "?");
        if (!($idx === false)) $ref = substr($ref, 0, $idx);
        $tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"];
        $idx = strpos($tgt, "?");
        if (!($idx === false)) $tgt = substr($tgt, 0, $idx);
        $ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref);
        $tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt);
        if ($ref && $tgt) {
                include("inc/conn.php");
                $sth = $dbh->prepare("SELECT count FROM tracker WHERE (referer = '$ref') AND (target = '$tgt')");
                $row = "";
                if ($sth) {
                        if ($sth->execute()) $row = $sth->fetchrow_array();
                        $sth->finish();
                }
                if ($row) $sql = "UPDATE tracker SET count = count + 1 WHERE (referer = '$ref') AND (target = '$tgt')";
                        else $sql = "INSERT INTO tracker (referer, target, count) VALUES ('$ref', '$tgt', 1)";
                $dbh->dbh_do($sql);
                $dbh->disconnect();
        }
?>
1	<?php
2	$ref = $HTTP_SERVER_VARS["HTTP_REFERER"];
3	$idx = strpos($ref, "?");
4	if (!($idx === false)) $ref = substr($ref, 0, $idx);
5	$tgt = $HTTP_SERVER_VARS["SERVER_NAME"]."/".$HTTP_SERVER_VARS["REQUEST_URI"];
6	$idx = strpos($tgt, "?");
7	if (!($idx === false)) $tgt = substr($tgt, 0, $idx);
8	$ref = ereg_replace('index\.([A-Za-z0-9]+)$', '', $ref);
9	$tgt = ereg_replace('index\.([A-Za-z0-9]+)$', '', $tgt);
10	if ($ref && $tgt) {
11	include("inc/conn.php");
12	$sth = $dbh->prepare("SELECT count FROM tracker WHERE (referer = '$ref') AND (target = '$tgt')");
13	$row = "";
14	if ($sth) {
15	if ($sth->execute()) $row = $sth->fetchrow_array();
16	$sth->finish();
17	}
18	if ($row) $sql = "UPDATE tracker SET count = count + 1 WHERE (referer = '$ref') AND (target = '$tgt')";
19	else $sql = "INSERT INTO tracker (referer, target, count) VALUES ('$ref', '$tgt', 1)";
20	$dbh->dbh_do($sql);
21	$dbh->disconnect();
22	}
23	?>