{"id":1352,"date":"2018-01-19T19:22:44","date_gmt":"2018-01-19T19:22:44","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/oracle-with-php-a-developers-view-page-2\/"},"modified":"2018-01-19T19:24:43","modified_gmt":"2018-01-19T19:24:43","slug":"oracle-with-php-a-developers-view-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/oracle-with-php-a-developers-view-page-2\/","title":{"rendered":"Oracle with PHP: a Developers View Page 2"},"content":{"rendered":"
\n
\n
By Rajeev Ranjan Rakesh<\/div>\n
on October 17, 2008<\/div>\n<\/p><\/div>\n
\n
\n<\/p>\n
\n$conn = oci_connect($dbuser,$dbpassword, ??CONN_STRING??);\n\n$sql = \"SELECT??*??FROM??EMPLOYEE_TABLE\";\n<\/pre>\n
    <\/code>\n    <\/div>\n
\nHere $sql stores the sql statement which is to be executed:\n    <\/div>\n
\n<\/p>\n
\n$stmt??=??oci_parse($conn,??$sql);\n<\/pre>\n
    <\/code>\n    <\/div>\n
\noci_parse() function prepares the statement for execution. It takes the connection identifier and the sql query as a parameter and returns a statement handler.\n    <\/div>\n
\n<\/p>\n
\noci_execute($stmt,??OCI_DEFAULT);\n<\/pre>\n
    <\/code>\n    <\/div>\n
\noci_execute() function executes the parsed statement. This function can have two parameters. The first one is the valid OCI statement identifier and the second one is the mode (option parameter). By default OCI_COMMIT_ON_SUCCESS.\n<\/div>\n
\nNote: If you don’t want statements to be committed automatically, you should specify OCI_DEFAULT as mode.\n    <\/div>\n
\n<\/p>\n
\nwhile($result =oci_fetch_array($stmt)) {\t\n\techo $result[??EMPLOYEE_NAME??] . \"<br>\";\t\n}\n<\/pre>\n
    <\/code>\n    <\/div>\n
\nThe statement above stores the result of oci_fetch_array($stmt) in the variable $result. oci_fetch_array() returns an array. The second parameter is optional for this function and can have values like OCI_BOTH, OCI_ASSOC, OCI_NUM depending on the type of array that is required. Once the array is returned and stored in the variable $result, we display the Employee name from the selected columns.\n    <\/div>\n
\n<\/p>\n
\noci_close($conn);\n    <\/pre>\n
    <\/code>\n    <\/div>\n
\nThis function is used to close the connection to the Oracle database.\n<\/div>\n
\nThis completes the explanation of the sample code that is used to connect and perform operations on the Oracle database using PHP??s ADOdb abstract library.\n    <\/div>\n
\nJoin us next week when we delve into the ADOdb library and continue our discussion on using Oracle and PHP!\n    <\/div>\n
<\/p>\n<\/div>\n
<\/p>\n
\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
This article is for the developer who wants to use the PHP scripting language and an Oracle database to develop their application. There are<\/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-1352","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1352","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=1352"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1352\/revisions"}],"predecessor-version":[{"id":3235,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1352\/revisions\/3235"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}