Jump to content

[SOLVED] Site Stats Script


Verrou

Recommended Posts

Ugh, there are a thousand ways of doing this...

 

Ok make a file called functions.php and paste this in it... (UNTESTED CODE)

 

<?php
function updateHits($day) {
// Some code here to work out the date... I don't know how to work with dates and times yet I'm still learning...
    $query = "UPDATE stats SET hits=hits+1, date='{$...}";
    $result = mysql_query($result);
    if(!$result) {
        return false;
    }
    return true;
}

function showAllHits() {
    $query = "SELECT * FROM stats";
    $result = mysql_query($result);
    if(!$result) {
        return false;
    }
    else {
        while($row = mysql_fetch_assoc($result)) {
            $total_hits = $row['hits'];
        }
        return $total_hits;
    }
}

function showHitsForToday() {
    // Some code here to work out todays date...
    $query = "SELECT * FROM stats WHERE date='{$...}'";
    $result = mysql_query($result);

    if(!$result) {
        return false;
    }
    else {
        while($row = mysql_fetch_assoc($result)) {
            $todays_hits = $row['hits'];
        }
        return $todays_hits;
    }
}
?>

 

Of course you'll need to create those database tables/fields and find a script that can find out if it's today or not...

 

Then just include the functions file at the top of every page and put updateHits(); after it... then use the other two functions to show either all hits or today's hits...

 

To show the IP Address I believe you would use:

 

<?php
echo $_SERVER['REMOTE_ADDR'];
?>

 

The time thing you see is done with Javascript, I don't know Javascript. Try DynamicDrive.com and the 3 things after it I have no idea what they are...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.