php连接Oracle的方法（ADODB）

zhgc

php.ini中打开OCI

extension=php_oci8_12c.dll  ; Use with Oracle Database 12c Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll

不知道为什么，不打开php_oci8_12c.dll会不行


下载客户端：

E:\instantclientbasicwindowsx64_v12.2.0.1.0_itmop.com.zip
解压后，path里加上E:\instantclient_12_2;


就可以连接了

1. <?php
   
2. 
   
3. error_reporting(0);
   
4. 
   
5. require_once('adodb/adodb.inc.php');
   
6. 
   
7. $conn = NewADOConnection('oci8');
   
8. $conn->debug = true;
   
9. $ret=$conn->connect('192.168.80.1', 'Loginuser', 'Loginuser', 'ent');
   
10. //$conn->SetFetchMode(ADODB_FETCH_ASSOC);
    
11. //$conn->Execute("set names {$config->site_charset}");
    
12. 
    
13. $sql="select 78 from dual";
    
14. 
    
15. $ret=$conn->getOne($sql);
    
16. var_dump($ret);

复制代码

zhgc

关于中文乱码的问题：
SELECT * FROM Nls_Database_Parameters
NLS_NCHAR_CHARACTERSET
NLS_CHARACTERSET  AL32UTF8
NLS_DATE_FORMAT DD-MON-RR
NLS_NCHAR_CHARACTERSET  UTF8

select Userenv('language')  from dual
AMERICAN_AMERICA.AL32UTF8
AMERICAN_AMERICA.AL32UTF8

最后方案：

在cmd里加set NLS_LANG=American_America.ZHS16GBK
或在环境里配NLS_LANG


<?php

error_reporting(0);

//$str1="王军";
//$str=iconv('utf-8','gb2312', $str1);
//echo $str;



require_once('adodb/adodb.inc.php');

$conn = NewADOConnection('oci8');
//$conn->debug = true;
$conn->connect('192.168.80.18', ' ', ' ', 'enti  ');
$conn->charSet ='utf-8';
$conn->SetFetchMode(ADODB_FETCH_ASSOC);
//$db->Execute("set names {$config->site_charset}");
//$sql="select Userenv('language')  from dual";
//$table=$conn->getAll($sql);
//var_dump($table);

$sql="select
ROLEID, ROLE_NAME, ROLE_DESC, REMARK, DATA_VALID, MODIFY_USERID, MODIFY_DATETIME
from entiredba.bs_role";

$table=$conn->getAll($sql);
//$str=var_export($table[1],true);
//echo $str;


$mes = NewADOConnection('mysqli');
$mes->Connect("192.168.80.11", " ", " @!", "wes");
$mes->Execute("set names gbk");

foreach($table as $line){
        $sql="delete from entiredba.bs_role where ROLEID='".$line["ROLEID"]."' limit 1";
        $rst=$mes->execute($sql);
        if($rst){
                                //
        }else{
                echo($mes->ErrorMsg());
        }
       
        $emp="'".$line["MODIFY_USERID"]."'";
        if(strlen($line["MODIFY_USERID"])<2){
                $emp="null";
        }
        $ROLE_DESC=$line["ROLE_DESC"];
        $ROLE_DESC=str_replace("'"," ",$ROLE_DESC);
        $REMARK=$line["REMARK"];
        $REMARK=str_replace("'"," ",$REMARK);
        $sql="INSERT INTO entiredba.bs_role(ROLEID, ROLE_NAME, ROLE_DESC, REMARK, DATA_VALID, MODIFY_USERID, MODIFY_DATETIME) VALUES ('".$line["ROLEID"]."', '".$line["ROLE_NAME"]."', '".$ROLE_DESC."','".$REMARK."','".$line["DATA_VALID"]."', {$emp}, now())";
        $rst=$mes->execute($sql);
        if($rst){
                        echo ".";
        }else{
                echo($mes->ErrorMsg());
        }
       

}

zhgc

NLS_LANG
AMERICAN_AMERICA.UTF8

1. <?php
   
2. 
   
3. error_reporting(0);
   
4. 
   
5. require_once('adodb/adodb.inc.php');
   
6. 
   
7. $conn = NewADOConnection('oci8');
   
8. //$conn->debug = true;
   
9. $conn->connect('192.168.0.18', 'user', '0901', 'entire');
   
10. $conn->SetFetchMode(ADODB_FETCH_ASSOC);
    
11. //$db->Execute("set names {$config->site_charset}");
    
12. 
    
13. $sql="select
    
14. ROLEID, USERID, MODIFY_USERID, MODIFY_DATETIME
    
15. from entiredba.bs_role_user";
    
16. 
    
17. $table=$conn->getAll($sql);
    
18. 
    
19. //var_dump($table);
    
20. 
    
21. $mes = NewADOConnection('mysqli');
    
22. $mes->Connect("192.168.80.11", "sklwes", "sklwes@!", "wes");
    
23. $mes->Execute("set names utf8");
    
24. foreach($table as $line){
    
25.         $sql="delete from entiredba.bs_role_user where ROLEID='".$line["ROLEID"]."' and USERID='".$line["USERID"]."' limit 1";
    
26.         $rst=$mes->execute($sql);
    
27.         if($rst){
    
28.                                 //
    
29.         }else{
    
30.                 echo($mes->ErrorMsg());
    
31.         }
    
32.         
    
33.         $emp="'".$line["MODIFY_USERID"]."'";
    
34.         if(strlen($line["MODIFY_USERID"])<2){
    
35.                 $emp="null";
    
36.         }
    
37.         $sql="INSERT INTO entiredba.bs_role_user(ROLEID, USERID, MODIFY_USERID, MODIFY_DATETIME) VALUES ('".$line["ROLEID"]."', '".$line["USERID"]."', {$emp}, now())";
    
38.         $rst=$mes->execute($sql);
    
39.         if($rst){
    
40.                         echo ".";
    
41.         }else{
    
42.                 echo($mes->ErrorMsg());
    
43.         }
    
44.         
    
45. 
    
46. }

复制代码