extends abstract class Phalcon\Db\Builder
implements Phalcon\Db\BuilderInterface, Phalcon\Di\InjectionAwareInterface, Phalcon\Events\EventsAwareInterface
public __construct ([string $table], [string $db])
Phalcon\Db\Builder\Insert constructor
public Phalcon\Db\Builder\Insert values (array $values)
Sets the values to insert
protected string _execute ()
Returns a PHQL statement built based on the builder parameters
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
...