PHP oci8 Small test

Oracle_db.class.php

Class oracle_db{
Public $link;
Public Function __construct () {
$this->link= $this->connect ();
if (! $this->link) {
echo "Connection Failed";
Exit
}
}
Public Function connect () {
Return Oci_connect (' demo ', ' demo ', ' Localhost/xe ', ' Al32utf8 ');
}
Public function Execute ($sql) {
$result =false;
$stid =oci_parse ($this->link, $sql);
if ($stid) {
$result =oci_execute ($stid);
}
Return Array ($stid, $result);
}
Public Function Fetch_assoc ($stid) {
Return Oci_fetch_assoc ($stid);
}

Public Function Fetch_one ($stid) {
$arr = $this->fetch_assoc ($stid);
$this->free ($stid);
return $arr;
}
Public Function Fetch_all ($stid) {
$arr =array ();
while ($row = $this->fetch_assoc ($stid)) {
$arr []= $row;
}
$this->free ($stid);
return $arr;
}
Public Function Num_rows ($stmt) {
Return Oci_num_rows ($stmt);
}
Public Function error () {
Return Oci_error ($this->link);
}
Public function Free ($stid) {
Return oci_free_statement ($stid);
}
Public Function server_version () {
Return oci_server_version ($this->link);
}
Public Function client_version () {
return Oci_client_version ();
}
Public Function __destruct () {
Return Oci_close ($this->link);
}
//
}

The above introduces the PHP oci8 small test, including the aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

