php7连接oracle11g

到：
https://pecl.php.net/package/oci
下载 oci8扩展。Use 'pecl install oci8-2.2.0' to install for PHP 7.
根据php的具体版本类型下载对应的DLL。

在php.ini中加上以下扩展：

extension=php_oci8.dll

extension=php_oci8_11g.dll

<?php
  putenv("NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8");
  //oci_connect可换成oci_pconnect，即持久连接，可在后续的连接中节省时间，提高响应速度。 
  //$conn = oci_connect('scott','tiger',"//ip or domain name:1521/orcl");
  $conn = oci_pconnect('scott','tiger',
  "(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =[your host ip])(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    ))" 

  );
  if (!$conn)
  {
    $Error = oci_error();
    print htmlentities($Error['message']);
    exit;
  }
  else
  {
    echo "Connected Oracle Successd!"."<br>";
    //ocilogoff($conn);
    $sql = "select * from scott.dept";
    $ora_test = oci_parse($conn,$sql);  //编译sql语句 
    oci_execute($ora_test,OCI_DEFAULT);  //执行 
    while($r=oci_fetch_row($ora_test))  //取回结果 
    { 
        $i=0;
        echo $ora_test[0]; 
        echo "<BR>";   
        echo $r[$i++]."  </t>  ";
        echo $r[$i++]."  </t>  ";
        echo $r[$i++]."  </t>  "; 
    }
  }
?>