Database access: Oracle
A simple example of using Oracle with PHP.

• Home
• ›
• Code snippets
• ›
• PHP
• ›
• Database access: Oracle

Like all PHP on sloppycode.net this example was made in PHP 3.x or 4, so unfortunately isn't guaranteed to be error free anymore.

<? // Over-ride 30 second default to 1 hour set_time_limit(21600); // Start Time echo "Started: " .date("H:i:s A") . "<br>"; $tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = w2kapp) (PORT = 1521) ) ) (CONNECT_DATA = (SERVICE_NAME = database.oracle.domain.com) (SID = database) ) ) "; $conn = OCILogon("SYS","change_on_install",$tns); // NB - use quotes around a table name if it's been imported from // SQL server, access etc. $SQL = "SELECT * FROM SYS.\"table\""; $result = ociparse($conn,$SQL); $ok = ociexecute($result,OCI_DEFAULT); $i = 0; while (ocifetch($result)) { $i++; } // Finish time echo "Finished: " .date("H:i:s A") . "<br>"; echo $i . " records found"; ?>

---

{Name}
Says:

{Date}
{Text}

› Home
› C#
› Snippets
› Articles
› Tools
› Taglines
› ASP
› Dictionary Object
› FSO
› Unix cheat sheet
› Gaming
› CSS
› Yak
› Umbraco
› About
› Contact
› Privacy
› Projects
› Search