---
title: "Klickräknare!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/113521-klickräknare"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "cindra"
published: "2004-10-13T21:39:40.000Z"
updated: "2004-10-14T10:56:22.000Z"
replies: 1
views: 297
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/113521-klickräknare"
---

# Klickräknare!

## #1 — cindra, 2004-10-13T21:39Z

**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;
}
?>
```

Permalänk: https://www.webforum.nu/p/113521

## #2 — Pedda, 2004-10-14T10:56Z

```php
$antal = "SELECT hits FROM url_redirect WHERE site = 'sidansnamn'"
```

Permalänk: https://www.webforum.nu/p/1459462

---

Tråden på webben: https://www.webforum.nu/amne/php/113521-klickräknare