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