CodeIgniter v3.0.0 API
\

\CI_DB_pdo_result

PDO Result Class

This class extends the parent result class: CI_DB_result

Summary

Methods
Properties
Constants
__construct()
num_rows()
result()
custom_result_object()
result_object()
result_array()
row()
set_row()
custom_row_object()
row_object()
row_array()
first_row()
last_row()
next_row()
previous_row()
unbuffered_row()
num_fields()
list_fields()
field_data()
free_result()
data_seek()
$conn_id
$result_id
$result_array
$result_object
$custom_result_object
$current_row
$num_rows
$row_data
No constants found
_fetch_assoc()
_fetch_object()
No protected properties found
N/A
No private methods found
No private properties found
N/A

Properties

$conn_id

$conn_id : resource|object

Connection ID

Type

resource|object

$result_id

$result_id : resource|object

Result ID

Type

resource|object

$result_array

$result_array : array<mixed,array>

Result Array

Type

array<mixed,array>

$result_object

$result_object : array<mixed,object>

Result Object

Type

array<mixed,object>

$custom_result_object

$custom_result_object : array<mixed,object>

Custom Result Object

Type

array<mixed,object>

$current_row

$current_row : integer

Current Row index

Type

integer

$num_rows

$num_rows : integer

Number of rows

Type

integer

$row_data

$row_data : array

Row data

Type

array

Methods

__construct()

__construct(object  $driver_object) : void

Constructor

Parameters

object $driver_object

num_rows()

num_rows() : integer

Number of rows in the result set

Returns

integer

result()

result(string  $type = 'object') : array

Query result. Acts as a wrapper function for the following functions.

Parameters

string $type

'object', 'array' or a custom class name

Returns

array

custom_result_object()

custom_result_object(string  $class_name) : array

Custom query result.

Parameters

string $class_name

Returns

array

result_object()

result_object() : array

Query result. "object" version.

Returns

array

result_array()

result_array() : array

Query result. "array" version.

Returns

array

row()

row(mixed  $n, string  $type = 'object') : mixed

Row

A wrapper method.

Parameters

mixed $n
string $type

'object' or 'array'

Returns

mixed

set_row()

set_row(mixed  $key, mixed  $value = NULL) : void

Assigns an item into a particular column slot

Parameters

mixed $key
mixed $value

custom_row_object()

custom_row_object(integer  $n, string  $type) : object

Returns a single result row - custom object version

Parameters

integer $n
string $type

Returns

object

row_object()

row_object(integer  $n) : object

Returns a single result row - object version

Parameters

integer $n

Returns

object

row_array()

row_array(integer  $n) : array

Returns a single result row - array version

Parameters

integer $n

Returns

array

first_row()

first_row(string  $type = 'object') : mixed

Returns the "first" row

Parameters

string $type

Returns

mixed

last_row()

last_row(string  $type = 'object') : mixed

Returns the "last" row

Parameters

string $type

Returns

mixed

next_row()

next_row(string  $type = 'object') : mixed

Returns the "next" row

Parameters

string $type

Returns

mixed

previous_row()

previous_row(string  $type = 'object') : mixed

Returns the "previous" row

Parameters

string $type

Returns

mixed

unbuffered_row()

unbuffered_row(string  $type = 'object') : mixed

Returns an unbuffered row and move pointer to next row

Parameters

string $type

'array', 'object' or a custom class name

Returns

mixed

num_fields()

num_fields() : integer

Number of fields in the result set

Overridden by driver result classes.

Returns

integer

list_fields()

list_fields() : boolean

Fetch Field Names

Generates an array of column names

Returns

boolean

field_data()

field_data() : array

Field data

Generates an array of objects containing field meta-data

Returns

array

free_result()

free_result() : void

Free the result

Overridden by driver result classes.

data_seek()

data_seek(integer  $n) : boolean

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.

Overridden by driver result classes.

Parameters

integer $n

Returns

boolean

_fetch_assoc()

_fetch_assoc() : array

Result - associative array

Returns the result set as an array

Returns

array

_fetch_object()

_fetch_object(string  $class_name = 'stdClass') : object

Result - object

Returns the result set as an object

Parameters

string $class_name

Returns

object