<?php putenv("ORACLE_SID=oracle8"); putenv("ORACLE_HOME=/oracle/product/release/8.1.5"); class db_sql { var $Debug = 0; var $sqoe = 1; // sqoe= show query on error var $Database = "dev"; var $User = "scott"; var $Password = "tiger"; var $Link_ID = 0; var $Record = array(); var $Row; var $numRow; var $Parse; var $Error = ""; function connect() { if ( 0 == $this->Link_ID ) { if($this->Debug) { printf("<br>Connecting to $this->Database...<br>/n"); } $this->Link_ID=OCILogon("$this->User","$this->Password"); if (!$this->Link_ID) { $this->halt("Link-ID == false " . "($this->Link_ID), OCILogon failed"); } if($this->Debug) { printf("<br>Obtained the Link_ID: $this->Link_ID<br>/n"); } } } function query($Query_String) { if($Query_String=="") { echo "执行语句不能为空!"; return false; } $this->connect(); $this->Parse=OCIParse($this->Link_ID,$Query_String); if(!$this->Parse) { $this->Error=OCIError($this->Parse); } else { OCIExecute($this->Parse); $this->Error=OCIError($this->Parse); } $this->Row=0; if($this->Debug) { printf("Debug: query = %s<br>/n", $Query_String); } if ($this->Error["code"]!=1403 && $this->Error["code"]!=0 && $this->sqoe) echo "<BR><FONT color=red><B>".$this->Error["message"]."<BR&
PHP连接Oracle数据库类
最新推荐文章于 2021-03-27 20:35:24 发布