{"id":370,"date":"2019-08-19T10:55:02","date_gmt":"2019-08-19T09:55:02","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=370"},"modified":"2019-08-19T10:55:02","modified_gmt":"2019-08-19T09:55:02","slug":"connecting-to-an-oracle-database-using-php","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/programming\/php\/connecting-to-an-oracle-database-using-php\/","title":{"rendered":"Connecting to an Oracle Database using PHP"},"content":{"rendered":"\n<p>For connection to the Faculty&#8217;s\u00a0<a href=\"https:\/\/cms-support.gre.ac.uk\/db\/oracle.html\">Oracle Databases<\/a>\u00a0two ODBC connections have been set up on the IIS server stuiis.cms.gre.ac.uk, one for the Obiwan server and one for Quigon. The following two lines of code can be used to connect to either server: <br><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><br>$conn=odbc_connect(\"server\",\"username\",\"oraclepassword\");\n\n$strSQL = \"SELECT last_name, city, phone_no FROM supplier ORDER BY city\";\n\n$result = odbc_exec($conn, $strSQL);\nwhile(odbc_fetch_row($result)){\n$last_name = odbc_result($result, 1);\n$city = odbc_result($result, 2);\n$phone_no = odbc_result($result, 3);\nprint(\"$last_name $city $phone_no\\n\");\n}\n\nodbc_close($conn)\n<\/pre>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For connection to the Faculty&#8217;s\u00a0Oracle Databases\u00a0two ODBC connections have been set up on the IIS server stuiis.cms.gre.ac.uk, one for the Obiwan server and one for Quigon. The following two lines of code can be used &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":122,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-370","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=370"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/370\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/122"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}