php操作oracle

来源：互联网发布：合肥seo网络推广编辑：程序博客网时间：2024/06/02 06:22

<?php

echo "测试代码";

//phpinfo();

/*
if ($conn=Ora_Logon("system@LISTENER1","manager"))
{
echo "<B>SUCCESS ! Connected to database<B>n";
}
else
{
echo "<B>Failed :-( Could not connect to database<B>n";
}
*/

/*
$conn = oci_connect('system','manager',"127.0.0.1:1521/orcl");
if(!$conn){
    $e = oci_error();
    print htmlentities($e['message']);
    exit();
}
*/

/*
$db = "(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pc11)(PORT = 1521))
))";

$c1 = oci_connect("system","manager",$db);
*/

/*
$con2=OCILogon("system","manager","//127.0.0.1:1521/orcl");
var_dump($con2);
die("连接失败");
*/

//var_dump($c1);

/*
$conn = oci_connect('system', 'manager', '127.0.0.1:1521/orcl'); // 建立连接
if(!$conn){
    $e = oci_error();
    print htmlentities($e['message']);
    exit;
}
*/

/*
$stack = array("orange", "banana");
array_push($stack, "apple", "raspberry");
print_r($stack);
*/

$stack = array();

$dbconn=OCILogon("scott","12345","orcl");
$sql ="select t.*, t.rowid from MYTEST t";
$stmt = OCIParse($dbconn, $sql);
if(!$stmt) {
echo "<h1>ERROR - Could not parse SQL statement.</h1>";
exit;
}
OCIExecute($stmt);
while( OCIFetchInto($stmt, $result_array) )
{

//echo "EMPno=".$result_array[0]."Ename=".$result_array[1]."JOB=".$result_array[2]."<BR>";

var_dump($result_array[0]);

echo $result_array[1]."</br>";

array_push($stack,$result_array);

//echo count($result_array[1]);

}

//print_r($stack);

echo $stack[0][0];
echo "<br/>";

/*

//$conn = oci_connect('SYSTEM', 'MANAGER', '127.0.0.1:1521/orcl');

$conn = oci_connect('scott', '12345', '127.0.0.1:1521/orcl');

//var_dump($conn);

//$query='select * from SYSTEM.EMPLOYEE';

$query='select t.*, t.rowid from MYTEST t';

//$statement=oci_parse($conn,$query);

$rs = oci_parse($conn,$query);

var_dump($rs);

if(!$rs){
    $e = oci_error($conn);
    print htmlentities($e['message']);
    exit;
    }

//$result = oci_execute($rs,OCI_DEFAULT);

$result = oci_execute($rs);

if(!$result){
    $e = oci_error($result);
    echo htmlentities($e['message']);
    exit;
}

oci_fetch_all($rs,$result);
       foreach($result as $rows){
           //echo '';
           foreach($rows as $col_values){
           echo $col_values;
           }
       }

print '<table border="1">';
while($row = oci_fetch_array($rs, OCI_RETURN_NULLS)) {
    print '<tr>';
        foreach($row as $item){
                //print '<td>'.($item?htmlentities($item):'').'</td>';

               print '<td>'.$item.'</td>';
            }
        print '</tr>';
    }
print '</table>';

*/

/*
oci_execute($statement);

//取得结果数据
       oci_fetch_all($statement,$result);
       foreach($result as $rows){
           echo '';
           foreach($rows as $col_values){
           echo $col_values;
           }
       }
*/

echo 'ok';

?>

0 0