src/DB/PDO/TableReader.php
public function find( $columns = array(), $conditions = array(), $orders = array(), $limits = array(), $groupings = array(), $havings = array() ){
		$this->validateColumns( $columns );
		$conditions	= $this->getConditionQuery( $conditions, FALSE, FALSE, TRUE );					//  render WHERE clause if needed, uncursored, allow functions
		$conditions = $conditions ? ' WHERE '.$conditions : '';
		$orders		= $this->getOrderCondition( $orders );											//  render ORDER BY clause if needed
		$limits		= $this->getLimitCondition( $limits );											//  render LIMIT BY clause if needed
		$groupings	= !empty( $groupings ) ? ' GROUP BY '.join( ', ', $groupings ) : '';			//  render GROUP BY clause if needed
		$havings 	= !empty( $havings ) ? ' HAVING '.join( ' AND ', $havings ) : '';				//  render HAVING clause if needed
		$columns	= $this->getColumnEnumeration( $columns );										//  get enumeration of masked column names
		$query		= 'SELECT '.$columns.' FROM '.$this->getTableName();							//  render base query

		$query		= $query.$conditions.$groupings.$havings.$orders.$limits;						//  append rendered conditions, orders, limits, groupings and havings
		$resultSet	= $this->dbc->query( $query );
		if( $resultSet )
			return $resultSet->fetchAll( $this->getFetchMode() );
		return array();
	}
public function find( $columns = array(), $conditions = array(), $orders = array(), $limits = array(), $groupings = array(), $havings = array() ){
		$this->validateColumns( $columns );
		$conditions	= $this->getConditionQuery( $conditions, FALSE, FALSE, TRUE );					//  render WHERE clause if needed, uncursored, allow functions
		$conditions = $conditions ? ' WHERE '.$conditions : '';
		$orders		= $this->getOrderCondition( $orders );											//  render ORDER BY clause if needed
		$limits		= $this->getLimitCondition( $limits );											//  render LIMIT BY clause if needed
		$groupings	= !empty( $groupings ) ? ' GROUP BY '.join( ', ', $groupings ) : '';			//  render GROUP BY clause if needed
		$havings 	= !empty( $havings ) ? ' HAVING '.join( ' AND ', $havings ) : '';				//  render HAVING clause if needed
		$columns	= $this->getColumnEnumeration( $columns );										//  get enumeration of masked column names
		$query		= 'SELECT '.$columns.' FROM '.$this->getTableName();							//  render base query

		$query		= $query.$conditions.$groupings.$havings.$orders.$limits;						//  append rendered conditions, orders, limits, groupings and havings
		$resultSet	= $this->dbc->query( $query );
		if( $resultSet )
			return $resultSet->fetchAll( $this->getFetchMode() );
		return array();
	}
public function find ( $ columns = array ( ) , $ conditions = array ( ) , $ orders = array ( ) , $ limits = array ( ) , $ groupings = array ( ) , $ havings = array ( ) ) { $ this -> validateColumns ( $ columns ) ; $ conditions = $ this -> getConditionQuery ( $ conditions , FALSE , FALSE , TRUE ) ; //  render WHERE clause if needed, uncursored, allow functions $ conditions = $ conditions ? ' WHERE ' . $ conditions : '' ; $ orders = $ this -> getOrderCondition ( $ orders ) ; //  render ORDER BY clause if needed $ limits = $ this -> getLimitCondition ( $ limits ) ; //  render LIMIT BY clause if needed $ groupings = ! empty ( $ groupings ) ? ' GROUP BY ' . join ( ', ' , $ groupings ) : '' ; //  render GROUP BY clause if needed $ havings = ! empty ( $ havings ) ? ' HAVING ' . join ( ' AND ' , $ havings ) : '' ; //  render HAVING clause if needed $ columns = $ this -> getColumnEnumeration ( $ columns ) ; //  get enumeration of masked column names $ query = 'SELECT ' . $ columns . ' FROM ' . $ this -> getTableName ( ) ; //  render base query $ query = $ query . $ conditions . $ groupings . $ havings . $ orders . $ limits ; //  append rendered conditions, orders, limits, groupings and havings $ resultSet = $ this -> dbc -> query ( $ query ) ; if ( $ resultSet ) return $ resultSet -> fetchAll ( $ this -> getFetchMode ( ) ) ; return array ( ) ; }
Returns all entries of this table in an array.
@access		public
@param		array		$columns		List of columns to deliver
@param		array		$conditions		Map of condition pairs additional to focuses indices
@param		array		$orders			Map of order relations
@param		array		$limits			Array of limit conditions
@param		array		$groupings		List of columns to group by
@param		array		$havings		List of conditions to apply after grouping
@return		array		List of fetched table rows
Returns all entries of this table in an array .