If you have installed Oracle Application Server 10g Enterprise Edition and are ready to create custom SSO login and sign-off pages, then you might want to consider using PHP over the traditional PL/SQL and JSP methods. A big advantage of using PHP over PL/SQL and JSP is the ease with which the pages can be deployed and modified. With PHP, you simply open the file, make a change, and save the file. The new page and changes are picked up instantly.
This Technical Note demonstrates how quick and easy it is to create and manage custom login and sign-off pages for SSO using PHP.
In this article, I will describe a solution to this problem, known as the Trace File Manager (TFM), that we have developed in my own shop. Using a combination of the external calls interface available within the Oracle server to initiate TKPROF commands and the UTL_FILE utility to read in files that reside on the operating system, it can be surprisingly easy to bring your trace file data back into the database that generated the information in the first place.
Using a simple PHP front-end to make OCI calls into any or all of your databases where trace data is generated, you can easily retrieve trace files and issue TKPROF commands without the need to make direct connections to the servers where the databases reside.
PHP and Oracle are an excellent combination for creating powerful and scalable web solutions. In this article, John Neil sheds light on those performance issues that might arise only under high-traffic situations—so that you can stop them before they ever start cropping up.
Learn generic techniques and designs for writing manageable, scalable, and fast PHP code that directly relate to using Oracle Database.
This article is a quick summary of basic SQL commands with a little touch of Oracle to prepare for application development.
Now we have installed Oracle we can now begin to familiarise ourselves with use of SQL and how to use basic Oracle expressions.
You know PHP and MySQL, but wouldn't it be nice to know Oracle? Well, Ben's come to the rescue with his article series on using Oracle with PHP on Windows...
So, you have a huge project that you want to build. It's been determined that you want to use PHP, and your backend is Oracle. You've installed Oracle, you've installed your web server, and you've even gotten PHP to connect to your Oracle back end to do some simple queries. Now what?
At a USENIX conference several years ago, Linus Torvalds was asked about the scarcity of database software for Linux. The problem, he answered, was that while operating systems are fun, databases are so ugly that you always have to pay someone to write them. MySQL and Postgres have proved that notion not entirely true, and until fairly recently, free database products were the only real option for database software on Linux. But now there are a number of commercial database products officially supported on Linux, including industry heavyweights Oracle and DB2. Those products, combined with the Apache Web server and the PHP programming language, make Linux a very attractive platform for developing and running Web-enabled database applications of all sizes. This article outlines the steps needed to access Oracle databases from PHP running under Apache.
If you're like me, you've been running and experimenting with PHP ever since the halcyon, version-3 days when you set it up on your Linux machine along with Apache and MySQL. You, too, hailed the addition of sessions to its ever-increasing functionality and mastered the art of SQL and database design...
