How to make a click counter.

[magebash]

I need help on making a click counter.  It just needs to be able to count each time a person clicks on a link and put it in my database. If you can help please post here.

Thanks. 

[irvieto]

There are a few ways to make a click counter.

 

An Easy way is to keep the "counter value" inside a file. So, everytime an user clicks on link like

<a href="count_my_click.php">Click here<a>

the php script will open the file, take its value into a variable, increase it and save it into the file again. When the work is done, you set a new header and continue to the wanted url.

 

/* ****
Content of count_my_click.php
*/

$file_handler = fopen("click.txt","w+");
/* bla,bla... get file data, increase it, bla bla.*/
fclose($file_handler);
###  The job is done!! counter increased :-)

header("Location:another_web.html");

[marcus]

Silly he wanted it to update his database.

 

<?php

$sql = "UPDATE `users` SET `clicks`=`clicks`+1 WHERE `uid`='".$_SESSION['uid']."'";
$res = mysql_query($sql) or die(mysql_error());

?>