Auto Insert

[Neebski]

Hey there, I am trying to put together a log type database of where each user goes and what pages they view. How can I automatically add an entry into my log db each time the page loads? (As of right now it only logs things when a button is pushed)

Thanks!
- Kevin Neberman

[Twey]

<?php
$f = fopen('user_activity.log');
fwrite($f, sprintf('&#37;s: %s viewed %s.', date('r'), $username, $_SERVER['REQUEST_URI']));
fclose($f);
?>

[tech_support]

It'd be much better to use MySQL if you have a lot of users. Some logs go 10GB+ on active websites.

[Twey]

Oh yes, you actually said "database." Missed that, sorry.
<?php
// connect, blah, blah
pg_query(sprintf('insert into log (time, user, page) values (\'&#37;s\', \'%s\', \'%s\')',
date('r'),
$username,
$_SERVER['REQUEST_URI']
));
?>

[tech_support]

Hmm... a database could also be a text file.

[Twey]

At a stretch. Well, either way, the code's there.