php 串連oracle

標籤：

$conn = oci_connect(‘111‘,‘111‘,"(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=10.101.0.36)(PORT = 1521))(CONNECT_DATA =(SID=orcl)))");
  
  if (!$conn) {
   $e = oci_error();
   var_dump($e[‘message‘]);
   //trigger_error(htmlentities($e[‘message‘], ENT_QUOTES), E_USER_ERROR);
  }

  $sql1 = "select * from nls_database_parameters"; // 查詢字元集
  $sql2 = "select userenv(‘language‘) from dual"; // 查詢字元集
  $sql3 = "select * from file ";

  $sql4 = "INSERT INTO file VALUES (‘123010101‘,‘1‘)";
 
  echo "start\n";

  $stmt = oci_parse($conn, "$sql4");
  oci_execute($stmt, OCI_DEFAULT);

  $committed = oci_commit($conn);
  if (!$committed) {
         $error = oci_error($conn);
         echo ‘Commit failed. Oracle reports: ‘ . $error[‘message‘];
     };

  while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
   foreach ($row as $item) {
    echo ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "\n";
   };
  };
  echo "end\n";

  var_dump( oci_close($conn) );

php 串連oracle