• Главная
• PdoDataSet

PHP Класс PdoDataSet, recess

Example usage: $results = new PdoDataSet(Databases::getDefault()); $results->from('tableName')->equal('someColumn', 'Hi')->limit(10)->offset(50); foreach($results as $result) { // This is when the query is run! print_r($result); } Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
$rowClass		The Class which PDO will fetch rows into.

Защищенные свойства (Protected)

Свойство	Тип	Описание
$hasResults	boolean	Whether this instance has fetched results or not.
$index	integer	Index counter for our location in the result set.
$results		Array of results that is filled once a query is realized.
$source	PdoDataSource	The PdoDataSource which this PdoDataSet is extracted from.
$sqlBuilder	SqlBuilder	The SqlBuilder instance we use to build up the query string.

Открытые методы

Метод	Описание
__clone ( )
__construct ( PdoDataSource $source )
assign ( $column, $value ) : PdoDataSet
between ( $column, $lhs, $rhs ) : PdoDataSet
count ( )
current ( )
distinct ( ) : PdoDataSet
equal ( $lhs, $rhs ) : PdoDataSet
exists ( )
first ( ) : object	Return the first item in the PdoDataSet or Null if none exist
from ( $table ) : PdoDataSet
greaterThan ( $lhs, $rhs ) : PdoDataSet
greaterThanOrEqualTo ( $lhs, $rhs ) : PdoDataSet
groupBy ( $clause ) : PdoDataSet
in ( $lhs, $rhs ) : PdoDataSet
innerJoin ( $table, $tablePrimaryKey, $fromTableForeignKey ) : PdoDataSet
isEmpty ( )
isNotNull ( $lhs ) : PdoDataSet
isNull ( $lhs ) : PdoDataSet
key ( )
leftOuterJoin ( $table, $tablePrimaryKey, $fromTableForeignKey ) : PdoDataSet
lessThan ( $lhs, $rhs ) : PdoDataSet
lessThanOrEqualTo ( $lhs, $rhs ) : PdoDataSet
like ( $lhs, $rhs ) : PdoDataSet
limit ( $size ) : PdoDataSet
next ( )
notEqual ( $lhs, $rhs ) : PdoDataSet
notLike ( $lhs, $rhs ) : PdoDataSet
offset ( $offset ) : PdoDataSet
offsetExists ( $index )	* The following methods are in accordance with the ArrayAccess interface
offsetGet ( $index )
offsetSet ( $index, $value )
offsetUnset ( $index )
orderBy ( $clause ) : PdoDataSet
range ( $start, $finish ) : PdoDataSet
rewind ( )	* The following methods are in accordance with the Iterator interface
selectAs ( $select, $as ) : PdoDataSet
toArray ( ) : array	Return the results as an array.
toSql ( ) : string	Return the SQL representation of this PdoDataSet
useAssignmentsAsConditions ( $bool ) : PdoDataSet
valid ( )
where ( $lhs, $rhs, $operator ) : PdoDataSet

Защищенные методы

Метод	Описание
realize ( )	Once results are needed this method executes the accumulated query on the data source.
reset ( )

Описание методов

Описание свойств