PHP connects to Oracle database under Win7 64-bit system

Let’s talk about the configuration process

1. Download oracle instantclient

Download address: http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Download instantclient-basic-windows.x64-11.2.0.4.0

Decompression path: D:\Program Files (x86)\Oracle64Client\instantclient_11_2

*Note: Client required Corresponds to the database version.

2. Configure system environment variables

Add after the PATH environment variable: ;D:\Program Files (x86)\Oracle64Client\instantclient_11_2

3. Configure PHP to support OCI Extension

Modify the configuration file php.ini

Open the configuration as follows

##4. Restart the Apache service test

Use Probe function phpinfo() checks whether the extension is enabled. If the following figure appears, the extension is enabled

5. Test database connection

Write oracle in the root directory of the site .php, I am connecting to the Oralce database in the virtual machine CentOS

The code is as follows:

<?php
  $conn = ocilogon(&#39;test&#39;,&#39;test&#39;,&#39;192.168.23.131:1521/dev&#39;);
  if (!$conn)
  {
    $Error = oci_error();
    print htmlentities($Error[&#39;message&#39;]);
    exit;
  }
  else
  {
    echo "Connected Oracle Successd!"."<br>";
    ocilogoff($conn);
  }
?>

Enter http://localhost/oracle.php

in the browser address bar If Connected Oracle Successd! is displayed, the database connection is successful.

For more articles related to PHP connecting to Oracle database under Win7 64-bit system, please pay attention to PHP Chinese website!