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
- Learn templates for extracting Oracle data in PHP
- Create dynamic web content with PHP and Oracle
- See real-world techniques for writing parameterized PHP
- 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
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
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.