Class Phalcon\Paginator\Adapter\Sql¶

<?php

 $sql = "SELECT * FROM robots WHERE type = :type LIMIT :limit OFFSET :offset";
 $sql2 = "SELECT COUNT(*) rowcount FROM robots WHERE type = :type FROM robots";

 $bind = ['type' => 'google'];

 $paginator = new \Phalcon\Paginator\Adapter\Sql(array(
                 "db" => $this->db,
                 "sql" => $sql,
                 "total_sql" => $sql2,
                 "bind" => $bind,
                 //"total_bind" => $total_bind,
                 "limit" => 20,
                 "page" => $page
 ));

Methods¶

public __construct (array $config)

public stdClass getPaginate ()

Returns a slice of the resultset to show in the pagination

public Phalcon\Paginator\Adapter\Sql $this Fluent interface setDb (Phalcon\Db\AdapterInterface $db)

Set query builder object

public Phalcon\Db\AdapterInterface $db getDb ()

Get query builder object

public setCurrentPage (int $page) inherited from Phalcon\Paginator\Adapter

Set current page number

public getCurrentPage () inherited from Phalcon\Paginator\Adapter

Get current page number

public Phalcon\Paginator\Adapter setLimit (int $limit) inherited from Phalcon\Paginator\Adapter

Set current rows limit

public int $limit getLimit () inherited from Phalcon\Paginator\Adapter

Get current rows limit

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

...