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.