Gitee
\
Acme
app
index
controller
Composer
Autoload
GuzzleHttp
Cookie
Exception
Handler
Promise
Psr7
JPush
Exceptions
Tests
Monolog
Formatter
Handler
Curl
FingersCrossed
Slack
SyslogUdp
Processor
Obs
Common
Log
S3
Resource
Signature
OSS
Core
Http
Model
Result
Tests
Psr
Http
Message
Log
Test

\CI_DB_result

Database Result Class

This is the platform-independent result class. This class will not be called directly. Rather, the adapter class for the specific database will extend and instantiate it.

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() : array

Fetch Field Names

Generates an array of column names.

Overridden by driver result classes.

Returns

array

field_data()

field_data() : array

Field data

Generates an array of objects containing field meta-data.

Overridden by driver result classes.

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.

Overridden by driver result classes.

Returns

array

_fetch_object()

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

Result - object

Returns the result set as an object.

Overridden by driver result classes.

Parameters

string $class_name

Returns

object