{"id":1518,"date":"2018-01-19T19:22:56","date_gmt":"2018-01-19T19:22:56","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/revisited-logging-with-php\/"},"modified":"2018-01-19T19:24:51","modified_gmt":"2018-01-19T19:24:51","slug":"revisited-logging-with-php","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/revisited-logging-with-php\/","title":{"rendered":"Revisited: Logging With PHP"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on December 10, 2000<\/div>\n<\/p><\/div>\n
\"picture<\/p>\n
\nFiguring out where your hits are coming from and which
\npages are being viewed is not too difficult if you use a
\ngood log analyzer like Analog or something similar.<\/div>\n
\nBut if you want to pull up reports on the fly at any time,
\nyou need to take a different route.<\/div>\n
\nFor about six months, I was importing my Apache logs into
\nan SQL database and then running ad-hoc queries against that.<\/div>\n
\nUnfortunately, that requires me to go out and manually grab
\nthose log files, tweak the format a bit, then import. I wanted
\nsomething better – something that was continually updated,
\ngave me information on what content was being viewed,
\nbrowser and platforms stats, and trends over time.<\/div>\n
\nThe solution I came up with in my original version<\/a> of this
\narticle has served me well for a couple years now. I enhanced it
\nsomewhat when we built SourceForge and all logging and tracking
\nfor the entire SourceForge.net web site pipes through this
\nsystem, including page views on the main site and page views
\nfor each of the 12,000 projects that use the site.<\/div>\n
\nBasically, what I do is add a row to a table in a database for
\neach action I want to log (page views in this example, but you can log
\nbanner add views, clicks, click-ins from other sites, etc).<\/div>\n
\nHere is the table structure I’ve been using on SourceForge:<\/div>\n
\n
\ncreate table activity_log (\n  day integer DEFAULT '0' NOT NULL,\n  hour integer DEFAULT '0' NOT NULL,\n  group_id integer DEFAULT '0' NOT NULL,\n  browser varchar(8) DEFAULT 'OTHER' NOT NULL,\n  ver float(10) DEFAULT '0.00' NOT NULL,\n  platform varchar(8) DEFAULT 'OTHER' NOT NULL,\n  time integer DEFAULT '0' NOT NULL,\n  page text,\n  type integer DEFAULT '0' NOT NULL\n);\n<\/pre>\n<\/div>\n
\nThe group_id<\/i> column can be used if you have multiple web sites
\nyou are trying to track. Just assign a different group_id to each site
\nand pass it in the URL (shown below).<\/div>\n
\ntype<\/i> is unused in these
\nexamples, but you can use it to track different types of actions, like
\nad clicks, clickins from other sites, etc.<\/div>\n
\nbrowser, ver, platform<\/i> are all obtained from the $HTTP_USER_AGENT<\/b>
\nvariable which is passed by your browser to the web server. I have a
\nbrowser detection library which we call to fill in this info. The code for
\nthat is available elsewhere in this article.<\/div>\n
\npage<\/i> is any arbitrary information that you want to log – I
\ngenerally log $PHP_SELF<\/b>.<\/div>\n<\/div>\n
<\/p>\n
\n
1<\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
| <\/div>\n
5<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div>\n
 Download: tim20001211.zip<\/a>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"
By Tim Perdue on December 10, 2000 Figuring out where your hits are coming from and which pages are being viewed is not too difficult if you use a good log analyzer like Analog or something similar. But if you want to pull up reports on the fly at any… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1518","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1518"}],"version-history":[{"count":2,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1518\/revisions"}],"predecessor-version":[{"id":2411,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1518\/revisions\/2411"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}