Abstract class Phalcon\Db\Builder¶

Methods¶

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

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])

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])

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])

Create a delete builder

<?php

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

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

Sets the bind parameters

public Phalcon\Db\Builder getBindParams ()

Gets the bind parameters

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

Sets the bind types

public Phalcon\Db\Builder getBindTypes ()

Gets the bind types

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

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

...