Class||Interface SelectQueryResult

Summary

File
Package
\IO\DB
Parents \QueryResult

copyright
© 2005-2020 PHPBoost
license
https://www.gnu.org/licenses/gpl-3.0.html GNU/GPL-3.0
author
Loic ROUCHON horn@phpboost.com
version
PHPBoost 6.0 - last update: 2014 12 22
since
PHPBoost 3.0 - 2009 11 02

this class encapsulate a query result set usage is: <code> foreach ($my_query_result as $result) { // do something with the $result } </code>

Constants

FETCH_NUM

FETCH_NUM = 0

Tags

None found

FETCH_ASSOC

FETCH_ASSOC = 1

Tags

None found

Methods

get_query()

get_query() : string

Returns the executed query converted to dbms dialect

Returns

string —

the executed query converted to dbms dialect

Inherited from \QueryResult

Tags

None found

get_parameters()

get_parameters() : \mixed[string]

Returns the parameters injected in the query

Returns

\mixed[string] —

the parameters injected in the query

Inherited from \QueryResult

Tags

None found

set_fetch_mode()

set_fetch_mode( $fetch_mode)

Parameters

$fetch_mode

Inherited from \SelectQueryResult

Tags

None found

get_rows_count()

get_rows_count() : integer

returns the number of returned rows by this query

Returns

integer —

the number of returned rows by this query

Inherited from \SelectQueryResult

Tags

None found

has_next()

has_next()

Inherited from \SelectQueryResult

Tags

None found

fetch()

fetch()

Inherited from \SelectQueryResult

Tags

None found

dispose()

dispose()

free the resource. If not done manually, this is done in the destructor

Inherited from \SelectQueryResult

Tags

None found