onPHP

SelectQuery Class Reference

home about examples API documentation download forum contacts
 

SelectQuery Class Reference
[Dynamic query builder]

Inheritance diagram for SelectQuery:

Inheritance graph
[legend]
List of all members.

Public Member Functions

 getName ()
 setName ($name)
 distinct ()
 isDistinct ()
 unDistinct ()
 joinQuery (SelectQuery $query, LogicalObject $logic, $alias)
 join ($table, LogicalObject $logic, $alias=null)
 leftJoin ($table, LogicalObject $logic, $alias=null)
 orderBy ($field, $table=null)
 prependOrderBy ($field, $table=null)
 desc ()
 asc ()
 groupBy ($field, $table=null)
 getLimit ()
 getOffset ()
 limit ($limit=null, $offset=null)
 from ($table, $alias=null)
 get ($field, $alias=null)
 multiGet ()
 arrayGet ($array, $prefix=null)
 getFieldsCount ()
 getFieldNames ()
 toDialectString (Dialect $dialect)
 dropFields ()
 dropOrder ()

Private Member Functions

 getLastTable ($table=null)

Private Attributes

 $distinct = false
 $name = null
 $limit = null
 $offset = null
 $fields = array()
 $from = array()
 $currentOrder = null
 $order = array()
 $group = array()

Detailed Description

Definition at line 27 of file SelectQuery.class.php.

Member Function Documentation

SelectQuery::getName (  ) 

Implements Named.

Definition at line 44 of file SelectQuery.class.php.

Referenced by arrayGet(), and toDialectString().

SelectQuery::setName ( $  name  ) 

Implements Named.

Definition at line 49 of file SelectQuery.class.php.

References $name.

SelectQuery::distinct (  ) 

Definition at line 56 of file SelectQuery.class.php.

Referenced by isDistinct(), and unDistinct().

SelectQuery::isDistinct (  ) 

Definition at line 62 of file SelectQuery.class.php.

References distinct().

Here is the call graph for this function:

SelectQuery::unDistinct (  ) 

Definition at line 67 of file SelectQuery.class.php.

References distinct().

Here is the call graph for this function:

SelectQuery::joinQuery ( SelectQuery $  query,
LogicalObject $  logic,
$  alias 
)

Deprecated:
by join()

Definition at line 74 of file SelectQuery.class.php.

References from().

Here is the call graph for this function:

SelectQuery::join ( $  table,
LogicalObject $  logic,
$  alias = null 
)

Definition at line 80 of file SelectQuery.class.php.

References from().

Here is the call graph for this function:

SelectQuery::leftJoin ( $  table,
LogicalObject $  logic,
$  alias = null 
)

Definition at line 86 of file SelectQuery.class.php.

References from().

Here is the call graph for this function:

SelectQuery::orderBy ( $  field,
$  table = null 
)

Definition at line 92 of file SelectQuery.class.php.

References $order, and getLastTable().

Here is the call graph for this function:

SelectQuery::prependOrderBy ( $  field,
$  table = null 
)

Definition at line 108 of file SelectQuery.class.php.

References $order, and getLastTable().

Here is the call graph for this function:

SelectQuery::desc (  ) 

Definition at line 128 of file SelectQuery.class.php.

SelectQuery::asc (  ) 

Definition at line 138 of file SelectQuery.class.php.

SelectQuery::groupBy ( $  field,
$  table = null 
)

Definition at line 148 of file SelectQuery.class.php.

References getLastTable().

Here is the call graph for this function:

SelectQuery::getLimit (  ) 

Definition at line 159 of file SelectQuery.class.php.

References limit().

Here is the call graph for this function:

SelectQuery::getOffset (  ) 

Definition at line 164 of file SelectQuery.class.php.

SelectQuery::limit ( $  limit = null,
$  offset = null 
)

Definition at line 169 of file SelectQuery.class.php.

References $limit, $offset, and Assert::isInteger().

Referenced by getLimit(), and toDialectString().

Here is the call graph for this function:

SelectQuery::from ( $  table,
$  alias = null 
)

Definition at line 183 of file SelectQuery.class.php.

Referenced by getLastTable(), join(), joinQuery(), leftJoin(), and toDialectString().

SelectQuery::get ( $  field,
$  alias = null 
)

Definition at line 191 of file SelectQuery.class.php.

References getLastTable().

Referenced by arrayGet(), multiGet(), and toDialectString().

Here is the call graph for this function:

SelectQuery::multiGet (  ) 

Definition at line 230 of file SelectQuery.class.php.

References get().

Here is the call graph for this function:

SelectQuery::arrayGet ( $  array,
$  prefix = null 
)

Definition at line 241 of file SelectQuery.class.php.

References get(), and getName().

Here is the call graph for this function:

SelectQuery::getFieldsCount (  ) 

Definition at line 267 of file SelectQuery.class.php.

SelectQuery::getFieldNames (  ) 

Definition at line 272 of file SelectQuery.class.php.

SelectQuery::toDialectString ( Dialect $  dialect  ) 

Reimplemented from QuerySkeleton.

Definition at line 282 of file SelectQuery.class.php.

References $group, $order, from(), get(), getName(), Assert::isTrue(), limit(), and Dialect::quoteField().

Here is the call graph for this function:

SelectQuery::dropFields (  ) 

Definition at line 356 of file SelectQuery.class.php.

SelectQuery::dropOrder (  ) 

Definition at line 362 of file SelectQuery.class.php.

SelectQuery::getLastTable ( $  table = null  )  [private]

Definition at line 368 of file SelectQuery.class.php.

References from().

Referenced by get(), groupBy(), orderBy(), and prependOrderBy().

Here is the call graph for this function:

Member Data Documentation

SelectQuery::$distinct = false [private]

Definition at line 29 of file SelectQuery.class.php.

SelectQuery::$name = null [private]

Definition at line 31 of file SelectQuery.class.php.

Referenced by setName().

SelectQuery::$limit = null [private]

Definition at line 33 of file SelectQuery.class.php.

Referenced by limit().

SelectQuery::$offset = null [private]

Definition at line 34 of file SelectQuery.class.php.

Referenced by limit().

SelectQuery::$fields = array() [private]

Definition at line 36 of file SelectQuery.class.php.

SelectQuery::$from = array() [private]

Definition at line 37 of file SelectQuery.class.php.

SelectQuery::$currentOrder = null [private]

Definition at line 39 of file SelectQuery.class.php.

SelectQuery::$order = array() [private]

Definition at line 40 of file SelectQuery.class.php.

Referenced by orderBy(), prependOrderBy(), and toDialectString().

SelectQuery::$group = array() [private]

Definition at line 42 of file SelectQuery.class.php.

Referenced by toDialectString().

The documentation for this class was generated from the following file:

generated by doxygen-1.5.1
for onPHP at Mon Jan 8 11:44:02 2007