Here is yet another approach, using php directives in an Apache .htaccess
file, eg on a per-directory basis
put this line in a .htaccess file
php_value auto_append_file /my/path/to/log.php
create the above log.php with something like this
<?php
$logFile = fopen("/my/path/to/mylog.log", "a");
fputs($logFile, "[" . date("Y:m:d:h:i") . "] - $PHP_SELF - $REMOTE_ADDR\n");
fclose($logFile);
?>
With a bit of fiddling you can make a log file that can be parsed by log
analysis software
At 00:18 30/01/01, you wrote:
>Thanks that really hit the spot, worked straight off and I'll be building on
>it.
>
>Nick
>
> > Here's a spin on Bob's approach:
> >
> > An include at the top of index.php
> >
> > start -------------------------------------------------------------
> > $host = isset($REMOTE_HOST) ? $REMOTE_HOST : $REMOTE_ADDR;
> >
> > //insert info
> > $Query = "INSERT INTO activity_log ";
> > $Query .= "(Day, Hour, Browser, Version, Platform, Referer, Time, Screen,
> > Department, Item, SID, Search, Basket, User) ";
> > $Query .= "VALUES ('" . date('Ymd', mktime()) . "', '" . date('H',
> > mktime()) . "', ";
> > $Query .= " '$Browser_Name', '$Browser_Version', '$Browser_Platform', '" .
> > $host . "', '" . time() . "', ";
> > $Query .= " '$SCREEN', '$department', '$item', '$sid', '$inputKeywords',
> > '$sku', '" . $UserInfo['ID'] . "') ";
> > if(!($DatabaseResult = mysql_query($Query, $DatabaseLink)))
> > {
> > $ActionResults[] = mysql_errno() . ": " . mysql_error();
> > $ActionResults[] = $Query;
> > }
> > stop -------------------------------------------------------------
> >
> > the DB looks like this:
> >
> > CREATE TABLE activity_log (
> > Day int(11) DEFAULT '0' NOT NULL,
> > Hour int(11) DEFAULT '0' NOT NULL,
> > Browser varchar(8) DEFAULT 'OTHER' NOT NULL,
> > Version float DEFAULT '0' NOT NULL,
> > Platform varchar(8) DEFAULT 'OTHER' NOT NULL,
> > Referer varchar(40) NOT NULL,
> > Time int(11) DEFAULT '0' NOT NULL,
> > Screen text NOT NULL,
> > Department int(11) DEFAULT '0' NOT NULL,
> > Item int(11) DEFAULT '0' NOT NULL,
> > SID varchar(25) NOT NULL,
> > Search varchar(35) NOT NULL,
> > Basket varchar(25) NOT NULL,
> > User int(5) DEFAULT '0' NOT NULL
> > );
> >
> > Then you can do reports like this:
> >
> > start------------------------------------------------
> > $Query = "SELECT Screen, count(*) AS count ";
> > $Query .= "FROM activity_log ";
> > $Query .= "WHERE Screen != 'user_activity' ";
> > $Query .= "GROUP BY Screen ORDER BY count DESC";
> > if ( !($DatabaseResult = mysql_query($Query, $DatabaseLink)) ) {
> > print(" " . mysql_errno() . ": " . mysql_error() . "Query was $Query\n");
> > } else {
> >
> > print "<table border='0'>\n";
> > print "<th>\nScreen Title</th>\n";
> > print "<th>\nScreen</th>\n";
> > print "<th>\nHits</th>\n";
> > $row_no = "1";
> >
> > while($DatabaseRow = mysql_fetch_array($DatabaseResult)) {
> >
> > $Screen = $DatabaseRow['Screen'];
> > $ScreenTitle = $ScreenInfo[$Screen][0];
> > $Qty = $DatabaseRow['count'];
> >
> > if ($row_no % 2 == 0) {
> > $bg_clr = '#FFFFFF';
> > } else {
> > $bg_clr = '#EEEEEE';
> > }
> >
> > print "<tr bgcolor='$bg_clr'>\n";
> > print "<td>\n $ScreenTitle </td>\n";
> > print "<td>\n $Screen </td>\n";
> > print "<td>\n $Qty </td>\n";
> > print "</tr>\n";
> >
> > $row_no++;
> >
> > }
> >
> > print "</table>\n";
> > }
> > stop--------------------------------------------------------
> >
> > There are a number of reports that you can create from the information
> being
> > collected. If you do a query on the items, the type of things users are
> > searching...the list goes on. A cron job would also be useful to delete old
> > records.
> >
> > ron
> >
> >
> >
> >> Thanks Bob that's the kind of thing I was thinking about.
> >>
> >> Leon's suggestion about altering the URL and tracking via a "fake log file
> >> using Apache" is probably a good one if I had that kind of server access.
> > In
> >> fact I was reading an article: http://www.alistapart.com/stories/urls/
> > about
> >> just that kind of thing.
> >>
> >> Anyway, I've got a few more things to be getting on with before that so
> >> thanks again.
> >>
> >> Nick
> >>
> >
> >
> >
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Site: http://www.working-dogs.com/freetrade/
> > Problems?: [EMAIL PROTECTED]
> >
> >
>
>
>
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
bye
Bob Hutchinson
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
