php-adodb-oci8po

e.g.

include "adodb/adodb.inc.php";
include "adodb/adodb-errorhandler.inc.php";
//	include ".adodb/adodb-csvlib.inc.php";
//	include "adodb/adodb-lib.inc.php";
$ADODB_CACHE_DIR = 'adodbcache'; 
$db = NewADOConnection("oci8po");
putenv("NLS_LANG=AMERICAN_AMERICA.UTF8");

$TNS = '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 8080)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name) ) )';

//$db->SetCharSet('AMERICAN_AMERICA.ZHS16GBK');
$db->Connect($TNS, db_user,db_pwd);

//使用   e.g.
$sql = "select 
              *
          from 
              table_test t
          where 
             t.sex=?
          ";
$rs = $db->Execute($sql,[1]);

/**
while($row=$rs->FetchNextObject()) {
    echo $row->SUPPLIER_NAME;
}
*/

$i=0;
while(!$rs->EOF){
	$i++;
	//获取字段
	$name = $rs->fields("name");
	$age=$rs->fields("age");
	$rs->MoveNext();
}

$rs->colse();