Class Phalcon\Db\Builder\Select¶

Constants¶

string LEFT

string RIGHT

string INNER

Methods¶

public __construct (string|array $tables, [string $db])

Phalcon\Db\Builder\Select constructor

public Phalcon\Db\Builder\Select distinct (bool|null $distinct)

Sets SELECT DISTINCT / SELECT ALL flag

public Phalcon\Db\Builder\Select columns (string|array $columns)

Sets the columns to be queried

public Phalcon\Db\Builder\Select orderBy (string|array $orderBy)

Sets a ORDER BY condition clause

public Phalcon\Db\Builder\Select having (string $having)

Sets a HAVING condition clause. You need to escape PHQL reserved words using [ and ] delimiters

<?php

$builder->having('SUM(Robots.price) > 0');

public Phalcon\Db\Builder\Select limit (int $limit, [int $offset])

Sets a LIMIT clause, optionally a offset clause

public Phalcon\Db\Builder\Select offset (int $offset)

Sets an OFFSET clause

public Phalcon\Db\Builder\Select groupBy (string|array $group)

Sets a GROUP BY clause

protected Phalcon\Db\ResultInterface _execute ()

Returns a PHQL statement built based on the builder parameters

public Phalcon\Db\ResultInterface count ()

Returns a PHQL statement built based on the builder parameters

public Phalcon\Db\Builder\Join join (string $table, [string $conditions], [string $type]) inherited from Phalcon\Db\Builder\Join

Adds a join to the query

public Phalcon\Db\Builder\Join innerJoin (string $table, [string $conditions]) inherited from Phalcon\Db\Builder\Join

Adds a INNER join to the query

public Phalcon\Db\Builder\Join leftJoin (string $table, [string $conditions]) inherited from Phalcon\Db\Builder\Join

Adds a LEFT join to the query

public Phalcon\Db\Builder\Join rightJoin (string $table, [string $conditions]) inherited from Phalcon\Db\Builder\Join

Adds a RIGHT join to the query

public int setConditions (string|array $conditions, [array $bindParams], [array $bindTypes], [array $bindParams], [boolean $type]) inherited from Phalcon\Db\Builder\Where

Gets the type of PHQL queries

public string getConditions () inherited from Phalcon\Db\Builder\Where

Return the conditions

public Phalcon\Db\Builder where (string $conditions, [array $bindParams], [array $bindTypes]) inherited from Phalcon\Db\Builder\Where

Sets the query conditions

<?php

$builder->where('name = "Peter"');
$builder->where('name = :name AND id > :id', array('name' => 'Peter', 'id' => 100));

public Phalcon\Db\Builder andWhere (string $conditions, [array $bindParams], [array $bindTypes]) inherited from Phalcon\Db\Builder\Where

Appends a condition to the current conditions using a AND operator

<?php

$builder->andWhere('name = "Peter"');
$builder->andWhere('name = :name AND id > :id', array('name' => 'Peter', 'id' => 100));

public Phalcon\Db\Builder orWhere (string $conditions, [array $bindParams], [array $bindTypes]) inherited from Phalcon\Db\Builder\Where

Appends a condition to the current conditions using a OR operator

public Phalcon\Db\Builder inWhere (string $expr, array $values, [boolean $useOrWhere]) inherited from Phalcon\Db\Builder\Where

Appends an IN condition to the current conditions

public Phalcon\Db\Builder notInWhere (string $expr, array $values, [boolean $useOrWhere]) inherited from Phalcon\Db\Builder\Where

Appends a NOT IN condition to the current conditions

public static Phalcon\Db\Builder\Select select (unknown $tables, [unknown $db]) inherited from Phalcon\Db\Builder

Create a select builder

<?php

 $resultset = Phalcon\Db\Builder::select('robots')
      ->join('robots_parts', 'robots.id = robots_parts.robots_id')
      ->where('robots.id = 1')
      ->limit(20)
      ->orderBy('robots.name')
    ->execute();

public static Phalcon\Db\Builder\Update update (unknown $table, [unknown $db]) inherited from Phalcon\Db\Builder

Create a update builder

<?php

 $ret = Phalcon\Db\Builder::update('robots')
      ->set(['name' => 'test'])
      ->where('id = 1')
    ->execute();

public static Phalcon\Db\Builder\Insert insert (unknown $table, [unknown $db]) inherited from Phalcon\Db\Builder

Create a insert builder

<?php

 $ret = Phalcon\Db\Builder::insert('robots')
      ->values(['name' => 'test'])
    ->execute();

public static Phalcon\Db\Builder\Delete delete (unknown $table, [unknown $db]) inherited from Phalcon\Db\Builder

Create a delete builder

<?php

 $ret = Phalcon\Db\Builder::delete('robots')
      ->where('id = 1')
    ->execute();

public Phalcon\Db\Builder setBindParams (array $bindparams, [unknown $merge]) inherited from Phalcon\Db\Builder

Sets the bind parameters

public Phalcon\Db\Builder getBindParams () inherited from Phalcon\Db\Builder

Gets the bind parameters

public Phalcon\Db\Builder setBindTypes (array $bindtypes, [unknown $merge]) inherited from Phalcon\Db\Builder

Sets the bind types

public Phalcon\Db\Builder getBindTypes () inherited from Phalcon\Db\Builder

Gets the bind types

public Phalcon\Db\ResultInterface |boolean|array execute ([unknown $pretreatment]) inherited from Phalcon\Db\Builder

Execute query

public setDI (Phalcon\DiInterface $dependencyInjector) inherited from Phalcon\Di\Injectable

Sets the dependency injector

public Phalcon\DiInterface getDI ([unknown $error], [unknown $notUseDefault]) inherited from Phalcon\Di\Injectable

Returns the internal dependency injector

public setEventsManager (Phalcon\Events\ManagerInterface $eventsManager) inherited from Phalcon\Di\Injectable

Sets the event manager

public Phalcon\Events\ManagerInterface getEventsManager () inherited from Phalcon\Di\Injectable

Returns the internal event manager

public boolean fireEvent (string $eventName, [mixed $data], [unknown $cancelable]) inherited from Phalcon\Di\Injectable

Fires an event, implicitly calls behaviors and listeners in the events manager are notified

public mixed fireEventCancel (string $eventName, [mixed $data], [unknown $cancelable]) inherited from Phalcon\Di\Injectable

Fires an event, can stop the event by returning to the false

public boolean hasService (string $name) inherited from Phalcon\Di\Injectable

Check whether the DI contains a service by a name

public Phalcon\Di\ServiceInterface setService (unknown $name) inherited from Phalcon\Di\Injectable

Sets a service from the DI

public object|null getService (unknown $name) inherited from Phalcon\Di\Injectable

Obtains a service from the DI

public mixed getResolveService (string $name, [array $args], [unknown $noerror], [unknown $noshared]) inherited from Phalcon\Di\Injectable

Resolves the service based on its configuration

public attachEvent (string $eventType, Closure $callback) inherited from Phalcon\Di\Injectable

Attach a listener to the events

public __get (unknown $property) inherited from Phalcon\Di\Injectable

Magic method __get

public __sleep () inherited from Phalcon\Di\Injectable

...

public __debugInfo () inherited from Phalcon\Di\Injectable

...