5 replies to this topic

[Tupling]

I have been looking for some time now to find something to steer me in the right direction.

I am looking to code a simple page view counter. Similar to the one used on Pixel2life for how many times a tutorial as been viewed...

Maybe i have overlooked it and didn't realize it but could someone steer me in the right direction please...

Thanks!

[derek.sullivan]

I use mysql...

this is what I do, this is just a basic overview you may have to change some things

<?php

$tid = mysql_escape_string($_GET['tid']); // tutorial id

$sql = mysql_query("SELECT * FROM `tutorials` WHERE `id` = '$tid'") or die (mysql_error());

$fetch = mysql_fetch_array($sql);

$num = 1;

$views = $fetch['views'];

$add = $num + $views;

mysql_query("UPDATE `tutorials` SET `views` = '$add' WHERE `id` = '$tid'") or die (mysql_error());

// etc etc

?>

Again, that is a basic overview of what I use. Someone else may have something else

[Pr0oF]

It can be managed even with one line.

mysql_query("update `table` set `field` = (`field`+1) where `id` = '$id'");

[derek.sullivan]

Pr0oF, on Dec 29 2008, 01:31 PM, said:

It can be managed even with one line.

mysql_query("update `table` set `field` = (`field`+1) where `id` = '$id'");

what he said lol

[Pr0oF]

bigdfbc2008, on Dec 29 2008, 10:12 PM, said:

what he said lol

m? something wrong?

[derek.sullivan]

na nothing wrong, just never knew it could be done that way