CI_DB_oci8_result Class Reference

Inheritance diagram for CI_DB_oci8_result:

[legend]

Collaboration diagram for CI_DB_oci8_result:

[legend]

List of all members.

Public Member Functions
	num_rows ()
	Number of rows in the result set.
	num_fields ()
	Number of fields in the result set.
	list_fields ()
	Fetch Field Names.
	field_data ()
	Field data.
	free_result ()
	Free the result.
	_fetch_assoc (&$row)
	Result - associative array.
	_fetch_object ()
	Result - object.
	result_array ()
	Query result.
	_data_seek ($n=0)
	Data Seek.
Public Attributes
	$stmt_id
	$curs_id
	$limit_used

---

Detailed Description

Definition at line 27 of file oci8_result.php.

---

Member Function Documentation

CI_DB_oci8_result::_data_seek

(

$

n = 0

)

Data Seek.

Moves the internal pointer to the desired offset. We call this internally before fetching results to make sure the result set starts at zero

private

Returns:

array

Definition at line 240 of file oci8_result.php.

        {
                return FALSE; // Not needed
        }

CI_DB_oci8_result::_fetch_assoc

(

&$

row

)

Result - associative array.

Returns the result set as an array

private

Returns:

array

Definition at line 151 of file oci8_result.php.

        {
                $id = ($this->curs_id) ? $this->curs_id : $this->stmt_id;
        
                return ocifetchinto($id, $row, OCI_ASSOC + OCI_RETURN_NULLS);   
        }

CI_DB_oci8_result::_fetch_object

(

)

Result - object.

Returns the result set as an object

private

Returns:

object

Reimplemented from CI_DB_result.

Definition at line 168 of file oci8_result.php.

References result_array().

        {       
                $result = array();

                // If PHP 5 is being used we can fetch an result object
                if (function_exists('oci_fetch_object'))
                {
                        $id = ($this->curs_id) ? $this->curs_id : $this->stmt_id;
                        
                        return @oci_fetch_object($id);
                }
                
                // If PHP 4 is being used we have to build our own result
                foreach ($this->result_array() as $key => $val)
                {
                        $obj = new stdClass();
                        if (is_array($val))
                        {
                                foreach ($val as $k => $v)
                                {
                                        $obj->$k = $v;
                                }
                        }
                        else
                        {
                                $obj->$key = $val;
                        }
                        
                        $result[] = $obj;
                }

                return $result;
        }

Here is the call graph for this function:

CI_DB_oci8_result::field_data

(

)

Field data.

Generates an array of objects containing field meta-data

public

Returns:

array

Reimplemented from CI_DB_result.

Definition at line 108 of file oci8_result.php.

References num_fields().

        {
                $retval = array();
                $fieldCount = $this->num_fields();
                for ($c = 1; $c <= $fieldCount; $c++)
                {
                        $F                        = new stdClass();
                        $F->name                = ocicolumnname($this->stmt_id, $c);
                        $F->type                = ocicolumntype($this->stmt_id, $c);
                        $F->max_length  = ocicolumnsize($this->stmt_id, $c);

                        $retval[] = $F;
                }

                return $retval;
        }

Here is the call graph for this function:

CI_DB_oci8_result::free_result

(

)

Free the result.

Returns:

null

Reimplemented from CI_DB_result.

Definition at line 132 of file oci8_result.php.

        {
                if (is_resource($this->result_id))
                {
                        ocifreestatement($this->result_id);                     
                        $this->result_id = FALSE;
                }
        }

CI_DB_oci8_result::list_fields

(

)

Fetch Field Names.

Generates an array of column names

public

Returns:

array

Reimplemented from CI_DB_result.

Definition at line 87 of file oci8_result.php.

References num_fields().

        {
                $field_names = array();
                $fieldCount = $this->num_fields();
                for ($c = 1; $c <= $fieldCount; $c++)
                {
                        $field_names[] = ocicolumnname($this->stmt_id, $c);
                }
                return $field_names;
        }

Here is the call graph for this function:

CI_DB_oci8_result::num_fields

(

)

Number of fields in the result set.

public

Returns:

integer

Reimplemented from CI_DB_result.

Definition at line 64 of file oci8_result.php.

Referenced by field_data(), and list_fields().

        {
                $count = @ocinumcols($this->stmt_id);

                // if we used a limit we subtract it
                if ($this->limit_used)
                {
                        $count = $count - 1;
                }

                return $count;
        }

Here is the caller graph for this function:

CI_DB_oci8_result::num_rows

(

)

Number of rows in the result set.

Oracle doesn't have a graceful way to retun the number of rows so we have to use what amounts to a hack.

public

Returns:

integer

Reimplemented from CI_DB_result.

Definition at line 43 of file oci8_result.php.

References result_array().

        {
                $rowcount = count($this->result_array());
                @ociexecute($this->stmt_id);

                if ($this->curs_id)
                {
                        @ociexecute($this->curs_id);
                }

                return $rowcount;
        }

Here is the call graph for this function:

CI_DB_oci8_result::result_array

(

)

Query result.

"array" version.

public

Returns:

array

Reimplemented from CI_DB_result.

Definition at line 210 of file oci8_result.php.

References CI_DB_result::_fetch_assoc().

Referenced by _fetch_object(), and num_rows().

        {
                if (count($this->result_array) > 0)
                {
                        return $this->result_array;
                }

                // oracle's fetch functions do not return arrays.
                // The information is returned in reference parameters
                $row = NULL;
                while ($this->_fetch_assoc($row))
                {
                        $this->result_array[] = $row;
                }

                return $this->result_array;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

---

Member Data Documentation

CI_DB_oci8_result::$curs_id

Definition at line 30 of file oci8_result.php.

CI_DB_oci8_result::$limit_used

Definition at line 31 of file oci8_result.php.

CI_DB_oci8_result::$stmt_id

Definition at line 29 of file oci8_result.php.

---

The documentation for this class was generated from the following file:

• oci8_result.php