Counter??

[obrienkev]

Hi all,

I want to create a hit counter that automatically inserts the number of hits into a database.

How do I do this? Any help would be great. I'm fine with database stuff just how do I get php to count hits?

Thanks.

Kevin.

[devinemke]

store the count as an integer in the db and increment it by 1 on each page request.

[obrienkev]

Yeah but do I have to set up sessions etc?? How do I know when a page is requested?? Any help on this please?

Thanks.

[devinemke]

embed to code to update the counter within your pages (perhaps via an [man]include[/man]). whenever the page is requested, the counter will update.

[obrienkev]

Could you please give me a quick run through of how this is done?

Thanks. I appreciate it.

[devinemke]

$result = mysql_query('UPDATE counter SET count = count + 1') or exit(mysql_error());
$result = mysql_query('SELECT count FROM counter') or exit(mysql_error());
echo mysql_result($result, 0);

[obrienkev]

Cheers. What variables should I set? How does the code know the page has been requested??

Here is all my code now:

<?php

	// Database connection
	@ $db = mysql_pconnect('localhost', 'user', 'pword');

	if (!$db)
	{
		echo 'Could not connect';
		exit;
	}

	mysql_select_db('test') or die ('No Database');

	$result = mysql_query('UPDATE counter SET count = count + 1') or exit(mysql_error()); 
	$result = mysql_query('SELECT count FROM counter') or exit(mysql_error()); 
	echo mysql_result($result, 0);

?>

[thorpe]

How does the code know the page has been requested?

it doesn't, but everytime your page IS requested, that code will run. thereby updateing your counter.