• 홈
• Pagekit
• Database
• Query
• QueryBuilder

PHP 클래스 Pagekit\Database\Query\QueryBuilder

파일 보기 프로젝트 열기: pagekit/pagekit 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$connection	Pagekit\Database\Connection	The Connection.
$params	array	The query parameters.
$parts	array	The query parts.

공개 메소드들

메소드	설명
__construct ( Pagekit\Database\Connection $connection )	Constructor.
__toString ( )	{@see QueryBuilder::getSQL}
addPart ( string $name, mixed $parts ) : self	Adds a query part.
aggregate ( string $function, string $column ) : mixed	Execute the query with an aggregate function.
avg ( string $column ) : mixed	Execute the query and get the "avg" result.
count ( string $column = '*' ) : integer	Execute the query and get the "count" result.
delete ( ) : integer	Execute the "delete" query.
execute ( mixed $columns = ['*'] ) : Doctrine\DBAL\Driver\Statement	Execute the "select" query.
first ( mixed $columns = ['*'] ) : mixed	Execute the query and get the first result.
from ( string $table ) : self	Creates and sets a "from" to the query.
get ( mixed $columns = ['*'] ) : array	Execute the query and get all results.
getConnection ( ) : Pagekit\Database\Connection	Gets the connection for the query builder.
getPart ( string $name ) : mixed	Gets a query part by its name.
getParts ( ) : array	Gets all query parts.
getSQL ( ) : string	Gets the query SQL.
groupBy ( mixed $groupBy ) : self	Creates and adds a "group by" to the query.
having ( mixed $having, string $type = CompositeExpression::TYPE_AND ) : self	Creates and adds a "having" to the query.
innerJoin ( string $table, string $condition = null ) : self	Creates and adds an "inner join" to the query.
join ( string $table, string $condition = null, string $type = 'inner' ) : self	Creates and adds a "join" to the query.
leftJoin ( string $table, string $condition = null ) : self	Creates and adds a "left join" to the query.
limit ( integer $limit ) : self	Sets the limit of the query.
max ( string $column ) : mixed	Execute the query and get the "max" result.
min ( string $column ) : mixed	Execute the query and get the "min" result.
offset ( integer $offset ) : self	Sets the offset of the query.
orHaving ( mixed $having ) : self	Creates and adds a "or having" to the query.
orWhere ( mixed $condition, array $params = [] ) : self	Creates and adds a "or where" to the query.
orWhereExists ( Closure $callback, boolean $not = false ) : self	Creates and adds a "or where exists" to the query.
orWhereIn ( string $column, mixed $values, boolean $not = false ) : self	Creates and adds a "or where in" to the query.
orderBy ( string $sort, string $order = null ) : self	Creates and adds an "order by" to the query.
params ( array $params = null ) : array | self	Get or set multiple query parameters.
rightJoin ( string $table, string $condition = null ) : self	Creates and adds a "right join" to the query.
select ( mixed $columns = ['*'] ) : self	Creates and adds a "select" to the query.
setPart ( string $name, mixed $parts ) : self	Sets a query part and replaces all previous values.
sum ( string $column ) : mixed	Execute the query and get the "sum" result.
update ( array $values ) : integer	Execute the "update" query with the given values.
where ( mixed $condition, array $params = [] ) : self	Creates and adds a "where" to the query.
whereExists ( Closure $callback, boolean $not = false, string $type = null ) : self	Creates and adds a "where exists" to the query.
whereIn ( string $column, mixed $values, boolean $not = false, string $type = null ) : self	Creates and adds a "where in" to the query.
whereInSet ( string $column, mixed $values, boolean $not = false, string $type = null ) : self	Creates and adds a "where FIND_IN_SET" equivalent to the query.

보호된 메소드들

메소드	설명
addWhere ( mixed $condition, array $params, string $type = null ) : self	Creates and adds a "where" to the query.
executeQuery ( string $type = 'select' ) : mixed	Execute the query as select, update or delete.
getSQLForDelete ( ) : string	Creates the "delete" SQL string from the query parts.
getSQLForSelect ( ) : string	Creates the "select" SQL string from the query parts.
getSQLForUpdate ( ) : string	Creates the "update" SQL string from the query parts.
guessParamTypes ( array $params = [] ) : array	Tries to guess param types
newQuery ( ) : QueryBuilder	Creates a new query builder.
parameter ( $name )

메소드 상세

프로퍼티 상세