Oracle PHP programming tips Oracle Database Tips by Donald Burleson

Question:  I'm planning a web system and I need guidance about the options for managing HTML pages with Oracle.  Where does Oracle and PHP fit in?

Answer:  Oracle has many options including JDeveloper (J2EE), Oracle Application Express (Apex HTML-DB) and Oracle XML.

Oracle with PHP has proven to be a great way to embed Oracle calls inside web pages.  In any database the "calls" (SQL statements) are embedded within the language and a mechanism must exist for send the calls and receiving the results.,

Mladen Gogala has the only book on the subject "Easy Oracle PHP: Create Dynamic Web Pages with Oracle Data", and excellent book of Oracle PHP tips and techniques.

• See ready-to-use examples for connecting to Oracle with PHP
• Learn templates for extracting Oracle data in PHP
• Create dynamic web content with PHP and Oracle
• See real-world techniques for writing parameterized PHP Oracle queries
• Understand how to update Oracle from PHP
• Learn the best PHP Oracle coding styles

Oracle has made a major commitment to PHP with development and they announced Oracle's incorporation of PHP into SOA.

Christopher Jones, a technical consultant at Oracle Corp., has similar issues with PHP. "Installation is the biggest problem of all…We need to make sure PHP is easier to adopt," he said. The key to the future of PHP, according to Jones, is "Integration, integration, integration."

For this, IBM has proposed using Service Data Objects (SDO) and Service Component Architecture (SCA). The goal being to "make it simple for you to do what the big guys can do," said Burr.

As the freeware Oracle XE makes head roads into small web server database management the use of Oracle with PHP will become more common.

If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.