PHPDeveloper.org

Christopher Jones' Blog: Oracle Instant Client 10.2.0.4 for Mac OS X Intel x86 is Available

Thu, 24 Apr 2008 07:50:50 -0500

Christopher Jones has posted about the latest Instant Client release for the Intel chips running OS X:

Hot off the press, Kuassi points out that Oracle Instant Client for Apple Mac OS X (Intel x86) is now available from the Instant Client page on OTN. It's the latest 10.2.0.4 patchset.

The 10.2.0.4 release of Instant Client for Windows 32bit and Linux x86 have also been released.

The Oracle Instant Client is a lightweight version of the standard Oracle functionality that's not only smaller but allows installation of an Oracle client without having to do the full Oracle install.

Christopher Jones' Blog: Temporary LOBS in PHP's OCI8 Extension. Instant Client.

Mon, 21 Jan 2008 12:05:00 -0600

Christopher Jones talks today on his blog about a bug he's just corrected and integrated into the release of the Oracle Instant Client that lets PHP correctly take advantage of the temporary LOBS functionality.

When PHP is done with the temporary LOB, it needs to tell Oracle to destroy it. If this isn't done, then the temporary LOB will hang around using DB space until the connection is closed. I just merged a fix worked on by Krishna Mohan and myself for bug 43497.

Example code is included showing two instances of its use - a normal use that frees the memory correctly and the other showing how to create the temporary lob to hold the data as needed.

Gennady Feldman's Blog: Installing Oracle Instant Client and making it work with PHP

Mon, 05 Nov 2007 12:53:00 -0600

Maggie Nelson has linked to a blog post detailing one of the simplest ways to get a powerful database system, Oracle, up and working with PHP:

This is something that I wanted to post up for a while, because this is rather simple stuff and yet it took me a while to put this whole thing together for my own use/setup. It's also something that got some people interested and they asked me to post this up. So this post is for Maggie Nelson who is an active PHP and Oracle advocate.

It's basically an eleven step process to get things up and working (on linux) and involves installing RPMs, editing config files, and configuring the PHP installation to pull in the Oracle module.

HowToForge.com: Building Apache with PHP,MySQL, OCI8 instant client support

Wed, 03 Jan 2007 07:41:00 -0600

The HowToForge has posted a new tutorial that will guide you through the installation of a server with Apache, PHP, MySQL, and OCI8 Instant Client support.

There are many howtos on building Apache with PHP, MYSQL support, but it is very rare to find some document on OCI8 support with Apache Build [...] I was searching some installation document, there are few documents , but most of them are using either RPM version of packages or they are missing some of the essential steps.

He starts with his platform (IBM x system x86_64 bit server with RHEL 4 Update Level 4) and grabs the parts first - the instant client, then Apache, then PHP. MySQL is already installed on the machine and is included in the PHP build via the configure call. They provide all of the shell commands you'll need to get things working as well as any changes that might need to be made to the configuration files in the process.

Paul Jones' Blog: Instant Forms from Tables with Solar

Fri, 14 Apr 2006 08:21:28 -0500

Paul Jones, in response to a question about his Solar framework concerning the creation of forms using table definitions, has answered "yes!" and shows us how in this new post.

Here's an example: 2 lines to start Solar, 2 lines to connect to an existing Solar_Sql_Table, 2 lines to create a Solar_Form using the table columns, and 2 lines to display it with Solar_View using the associated form helper. (The "Solar_Model_Nodes" table is part of the existing Solar_Content domain model.)

He gives the code needed to make it happen as well as a brief explaination on how it all works.