I want to write php script along with mysql database to do the following

It should get the following information about the user and store them in the mysql database

User IP
Referrer
Landing Page
Pages visited during visit
Number of visits during the day
Time spent on visit


How this can be done,any hint in this regard will be highly appreciated
Please also let me know if there are some already made scripts for doing the same

Most web stats programs can do this for you. You may already have a suitable script on your server.

If you are writing your own, User IP, Referrer, and Landing Page are easy enough to determine. Look on php.net under 'environmental variables'.

Pages visited during visit, Number of visits during the day, and Time spent on visit are a little harder. How do you plan on identifying multiple impressions from the same user? You can either use session variables, cookies, or IP addresses (only works with static IPs).

Rufo

I have cpanel which does have weblog script but it doesnt gives useful info like tables it just creates mess into the log.

Do you have script which i can use.
Thanks for your time

I am bascially looking to detect illegal clicks as i am using adwords for getting traffic

This is easy!

Firstly, you'll need to get all of the details:

PHP Code:

    $agent = $_SERVER['HTTP_USER_AGENT'];

    $uri = $_SERVER['REQUEST_URI'];

    $user = $_SERVER['PHP_AUTH_USER'];

    $ip = $_SERVER['REMOTE_ADDR'];

    $ref = $_SERVER['HTTP_REFERER'];

    $dtime = date('r'); 


Now, the username and referrer details can sometimes be empty, so lets fill them with something.

PHP Code:

    if($ref == ""){
        $ref = "None";
    }
    if($user == ""){
        $user = "None";
    } 


Now, connect to your database.

PHP Code:

        $dbhost = "localhost";
        $dbuser = "username";
        $dbpass = "password";
        $dd = "database";
    $connection = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
    mysql_select_db($db, $connection) or die(mysql_error()); 


Lastly, insert the details into the database. Lets say the table is "Visitors"

PHP Code:

$sql = "INSERT INTO `Visitors` VALUES (ip="$ip", url="$uri".......)";
mysql_query($sql) or die("Error"); 


The .... is where you enter the rest of the details. You get the picture.
Hope this helps!