php and ora9

dominant

Are the oracle functions compatible with the latest version of oracle?

ishmael437

I am new to php but more familiar with Oracle.

I am curious too. If it fails, the following should work with the idea that you are NOT running the DB and apache/IIS on the same logical computer.

If you use the OCI8 functions just install the oracle 8i client utilitieswhere ever the web server is. To the best of my knowledge and experience, you should have no problem connecting to a 9i database using 8i connectivity. However if you are calling specific 8i functions like initcap(), sum() in your sql which are specific to Oracle's version of SQL you might run into some issues. But for the most part Oracle does a very good job of compatability.

On other applications I have used Oracle 7.3 client utilities to connect to Oracle 8.1.7 databases because the application was originally designed against an Oracle 7.3 database.

Test it out. Using a separate computer download the 9i database and move your tables over. 9i should be able to import an 8i export. Once you get yout tables and any data over just change your connection info. I have left HUGE amounts of oracle stuff to do and watch out for like NLS_LANG but check the oracle forums if you have problems.

dominant

i have installed the ora9(9.2.0.1) database on my pc and the ORACLE_HOME is c:\oracle\ora92, what i need to configure in order to get connected with the ora9 through the php?

ishmael437

Information for Oracle and PHP is very few and far between. What I found out I did not find at PHP.net or here I believe. I GOOGLEd the topic and found a few sites related to it. What I have here is a condensed version so do not take it as gospel but it should give you the general motions of what you should do. The following is my crib sheet of the installation I am currently developing on.

1 Install database (8.1.7)
2. Install Apache 2 (2.0.45)
3. Install PHP 4 (4.3.2)

 A. Install via the msi installer (php-4.3.2-installer.exe)
      Advanced
      C:\PHP
      Backup yes
      ...
      Apache
      ...

B. Unzip win32 zip file(php-4.3.2-Win32.zip)
      Copy extensions and sapi directories to C:\PHP
      copy php4ts.dll to the same dir as php4apache2.dll.

 C. Configure php.ini
      uncomment:	extension=php_oci8.dll ***
      modify: 	extension_dir = "C:\php\extensions"

 D. Configure httpd.conf
      Add the three lines at the bottom
         LoadModule php4_module C:/php/sapi/php4apache2.dll
         AddType application/x-httpd-php .php .phtml .php3 .php4
         AddType application/x-httpd-php-source .phps

*** Optionally, not both, uncomment extension=php_oracle.dll. This may indeed be the library you want but info is thin.

ishi

dominant

i suppose when you say uncomment you mean to remove the semicolons infornt fo the dll. Should we configure the path to Oracle(in my case c:\oracle\ora92)?

Here is a nice tutorial for the Apache and php (and mysql as well)
http://internetmaster.com/installtutorial/

dominant

any idea?

dominant

anyhelp?

dominant

i have created a script. I am not sure if that are the basics steps for a simple query.

I have also pre-created an oracle database called john

<?

$connection=ora_logon("system","john2");

$cursor = ora_open($connection);


$query="SELECT * FROM hr.countries");


$result=ora_parse($cursor,$query);

$result = ora_exec($cursor);

ora_exec($cursor,$query);


ora_commit($connection);
ora_close($cursor);
ora_logoff($connection);

?>

Is that the correct method to connect with the oracle?

dominant

any help?