Class Phalcon\Mvc\Model\Query\Builder\Insert¶

extends abstract class Phalcon\Mvc\Model\Query\Builder

implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface, Phalcon\Events\EventsAwareInterface

Source on GitHub

<?php

$resultset = Phalcon\Mvc\Model\Query\Builder::createInsertBuilder()
   ->table('Robots')
   ->columns(array('name'))
   ->values(array(array('name' => 'Google'), array('name' => 'Baidu')))
   ->getQuery()
   ->execute();

Methods¶

public __construct ([array $params])

Phalcon\Mvc\Model\Query\Builder\Insert constructor

public Phalcon\Mvc\Model\Query\Builder\Insert table (string $table)

Sets the table to insert into

public boolean getTable ()

Gets the table to insert into

public Phalcon\Mvc\Model\Query\Builder\Insert columns (array $columns)

Set the columns that will be inserted

public string|array getColumns ()

Gets the columns that will be inserted

public Phalcon\Mvc\Model\Query\Builder\Insert values (array $values)

Sets the values to insert

public array getValues ()

Gets the values to insert

public Phalcon\Mvc\Model\Query\Builder\Insert setConflict (array $conflict)

Sets conflict

protected string _compile ()

Returns a PHQL statement built based on the builder parameters

public static Phalcon\Mvc\Model\Query\Builder create (unknown $type) inherited from Phalcon\Mvc\Model\Query\Builder

Create a new Query Builder of the given type.

<?php

Phalcon\Mvc\Model\Query\Builder::create(Phalcon\Mvc\Model\Query::TYPE_SELECT);

public static Phalcon\Mvc\Model\Query\Builder\Select createSelectBuilder ([array $params], [Phalcon\DiInterface $dependencyInjector]) inherited from Phalcon\Mvc\Model\Query\Builder

Create a new Query Builder for Select

public static Phalcon\Mvc\Model\Query\Builder\Insert createInsertBuilder ([array $params], [Phalcon\DiInterface $dependencyInjector]) inherited from Phalcon\Mvc\Model\Query\Builder

Create a new Query Builder for Insert

public static Phalcon\Mvc\Model\Query\Builder\Update createUpdateBuilder ([array $params], [Phalcon\DiInterface $dependencyInjector]) inherited from Phalcon\Mvc\Model\Query\Builder

Create a new Query Builder for Update

public static Phalcon\Mvc\Model\Query\Builder\Delete createDeleteBuilder ([array $params], [Phalcon\DiInterface $dependencyInjector]) inherited from Phalcon\Mvc\Model\Query\Builder

Create a new Query Builder for Delete

public int getType () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the type of PHQL queries

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

Sets the bind parameters

public Phalcon\Mvc\Model\Query\Builder getBindParams () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the bind parameters

public Phalcon\Mvc\Model\Query\Builder getMergeBindParams () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the merge bind parameters

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

Sets the bind types

public Phalcon\Mvc\Model\Query\Builder getBindTypes () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the bind types

public Phalcon\Mvc\Model\Query\Builder getMergeBindTypes () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the merge bind types

public Phalcon\Mvc\Model\Query\Builder setIndex (string $index) inherited from Phalcon\Mvc\Model\Query\Builder

Adds the index

public string getIndex () inherited from Phalcon\Mvc\Model\Query\Builder

Gets the index

public Phalcon\Mvc\Model\Query\Builder compile () inherited from Phalcon\Mvc\Model\Query\Builder

Compile the PHQL query

public string getPhql () inherited from Phalcon\Mvc\Model\Query\Builder

Returns a PHQL statement built based on the builder parameters

public Phalcon\Mvc\Model\Query getQuery () inherited from Phalcon\Mvc\Model\Query\Builder

Returns the query built

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

...

Documentation

Class Phalcon\Mvc\Model\Query\Builder\Insert¶

Methods¶