CI_DB_sqlite_result Class Reference

Inheritance diagram for CI_DB_sqlite_result:

[legend]

Collaboration diagram for CI_DB_sqlite_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_names ()
	field_data ()
	Field data.
	free_result ()
	Free the result.
	_data_seek ($n=0)
	Data Seek.
	_fetch_assoc ()
	Result - associative array.
	_fetch_object ()
	Result - object.

---

Detailed Description

Definition at line 27 of file sqlite_result.php.

---

Member Function Documentation

CI_DB_sqlite_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 132 of file sqlite_result.php.

        {
                return sqlite_seek($this->result_id, $n);
        }

CI_DB_sqlite_result::_fetch_assoc

(

)

Result - associative array.

Returns the result set as an array

private

Returns:

array

Reimplemented from CI_DB_result.

Definition at line 147 of file sqlite_result.php.

        {
                return sqlite_fetch_array($this->result_id);
        }

CI_DB_sqlite_result::_fetch_object

(

)

Result - object.

Returns the result set as an object

private

Returns:

object

Reimplemented from CI_DB_result.

Definition at line 162 of file sqlite_result.php.

        {
                if (function_exists('sqlite_fetch_object'))
                {
                        return sqlite_fetch_object($this->result_id);
                }
                else
                {
                        $arr = sqlite_fetch_array($this->result_id, SQLITE_ASSOC);
                        if (is_array($arr))
                        {
                                $obj = (object) $arr;
                                return $obj;
                        } else {
                                return NULL;
                        } 
                }
        }

CI_DB_sqlite_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 90 of file sqlite_result.php.

References num_fields().

        {
                $retval = array();
                for ($i = 0; $i < $this->num_fields(); $i++)
                {
                        $F                              = new stdClass();
                        $F->name                = sqlite_field_name($this->result_id, $i);
                        $F->type                = 'varchar';
                        $F->max_length  = 0;
                        $F->primary_key = 0;
                        $F->default             = '';

                        $retval[] = $F;
                }
                
                return $retval;
        }

Here is the call graph for this function:

CI_DB_sqlite_result::field_names

(

)

Reimplemented from CI_DB_result.

Definition at line 75 of file sqlite_result.php.

References list_fields().

        {
                return $this->list_fields();
        }

Here is the call graph for this function:

CI_DB_sqlite_result::free_result

(

)

Free the result.

Returns:

null

Reimplemented from CI_DB_result.

Definition at line 115 of file sqlite_result.php.

        {
                // Not implemented in SQLite
        }

CI_DB_sqlite_result::list_fields

(

)

Fetch Field Names.

Generates an array of column names

public

Returns:

array

Reimplemented from CI_DB_result.

Definition at line 63 of file sqlite_result.php.

References num_fields().

Referenced by field_names().

        {
                $field_names = array();
                for ($i = 0; $i < $this->num_fields(); $i++)
                {
                        $field_names[] = sqlite_field_name($this->result_id, $i);
                }
                
                return $field_names;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

CI_DB_sqlite_result::num_fields

(

)

Number of fields in the result set.

public

Returns:

integer

Reimplemented from CI_DB_result.

Definition at line 48 of file sqlite_result.php.

Referenced by field_data(), and list_fields().

        {
                return @sqlite_num_fields($this->result_id);
        }

Here is the caller graph for this function:

CI_DB_sqlite_result::num_rows

(

)

Number of rows in the result set.

public

Returns:

integer

Reimplemented from CI_DB_result.

Definition at line 35 of file sqlite_result.php.

        {
                return @sqlite_num_rows($this->result_id);
        }

---

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

• sqlite_result.php