Calling example:

LOGOn("www","99","corn");

###############################################

$newOda->CmdString=" update test set nouse='dfs' where login_name='guoyafeng'";

if(!$newOda->Execute()) {

echo $newOda->err;

}

else

{

echo $newOda->Rows; #get the affected row number.

}

#or you can call execute like this####

/*

$newOda->Execute(" update test set nouse='dfs' where login_name='guoyafeng'");

*/

#############################

#the following demostrate the open method.

$newOda->Open("select * from test")) or die $newOda->err;

#Get data from RS

echo "count is" .$newOda->Rows;

for($i=0;$iRows;$i++)

for($j=0;$jCols;$j++)

{

echo $newOda->RS[$i][$j];

}

$newOda->LOGOff();

?>

conn=$cn;

return TRUE;

}

function LOGOn($user,$pass,$db) {

if(!($this->conn = OCILOGOn($user, $pass, $db))){

$this->err_no=106;

$this->err="Error 106: Failed to LOGOn.";

return FALSE;

};

return TRUE;

}

function Open($sql="") file://$this->CmdString

{

if($this->conn=="") {

$this->err_no=100;

$this->err="Error 100,Connection Object Required.";

return FALSE;

}

if($sql=="" and $this->CmdString=="") {

$this->err_no=101;

$this->err="Error 101,SQL Statement Required.";

return FALSE;

}

if($sql=="")

$sql=$this->CmdString;

if(!($cursor=OCIParse($this->conn,$sql))) {

$this->err_no=102;

$this->err="Server Internal Error: Failed to parse SQL Statement.";

return FALSE;

}

if(!OCIExecute($cursor)) {

$this->err_no=103;

$this->err="Server Internal Error: Failed to execute SQL Statement.";

return FALSE;

}

$this->Rows=0;

while(OCIFetchInto($cursor,$this->RS[$this->Rows])){

$this->Rows++;

}

$this->Cols=OCINumCols($cursor);

if($this->Rows==0) {

$this->err_no=104;

$this->err="Warning: No rows affectted.RS result is not available.";

}

OCIFreeStatement($cursor);

return TRUE;

}

function Execute($sql="") {

if($this->conn=="") {

$this->err_no=100;

$this->err="Error 100,Connection Object Required.";

return FALSE;

}

if($sql=="" and $this->CmdString=="") {

$this->err_no=101;

$this->err="Error 101,SQL Statement Required.";

return FALSE;

}

if($sql=="")

$sql=$this->CmdString;

if(!($cursor=OCIParse($this->conn,$sql))) {

$this->err_no=102;

$this->err="Server Internal Error: Failed to parse SQL Statement.";

return FALSE;

}

if(!OCIExecute($cursor)) {

$this->err_no=103;

$this->err="Server Internal Error: Failed to execute SQL Statement.";

return FALSE;

}

$this->Rows=OCIRowCount($cursor);

OCIFreeStatement($cursor);

return TRUE;

}

function LOGOff(){

if(!OCILOGOff($conn)){

$this->err_no=105;

$this->err="Server Internal Error: Failed to LOGOff database.";

return FALSE;

}

return TRUE;

}

}

?>