download/link counter

[Readme]

I have a link on my website and would be very interested to find out how many people click that link. Does anyone know any free click counter scripts?

 

Thanks

[revraz]

If you have access to a DB, just write one.  Shouldn't be hard at all.

[Readme]

If you have access to a DB, just write one.  Shouldn't be hard at all.

 

Yes, I have DB

 

just write one - low skill

 

I need full code

 

 

[redarrow]

see if that works mate.....

 

<?php

//database connection.

$x=$_POST['x'];

$x="GO TO GOOGLE";

echo "<a href='http://google.com'>$x</a>";

$sql="UPDATE link_counter set count=count+1 WHERE x='$x'";
$res=mysql_query($sql)or die(mysql_error());
?>

 

 

database name: link_counter

 

id int not null auto_increment primary_key

count int not null deafult 0

x text not null default GO TO GOOGLE

 

 

[Readme]

hmm

Connected to MySQL

GO TO GOOGLENo database selected

 

<?php

$username = "xxx";
$password = "xxx";
$hostname = "xxx"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
  or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";


$x=$_POST['x'];

$x="GO TO GOOGLE";

echo "<a href='http://google.com'>$x</a>";

$sql="UPDATE link_counter set count=count+1 WHERE x='$x'";
$res=mysql_query($sql)or die(mysql_error());
?>

 

Something wrong

[revraz]

You forgot your DB Connect line.

[Readme]

horrible 

 

GO TO GOOGLE Table 'link_counter.link_counter' doesn't exist

 

<?php

$dbhost = "localhost"; 
$dbuser = "root"; 
$dbpass = ""; 
$dbname = "link_counter"; 

//connect 
$db = mysql_pconnect($dbhost,$dbuser,$dbpass); 
mysql_select_db("$dbname",$db); 


$x=$_POST['x'];

$x="GO TO GOOGLE";

echo "<a href='http://google.com'>$x</a>";

$sql="UPDATE link_counter set count=count+1 WHERE x='$x'";
$res=mysql_query($sql)or die(mysql_error());
?>

[DarkerAngel]

Do you have your MySQL database/table structure built?

 

From the error I assume not.

 

Your Database would be "link_counter"

 

And your Table would be "link_counter"

 

The way you have this code written.

 

 

[Readme]

uups

Do you have your MySQL database/table structure built?

 

No

 

im noobie

[Readme]

Do you have your MySQL database/table structure built?

 

How do make that?