{"id":1552,"date":"2018-01-19T19:22:58","date_gmt":"2018-01-19T19:22:58","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/odbc-socket-server-page-4\/"},"modified":"2018-01-19T19:24:52","modified_gmt":"2018-01-19T19:24:52","slug":"odbc-socket-server-page-4","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/odbc-socket-server-page-4\/","title":{"rendered":"ODBC Socket Server Page 4"},"content":{"rendered":"
\n
\n
By Tim Uckun<\/div>\n
on December 6, 2000<\/div>\n<\/p><\/div>\n
\n
\nHere is how you would use this object:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>\/\/\u00a0Of\u00a0course\u00a0we\u00a0have\u00a0to\u00a0include\u00a0the\u00a0file.
\n
<\/span>include\u00a0(<\/span>\"socketserverobj.php\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>\/\/\u00a0First\u00a0we\u00a0create\u00a0the\u00a0class
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>$db\u00a0<\/span>=\u00a0new\u00a0<\/span>ODBCSocketServer<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>\/\/\u00a0Set\u00a0the\u00a0Hostname,\u00a0port,\u00a0and\u00a0connection\u00a0string
\n
\u00a0\u00a0\u00a0
\n
<\/span>$db<\/span>-><\/span>HostName\u00a0<\/span>=\u00a0<\/span>\"192.168.0.4\"<\/span>;
\n
<\/span>$db<\/span>-><\/span>Port\u00a0<\/span>=\u00a0<\/span>9628<\/span>;
\n
\u00a0\u00a0\u00a0
\n
<\/span>\/\/\u00a0any\u00a0valid\u00a0ADO\u00a0connection\u00a0string\u00a0should\u00a0be\u00a0fine.\u00a0I\u00a0find\u00a0it\u00a0easier\u00a0just\u00a0to\u00a0set\u00a0up\u00a0the\u00a0DSN
\n
\/\/\u00a0and\u00a0pass\u00a0in\u00a0the\u00a0user\u00a0info
\n
\u00a0\u00a0\u00a0
\n
<\/span>$db<\/span>-><\/span>ConnectionString\u00a0<\/span>=\u00a0<\/span>\"DSN=Some_ODBC_DSN;UID=Some_User;PWD=Some_Password;\"<\/span>;
\n
\u00a0\u00a0\u00a0<\/p>\n

<\/span>\/\/now\u00a0execute\u00a0the\u00a0SQL
\n
\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>$result\u00a0<\/span>=\u00a0<\/span>$db<\/span>-><\/span>execute<\/span>(<\/span>\"Select\u00a0Field1,\u00a0field2\u00a0from\u00a0SomeTable\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
if\u00a0(!<\/span>$result<\/span>){
\n
\u00a0\u00a0\u00a0\u00a0print\u00a0<\/span>\"<p>There\u00a0was\u00a0an\u00a0error\u00a0:\u00a0\"\u00a0<\/span>.\u00a0<\/span>$db<\/span>-><\/span>errorMsg<\/span>()\u00a0.\u00a0<\/span>\"<p>\"<\/span>;
\n
}\u00a0else\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0Simple\u00a0iteration\u00a0when\u00a0you\u00a0already\u00a0know\u00a0the\u00a0field\u00a0names
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>print\u00a0<\/span>\"<table>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0while\u00a0(!<\/span>$db<\/span>-><\/span>EOF<\/span>){<\/p>\n

\u00a0\u00a0\u00a0\u00a0Print\u00a0<\/span>\"<tr>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0the\u00a0\u00a0case\u00a0folding\u00a0is\u00a0true\u00a0by\u00a0default
\n
\u00a0\u00a0\u00a0\u00a0\/\/\u00a0this\u00a0means\u00a0we\u00a0have\u00a0to\u00a0use\u00a0upper\u00a0case\u00a0when\u00a0accessing\u00a0field\u00a0names.
\n
\u00a0\u00a0\u00a0\u00a0\/\/\u00a0If\u00a0case\u00a0folding\u00a0was\u00a0false\u00a0then\u00a0we\u00a0would\u00a0have\u00a0to\u00a0use\u00a0\u00a0exact\u00a0case\u00a0like\u00a0this
\n
\u00a0\u00a0\u00a0\u00a0\/\/\u00a0$db->Field1\u00a0,\u00a0\u00a0$db->field2
\n
\u00a0\u00a0\u00a0\u00a0\/\/\u00a0or\u00a0use\u00a0getField\u00a0method\u00a0(see\u00a0next\u00a0example)<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>print\u00a0<\/span>\"<td>\"<\/span>.\u00a0<\/span>$db<\/span>-><\/span>FIELD1<\/span>.\u00a0<\/span>\"<\/td>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0print\u00a0<\/span>\"<td>\"<\/span>.\u00a0<\/span>$db<\/span>-><\/span>FIELD2\u00a0<\/span>.\u00a0<\/span>\"<\/td>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0Print\u00a0<\/span>\"<\/tr>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$db<\/span>-><\/span>moveNext<\/span>();
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
}
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
print\u00a0<\/span>\"<\/table>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
<\/span>\/\/\u00a0What\u00a0if\u00a0you\u00a0don't\u00a0know\u00a0the\u00a0field\u00a0names?
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\/\/\u00a0go\u00a0back\u00a0to\u00a0the\u00a0beginning\u00a0we\u00a0could\u00a0have\u00a0moved\u00a0backwards\u00a0too!<\/p>\n

<\/span>$db<\/span>-><\/span>moveFirst<\/span>();<\/p>\n

print\u00a0<\/span>\"<table>\"<\/span>;<\/p>\n

while\u00a0(!<\/span>$db<\/span>-><\/span>EOF<\/span>){
\n
\u00a0\u00a0\u00a0\u00a0Print\u00a0<\/span>\"<tr>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0foreach\u00a0(<\/span>$db<\/span>-><\/span>getFieldNames<\/span>()\u00a0as\u00a0<\/span>$fieldname<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Print\u00a0<\/span>\"<td>\"\u00a0<\/span>.\u00a0<\/span>$db<\/span>-><\/span>getField<\/span>(<\/span>$fieldname<\/span>)\u00a0.\u00a0<\/span>\"<\/td>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0}\u00a0<\/span>\/\/\u00a0foreach
\n
\u00a0\u00a0\u00a0\u00a0<\/span>Print\u00a0<\/span>\"<\/tr>\"<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$db<\/span>-><\/span>moveNext<\/span>();
\n
}\u00a0<\/span>\/\/\u00a0while
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
<\/span>print\u00a0<\/span>\"<\/table>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nOf course you are not limited to SELECT queries. Action queries (INSERT and UPDATE) obviously don’t
\nreturn a recordset, but they do return a true or false depending on
\nhow the engine handled them. Once again, if there are any errors present you can check the
\nError variable. You may also want to do some things with the XML variable. For example, you may want to
\nsend the raw XML to a client for B2B syndication.<\/div>\n
\nAlthough this object was written to parse the MS ADO XML format, it could easily be rewritten to
\naccommodate the native XML format of the socket server. In a future version,
\nthe socket server will be able to hand out either XML type on demand.<\/div>\n
\nI hope this tutorial was useful to you. I want to thank the fine people at Team FXML for the ODBC Socket
\nserver and of course the fine people at PHP for providing such a useful development environment.<\/div>\n
\nThe socketserverobj include file is available below.<\/div>\n
\n— Tim<\/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<\/a> <\/div>\n
| <\/div>\n
4<\/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-1552","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1552","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=1552"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1552\/revisions"}],"predecessor-version":[{"id":3381,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1552\/revisions\/3381"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}