{"id":1472,"date":"2018-01-19T19:22:53","date_gmt":"2018-01-19T19:22:53","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/logging-with-php\/"},"modified":"2018-01-19T19:24:49","modified_gmt":"2018-01-19T19:24:49","slug":"logging-with-php","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/logging-with-php\/","title":{"rendered":"Logging With PHP"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on July 30, 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,
\nflexible enough to simultaneously support multiple sites,
\nand multiple actions (page view, ad click, click-in, click-out,
\nplus more if needed).<\/div>\n
\nI sat down and came up with the following table:<\/div>\n
\n
\ncreate\u00a0table\u00a0tbl_activity_log\u00a0(
\n
fld_date\u00a0int,\u00a0\u00a0\u00a0\u00a0\/\/ex.\u00a019990101
\n
fld_hours\u00a0text,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/Which\u00a0hour\u00a0of\u00a0the\u00a0day?
\n
fld_remote_ip\u00a0text,\u00a0\u00a0\/\/IP\u00a0of\u00a0visitor
\n
fld_action\u00a0int,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/page\u00a0view,\u00a0click,\u00a0etc
\n
fld_special\u00a0text,\u00a0\u00a0\u00a0\u00a0\/\/which\u00a0page\u00a0or\u00a0category?
\n
fld_affil_num\u00a0int\u00a0\u00a0\u00a0\u00a0\/\/unique\u00a0for\u00a0each\u00a0web\u00a0site
\n
);<\/span>
\n<\/code><\/font><\/div>\n
\nSomeone who really knows what they’re doing would have used a
\ntimestamp field rather than int fld_date<\/i>, but this works
\nfor me. You could also add another column to hold the $PATH_INFO<\/i>,
\nbut I decided the Special column gives me what I want.<\/div>\n
\nI also defined these indexes, as I knew I would be querying on
\nany of these fields:<\/div>\n
\n
\nINDEXES
\n
idx_logger_date
\n
idx_logger_hour
\n
idx_logger_ip
\n
idx_logger_action
\n
idx_logger_special
\n
idx_logger_affil_num<\/span>
\n<\/code><\/font><\/div>\n
\nThe next step was getting the info into the tables. It would be
\na perfect world if all pages were served through PHP and all of your
\nvarious web sites existed on one box. Unfortunately, I have an array
\nof servers scattered all over the country, and I want to collect this
\ninfo from every server for every page view 24 hours a day.<\/div>\n
\nSo that required me to use the 1×1 pixel GIF trick. I have a GIF
\non every page that looks like this:<\/div>\n
\n
\n<IMG SRC=\"http:\/\/www.yourserver.com\/util\/gif11.php3?c=4&s=phpbuildercom&b=77\" \nheight=1 width=1>\n<\/pre>\n<\/div>\n
\ngif11.php3<\/b> is a simple script that resides on my central server.
\nI have included the source on the next page.
\nSince the gif is on each page, and is forced to load due to the random
\nnumber at the end (the b=xxxx), a request is sent back to the central
\nserver for each and every page view.<\/div>\n
\nIf all of your pages and the database reside on one server, you don’t
\nneed to use the GIF trick – you can insert the logging code into the
\nheader of your page. <\/div>\n
\nThe same logging system can be used to track click-thrus on ad banners:<\/div>\n
\n
\n<A HREF=\"http:\/\/www.yourserver.com\/util\/adclick.php3?c=4&goto= * >\n<\/pre>\n<\/div>\n
\nJust replace * with the URL you want to redirect to. Again here, the
\n$c variable should be changed for each web site.<\/div>\n<\/div>\n
<\/p>\n
\n
1<\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
By Tim Perdue on July 30, 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-1472","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1472","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=1472"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1472\/revisions"}],"predecessor-version":[{"id":2247,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1472\/revisions\/2247"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}