webForumDet fria alternativet

Klickräknare!

1 svar · 294 visningar · startad av cindra

cindraMedlem sedan juli 200416 inlägg
#1

Gokväll!

Jag har hämtat hem ett script som räknar antalet klick på mina länkar. Allting funkar perfekt men jag vill att man ska kunna se resultatet på min sida o inte bara i databasen.

Hur ska jag skriva för att antalet klick ska visas på sidan?

Skriptet ser ut såhär:

<?php
### --- ID: go.php :: 24/05/2002 --- ###
### --- Outgoing Links counter (uses PHP and MySQL) --- ###
### --- Made for Juicystudio Techmail --- ###
### Define variables
$yoursite = "http://www.yoursite.com/";
### Define database values
$dbhost = "";          // database host
$dbuser = "";          // database username
$dbpassword = "";      // database password
$db2use = "";          // name of database
?>

<?php
### --- NO CHANGES BELOW THIS LINE --- ###
function dbconnect() 
{
    global $dbhost, $dbuser, $dbpassword, $db2use;
    $link = @mysql_connect($dbhost,$dbuser,$dbpassword) 
        or die("Connection failed: Please try later.");
    @mysql_select_db($db2use,$link) 
        or die("Connection to database refused: Please try later.");
    return $link;
}
// Connect to database
dbconnect();
if (!empty($site)) 
{
    $qry = "SELECT hits FROM url_redirect WHERE site = '$site'"
    $hitcounter = mysql_query($qry);
    $hitcount = mysql_fetch_array($hitcounter);
    $hits = $hitcount[0];
    // next check if URL is in database
    if ($hits == 0) 
    {
        //  if not then add it!
        $newurl = "INSERT INTO url_redirect (site,hits) VALUES('$site',1)";
    }
    else 
    {
        // Site already exists so just update the hit count
        $newurl = "UPDATE url_redirect SET hits=$hits+1 WHERE site='$site'";
    }
    mysql_query($newurl);
    mysql_close();
    // re-direct to the required site as defined 
    // in the "go.php?site" link
    header ("Location: $site");
    exit;
}
else 
{
    // site variable not entered, so redirect back to
    // "yoursite" as defined above
    header ("Location: $yoursite");
    exit;
}
?>
PeddaMedlem sedan juni 20006 032 inlägg
#2
$antal = "SELECT hits FROM url_redirect WHERE site = 'sidansnamn'"
133 ms totalt · 3 externa anrop · v20260731065814-full.30151723
131 ms — hämta forumlista (db)
0 ms — hämta statistik (cache)
130 ms — hämta tråd, inlägg och bilagor (db)