{"id":1551,"date":"2018-01-19T19:22:58","date_gmt":"2018-01-19T19:22:58","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/odbc-socket-server-page-3\/"},"modified":"2018-01-19T19:24:52","modified_gmt":"2018-01-19T19:24:52","slug":"odbc-socket-server-page-3","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/odbc-socket-server-page-3\/","title":{"rendered":"ODBC Socket Server Page 3"},"content":{"rendered":"
\n
\n
By Tim Uckun<\/div>\n
on December 6, 2000<\/div>\n<\/p><\/div>\n
\n
\nStep 3: Setting up the client:<\/div>\n
\nUsing phpinfo() make sure that XML support is compiled. If it’s not compiled, recompile PHP using
\nthe –with-xml configuration options. Although not required for this application,
\nyou might also want to enable DOM and WDDX functionality. Here is an example.<\/div>\n
\n
\n.\/configure \n        --with-apxs=\/usr\/sbin\/apxs \n        --enable-track-vars \n        --with-xml \n        --with-dom \n        --with-wddx\nmake\nmake install\n<\/pre>\n<\/div>\n
\nIf you are using an earlier version you will need to make a change to the php.ini file. Either set the
\nallow_call_time_pass_reference  = On<\/i> or add   ~E_COMPILE_WARNING<\/i>
\nto the error_reporting<\/i> setting<\/code> If you don’t do this php will complain bitterly about a
\ncall by reference which we have to make.<\/div>\n
\nNext, drop the included odbcsocketserverobj.php file into a directory in your include path.<\/div>\n
\nThat’s it!. We are now ready to run some tests.<\/div>\n
\nYour communication with the socket server will be handled by the odbcsocketserverobj.php. This object has the
\nfollowing “public” interface.<\/div>\n
\n<\/p>\n
<?php<\/p>\n
$HostName<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Name\u00a0of\u00a0the\u00a0host\u00a0to\u00a0connect\u00a0to
\n
<\/span>$Port<\/span>=<\/span>9628<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Port\u00a0to\u00a0connect\u00a0to\u00a0(set\u00a0to\u00a0the\u00a0default)
\n
<\/span>$ConnectionString<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Connection\u00a0string\u00a0to\u00a0use\u00a0I\u00a0will\u00a0show\u00a0an\u00a0example\u00a0later.
\n
<\/span>$CaseFolding<\/span>=<\/span>true<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Determines\u00a0weather\u00a0or\u00a0not\u00a0all\u00a0XML\u00a0tags\u00a0are\u00a0mapped\u00a0to\u00a0uppercase\u00a0pretty\u00a0useful\u00a0sometimes
\n
<\/span>$XML<\/span>=<\/span>\"\"<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0the\u00a0raw\u00a0XML\u00a0as\u00a0returned\u00a0from\u00a0the\u00a0socket\u00a0server
\n
<\/span>$Error<\/span>=<\/span>\"\"<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Please\u00a0don't\u00a0use\u00a0use\u00a0the\u00a0function\u00a0instead
\n
<\/span>$Recordset<\/span>=<\/span>null<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0An\u00a0array\u00a0containing\u00a0the\u00a0recordset\u00a0just\u00a0in\u00a0case\u00a0you\u00a0want\u00a0to\u00a0deal\u00a0with\u00a0it\u00a0directly
\n
<\/span>$BOF\u00a0<\/span>=\u00a0<\/span>true<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Indicates\u00a0that\u00a0the\u00a0current\u00a0record\u00a0position\u00a0is\u00a0before\u00a0the\u00a0first\u00a0record\u00a0in\u00a0a\u00a0Recordset\u00a0object.
\n
<\/span>$EOF\u00a0<\/span>=\u00a0<\/span>true<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Indicates\u00a0that\u00a0the\u00a0current\u00a0record\u00a0position\u00a0is\u00a0after\u00a0the\u00a0last\u00a0record\u00a0in\u00a0a\u00a0Recordset\u00a0object.
\n
<\/span>$RecordCount<\/span>=<\/span>0<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Please\u00a0don't\u00a0use\u00a0use\u00a0the\u00a0function\u00a0instead
\n
<\/span>$FieldNames<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Please\u00a0don't\u00a0use\u00a0use\u00a0the\u00a0function\u00a0instead
\n
<\/span>$FieldCount<\/span>=<\/span>0<\/span>;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Please\u00a0don't\u00a0use\u00a0use\u00a0the\u00a0function\u00a0instead<\/p>\n
<\/span>execute<\/span>(<\/span>$SQL<\/span>)
\n
<\/span>errorMsg<\/span>()
\n
<\/span>getField<\/span>(<\/span>$field<\/span>)\u00a0<\/p>\n
<\/span>moveNext<\/span>()
\n
<\/span>nextRow<\/span>()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
<\/span>movePrev<\/span>()
\n
<\/span>prevRow<\/span>()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
<\/span>moveFirst<\/span>()
\n
<\/span>firstRow<\/span>()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
<\/span>moveLast<\/span>()
\n
<\/span>lastRow<\/span>()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
<\/span>moveRow<\/span>(<\/span>$rowNumber\u00a0<\/span>=\u00a0<\/span>0<\/span>)
\n
<\/span>getNumOfRows<\/span>()
\n
<\/span>getNumOfFields<\/span>()\u00a0
\n
<\/span>getFieldNames<\/span>()\u00a0<\/p>\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n
\nEven though PHP does not have any concepts of private and public variables, I have made an effort to hide the
\nusage of variables in the object. Wrapper functions are provided to
\naccess variables. For example, it is better oop practise to use getNumOfField() method rather then the
\n$RecordCount variable. Also, note that the movement records are aliased to each other. This was done to
\nestablish compatibility with phpDB recordset objects.<\/div>\n
\nNow that we know what the object does, let’s put it to the test.<\/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>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
System Administration: It’s a dirty job, but someone said I had to do<\/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-1551","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1551","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=1551"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1551\/revisions"}],"predecessor-version":[{"id":3380,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1551\/revisions\/3380"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}