Hi Roger,

There is Oracle Commander , but it is not very good as phpMyAdmin. Try it:

Oracle is similar to other databases used from PHP, only difference is
calling stored procedures that return resultset.
Dont use oracle functions, but oracle8 (oci) extension for Oracle, they are
better documented and easier to use.

There is PHP manual that can help you learn oracle+php. If u have some
questions you can ask here.
For example, there are couple of functions i wrote to myself:

Some ppl say you should put environment variables, before connecting:

putenv( "ORACLE_HOME=/usr/oracle/product/9.2.0" );

$connection = OCIPlogon($user,$pass,$dbname);

function query($sql)
if ($query)
return $query;

function query_fetch_array($query)
if (OCIFetchInto($query,$result,OCI_ASSOC+OCI_NUM+OCI_RETURN_NULLS))
return $result;
return 0;

$sql="select * from emp";
while ($row=query_fetch_array($query))
  // You can user $row["EMPNO"] or $row[0]...


"Roger Spears" <[EMAIL PROTECTED]> wrote in message
> Hello,
> I was wondering if there are any PHP people out there that are really
> into using Oracle databases?  I've always used mysql but now I find
> myself in a situation that requires the use of an Oracle database.
> I've printed out the information posted by Thies C. Arntzen titled
> "Making Efficient use of Oracle8i thru Apache and PHP 4" but I was
> wondering if I may see some other code examples.  Very basic examples
> dealing with connections, queries and the such.  Also, is there an
> application for Oracle databases that is similar to PHPMyAdmin for mysql
> databases?
> Thanks,
> Roger

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to