{"id":1474,"date":"2018-01-19T19:22:53","date_gmt":"2018-01-19T19:22:53","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/logging-with-php-page-3\/"},"modified":"2018-01-19T19:24:49","modified_gmt":"2018-01-19T19:24:49","slug":"logging-with-php-page-3","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/logging-with-php-page-3\/","title":{"rendered":"Logging With PHP Page 3"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n

Source Code<\/h2>\n
\n
\n<!--<\/p>\n

\u00a0\u00a0\u00a0\u00a0\/\/gif11.php3\u00a0accepts\u00a0these\u00a0parameters:
\n
$c;\u00a0\u00a0\/\/correlates\u00a0to\u00a0fld_affil_num\u00a0in\u00a0the\u00a0database\u00a0-
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\/\/unique\u00a0for\u00a0each\u00a0site
\n
$s;\u00a0\u00a0\/\/correlates\u00a0to\u00a0fld_special\u00a0in\u00a0the\u00a0database
\n
$b;\u00a0\u00a0\/\/random\u00a0number\u00a0-\u00a0forces\u00a0the\u00a0gif\u00a0to\u00a0load,\u00a0even\u00a0if\u00a0cached
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\/\/generated\u00a0by\u00a0PHP\u00a0and\u00a0discarded
\n
--><\/p>\n

<?php<\/p>\n

<\/span>\/\/gif11.php3
\n
\/\/don't\u00a0have\u00a0any\u00a0extra\u00a0spaces\u00a0outside\u00a0the\u00a0&lt;?\u00a0?&gt;
\n
\/\/\u00a0\u00a0\u00a0\u00a0or\u00a0you\u00a0could\u00a0have\u00a0a\u00a0broken\u00a0gif\u00a0come\u00a0back<\/p>\n

<\/span>Header<\/span>(\u00a0<\/span>\"Content-type:\u00a0\u00a0image\/gif\"<\/span>);
\n
<\/span>passthru<\/span>(\u00a0<\/span>\"cat\u00a0clear.gif\"\u00a0<\/span>);\u00a0<\/span>\/\/send\u00a0a\u00a01x1\u00a0gif<\/p>\n

<\/span>$logger_action<\/span>=<\/span>5<\/span>;\u00a0\u00a0\u00a0\u00a0<\/span>\/\/impression
\n
<\/span>$logger_special<\/span>=<\/span>$s<\/span>;\u00a0\u00a0<\/span>\/\/move\u00a0the\u00a0$s\u00a0param\u00a0for\u00a0the\u00a0logger
\n
<\/span>$fld_affil_num<\/span>=<\/span>$c<\/span>;\u00a0\u00a0\u00a0<\/span>\/\/ditto\u00a0for\u00a0the\u00a0$c\u00a0param<\/p>\n

<\/span>include(<\/span>'connect.inc'<\/span>);\u00a0<\/span>\/\/connect\u00a0to\u00a0the\u00a0DB\u00a0SERVER
\n
<\/span>include(<\/span>'logger.inc'<\/span>);\u00a0\u00a0<\/span>\/\/Exanded\u00a0below<\/p>\n

<\/span>?><\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

PHP Code To Generate The GIF URL:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

srand<\/span>((double)<\/span>microtime<\/span>()*<\/span>1000000<\/span>);
\n
<\/span>$random_num<\/span>=<\/span>rand<\/span>(<\/span>5<\/span>,<\/span>95<\/span>);
\n
<\/span>?>
\n
<\/span><p>
\n
<img\u00a0src=\"http:\/\/www.yourserver.com\/util\/gif11.php3?c=4&s=phpbuildercom&b=<?
\n
<\/span>echo\u00a0<\/span>$random_num<\/span>;\u00a0<\/span>?><\/span>\"\u00a0height=1\u00a0width=1>
\n
<\/span>
\n<\/code><\/font><\/div>\n

connect.inc:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>\/\/
\n
\/\/Connect\u00a0to\u00a0the\u00a0PostgreSQL\u00a0database
\n
\/\/<\/p>\n

<\/span>$conn\u00a0<\/span>=\u00a0<\/span>pg_pconnect<\/span>(<\/span>\"user=myname\u00a0dbname=my_db\"<\/span>);<\/p>\n

<\/span>\/\/I\u00a0use\u00a0a\u00a0persistent\u00a0connection\u00a0instead\u00a0of\u00a0opening
\n
\/\/and\u00a0closing\u00a0the\u00a0connection\u00a0tens\u00a0of\u00a0thousands
\n
\/\/of\u00a0times\/day<\/p>\n

<\/span>if\u00a0(!<\/span>$conn<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"An\u00a0error\u00a0occured.n\"<\/span>;\u00a0<\/span>\/\/amateur\u00a0error\u00a0detection
\n
\u00a0\u00a0\u00a0\u00a0<\/span>exit;
\n
}<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

logger.inc:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>\/\/
\n
\/\/ACTIONS\u00a0-\u00a01=get\u00a02=click-thru\u00a03=clickin\u00a04=jump2zip\u00a05=impression
\n
\/\/<\/p>\n

<\/span>if\u00a0(!<\/span>$logger_action<\/span>)\u00a0{echo\u00a0<\/span>\"error\u00a0in\u00a0logger\"<\/span>;\u00a0exit;}
\n
if\u00a0(!<\/span>$logger_special<\/span>)\u00a0{echo\u00a0<\/span>\"error\u00a0in\u00a0logger\"<\/span>;\u00a0exit;}<\/p>\n

<\/span>\/\/
\n
\/\/The\u00a0following\u00a0should\u00a0be\u00a0on\u00a0one\u00a0long\u00a0line...
\n
\/\/<\/p>\n

<\/span>$logger_sql<\/span>=<\/span>\"insert\u00a0into\u00a0tbl_activity_log\u00a0values\u00a0(\"<\/span>.<\/span>date<\/span>(<\/span>\"Ymd\"<\/span>,\u00a0<\/span>mktime<\/span>()).<\/span>\",\u00a0\"<\/span>.\u00a0\u00a0<\/span>\/\/PHP\u00a0method\u00a0to\u00a0build\u00a0date
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"'\"<\/span>.<\/span>date<\/span>(<\/span>\"H\"<\/span>,\u00a0<\/span>mktime<\/span>()).<\/span>\"',\u00a0\"<\/span>.\u00a0\u00a0<\/span>\/\/PHP\u00a0method\u00a0to\u00a0get\u00a0hour
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"'$REMOTE_ADDR',\u00a0\"<\/span>.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/Get\u00a0the\u00a0IP\u00a0address\u00a0of\u00a0client
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"$logger_action,\u00a0'\u00a0\"<\/span>.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/action\u00a0as\u00a0set\u00a0up\u00a0in\u00a0gif11.php3
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"$logger_special',\u00a0\"<\/span>.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/ditto
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"$fld_affil_num);\"<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/which\u00a0web\u00a0site<\/p>\n

<\/span>$res_logger\u00a0<\/span>=\u00a0<\/span>pg_Exec\u00a0<\/span>(<\/span>$conn<\/span>,\u00a0<\/span>$logger_sql<\/span>);<\/p>\n

if\u00a0(!<\/span>$res_logger<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"An\u00a0error\u00a0occured\u00a0in\u00a0the\u00a0logger.n\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>pg_ErrorMessage<\/span>();
\n
\u00a0\u00a0\u00a0\u00a0exit;
\n
}<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

adclick.php3:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

$goto_location<\/span>=<\/span>\"Location:\u00a0\u00a0\"<\/span>.<\/span>$goto<\/span>.<\/span>\"&b=\"<\/span>.<\/span>$b<\/span>;<\/p>\n

<\/span>Header<\/span>(<\/span>$goto_location<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$logger_action<\/span>=<\/span>2<\/span>;\u00a0\u00a0<\/span>\/\/adclick
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$logger_special<\/span>=<\/span>\"adclick\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$fld_affil_num<\/span>=<\/span>$c<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0include(<\/span>'connect.inc'<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0include(<\/span>'logger.inc'<\/span>);<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

reporter.php3:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>\/\/
\n
\/\/This\u00a0is\u00a0just\u00a0a\u00a0tiny\u00a0sample\u00a0of\u00a0the\u00a0reporting\u00a0you\u00a0can\u00a0do
\n
\/\/<\/p>\n

<\/span>Function\u00a0\u00a0<\/span>ShowResults<\/span>(<\/span>$result<\/span>)\u00a0\u00a0{<\/p>\n

<\/span>\/\/I\u00a0apologize\u00a0to\u00a0the\u00a0author\u00a0of\u00a0this\u00a0code\u00a0-
\n
\/\/I\u00a0believe\u00a0I\u00a0found\u00a0it\u00a0in\u00a0the\u00a0code\u00a0exchange,\u00a0but\u00a0I
\n
\/\/can't\u00a0find\u00a0it\u00a0now!\u00a0--Tim<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>if\u00a0\u00a0(<\/span>$result<\/span>)\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$rows\u00a0\u00a0<\/span>=\u00a0\u00a0<\/span>pg_NumRows<\/span>(<\/span>$result<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$cols\u00a0\u00a0<\/span>=\u00a0\u00a0<\/span>pg_NumFields<\/span>(<\/span>$result<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(\u00a0<\/span>\"<table\u00a0\u00a0border=1>n\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/*\u00a0\u00a0Create\u00a0\u00a0the\u00a0\u00a0headers\u00a0\u00a0*\/
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>echo(\u00a0<\/span>\"<tr>n\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for(<\/span>$i\u00a0\u00a0<\/span>=\u00a0\u00a0<\/span>0<\/span>;\u00a0\u00a0<\/span>$i\u00a0\u00a0<\/span><\u00a0\u00a0<\/span>$cols<\/span>;\u00a0\u00a0<\/span>$i<\/span>++)\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>printf<\/span>(\u00a0<\/span>\"<th>%s<\/th>n\"<\/span>,\u00a0\u00a0<\/span>pg_FieldName<\/span>(<\/span>$result<\/span>,\u00a0\u00a0<\/span>$i<\/span>));
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(\u00a0<\/span>\"<\/tr>\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for(<\/span>$j\u00a0\u00a0<\/span>=\u00a0\u00a0<\/span>0<\/span>;\u00a0\u00a0<\/span>$j\u00a0\u00a0<\/span><\u00a0\u00a0<\/span>$rows<\/span>;\u00a0\u00a0<\/span>$j<\/span>++)\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(\u00a0<\/span>\"<tr>n\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for(<\/span>$i\u00a0\u00a0<\/span>=\u00a0\u00a0<\/span>0<\/span>;\u00a0\u00a0<\/span>$i\u00a0\u00a0<\/span><\u00a0\u00a0<\/span>$cols<\/span>;\u00a0\u00a0<\/span>$i<\/span>++)\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>printf<\/span>(\u00a0<\/span>\"<td>%s<\/td>n\"<\/span>,\u00a0\u00a0<\/span>pg_result<\/span>(<\/span>$result<\/span>,\u00a0\u00a0<\/span>$j<\/span>,\u00a0\u00a0<\/span>$i<\/span>));
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(\u00a0<\/span>\"<\/tr>\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(\u00a0<\/span>\"<\/table>\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}\u00a0\u00a0else\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0echo(<\/span>pg_errormessage<\/span>());
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

<\/span>\/\/
\n
\/\/The\u00a0following\u00a0should\u00a0be\u00a0one\u00a0long\u00a0line
\n
\/\/<\/p>\n

<\/span>$report_sql<\/span>=<\/span>\"SELECT\u00a0fld_date,\u00a0fld_special,\u00a0count(*)\u00a0AS\u00a0IMPRESSIONS\u00a0\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"FROM\u00a0tbl_activity_log\u00a0\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"WHERE\u00a0fld_action=5\u00a0AND\u00a0fld_affil_num=$affil\u00a0\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"GROUP\u00a0BY\u00a0fld_date,\u00a0fld_special;\"<\/span>;<\/p>\n

<\/span>$res_click_report\u00a0<\/span>=\u00a0<\/span>pg_Exec\u00a0<\/span>(<\/span>$conn<\/span>,\u00a0<\/span>$report_sql<\/span>);<\/p>\n

if\u00a0((!<\/span>$res_click_report<\/span>)\u00a0||\u00a0(<\/span>pg_NumRows<\/span>(<\/span>$res_click_report<\/span>)\u00a0<\u00a0<\/span>1<\/span>))\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"An\u00a0error\u00a0occured.n\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0exit;
\n
}<\/p>\n

<\/span>ShowResults<\/span>(<\/span>$res_click_report<\/span>);<\/p>\n

}<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\n–Tim\n<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Tim Perdue on July 30, 2000 Source Code <!– \u00a0\u00a0\u00a0\u00a0\/\/gif11.php3\u00a0accepts\u00a0these\u00a0parameters: $c;\u00a0\u00a0\/\/correlates\u00a0to\u00a0fld_affil_num\u00a0in\u00a0the\u00a0database\u00a0– \u00a0\u00a0\u00a0\u00a0\u00a0\/\/unique\u00a0for\u00a0each\u00a0site $s;\u00a0\u00a0\/\/correlates\u00a0to\u00a0fld_special\u00a0in\u00a0the\u00a0database $b;\u00a0\u00a0\/\/random\u00a0number\u00a0–\u00a0forces\u00a0the\u00a0gif\u00a0to\u00a0load,\u00a0even\u00a0if\u00a0cached \u00a0\u00a0\u00a0\u00a0\u00a0\/\/generated\u00a0by\u00a0PHP\u00a0and\u00a0discarded –> <?php \/\/gif11.php3 \/\/don’t\u00a0have\u00a0any\u00a0extra\u00a0spaces\u00a0outside\u00a0the\u00a0&lt;?\u00a0?&gt; \/\/\u00a0\u00a0\u00a0\u00a0or\u00a0you\u00a0could\u00a0have\u00a0a\u00a0broken\u00a0gif\u00a0come\u00a0back Header(\u00a0“Content-type:\u00a0\u00a0image\/gif”); passthru(\u00a0“cat\u00a0clear.gif”\u00a0);\u00a0\/\/send\u00a0a\u00a01×1\u00a0gif $logger_action=5;\u00a0\u00a0\u00a0\u00a0\/\/impression $logger_special=$s;\u00a0\u00a0\/\/move\u00a0the\u00a0$s\u00a0param\u00a0for\u00a0the\u00a0logger $fld_affil_num=$c;\u00a0\u00a0\u00a0\/\/ditto\u00a0for\u00a0the\u00a0$c\u00a0param include(‘connect.inc’);\u00a0\/\/connect\u00a0to\u00a0the\u00a0DB\u00a0SERVER include(‘logger.inc’);\u00a0\u00a0\/\/Exanded\u00a0below ?> PHP Code To Generate The GIF URL: <?php srand((double)microtime()*1000000); $random_num=rand(5,95); ?> <p> <img\u00a0src=”http:\/\/www.yourserver.com\/util\/gif11.php3?c=4&s=phpbuildercom&b=<? echo\u00a0$random_num;\u00a0?>”\u00a0height=1\u00a0width=1> connect.inc: <?php \/\/ \/\/Connect\u00a0to\u00a0the\u00a0PostgreSQL\u00a0database \/\/ $conn\u00a0=\u00a0pg_pconnect(“user=myname\u00a0dbname=my_db”); \/\/I\u00a0use\u00a0a\u00a0persistent\u00a0connection\u00a0instead\u00a0of\u00a0opening… <\/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-1474","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1474","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=1474"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1474\/revisions"}],"predecessor-version":[{"id":3325,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1474\/revisions\/3325"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}