OCI8

You need the following (once logged in) from Oracle Instant Client:

• oracle-instantclient-basic
• oracle-instantclient-devel

You also need to install two PHP related packages, namely:

• php-pear
• php-devel

You might need to update the channel data of pear and pecl by:

• pear channel-update pear.php.net
• pecl channel-update pecl.php.net

Now you should be able to install oci8 with the following command:

• sudo pecl install oci8

Finally edit /etc/php.ini and add the line bellow in the extensions section:

• extension=oci8.so

See also the php-oracle manual

Example

       # Here's how we connect:
      $dbh = oci_connect ('USERNAME', 'PASSWD', '//172.31.5.337:1521/ORACL');
      # Here's how we pass an sql statement:
      $stmt = oci_parse ($dbh, 'SELECT USERNAME, PASSWORD FROM TABLE');
      # Here we execute the statement:
      oci_execute ($stmt);
      $cnt = 1;
      # Then we fetch rows in a loop until we're done
      while ($result = oci_fetch_array($stmt)) {
              echo "user: " . $cnt . " " . $result['USERNAME'] .
              " " . $result['PASSWORD'] . "
";
              $cnt = $cnt +1;
      }
      # last we close the database handle
      oci_close($dbh);
      # and note to the parser that this is the end of the php code section