Model::find() return all object

Question

Model::find() return all object

Bruno Gastadi Jan '19

Created Jan '19	Last Reply Feb '19	Replies 2	Views 429	Votes 0

Bruno Gastadi 1.1k

Jan '19

When I run SQL all the objects of the db are returned

Phalcon\Mvc\Model\Resultset\Simple Object ( [_result:protected] => Phalcon\Db\Result\Pdo Object ( [_connection:protected] => Phalcon\Db\Adapter\Pdo\Mysql Object ( [_eventsManager:protected] => [_descriptor:protected] => Array ( [host] => 127.0.01 [username] => user [password] => xxxxx [dbname] => db [charset] => utf8 ) [_dialect:protected] => Phalcon\Db\Dialect\Mysql Object ( [_customFunctions:protected] => [_escapeChar:protected] =>  ) [_connectionId:protected] => 0 [_sqlStatement:protected] => [_sqlVariables:protected] => [_sqlBindTypes:protected] => [_transactionLevel:protected] => 0 [_transactionsWithSavepoints:protected] => [_pdo:protected] => PDO Object ( ) [_affectedRows:protected] => [_type:protected] => mysql [_dialectType:protected] => mysql ) [_result:protected] => [_fetchMode:protected] => 2 [_pdoStatement:protected] => PDOStatement Object ( [queryString] => SELECT user.usr_id, user.usr_nome FROM user ) [_sqlStatement:protected] => SELECT

Dylan Anderson · Answer 1 · 2019-01-31T16:48:06-07:00

Dylan Anderson
125.7k

Jan '19

......what? Some more details and more readable code would be helpful.

Andreas Aagaard · Answer 2 · 2019-02-08T15:16:24-07:00

When asking a question please provide script to reproduce and description of what you're trying to achieve...

Seems like you need some pagination... This can be done via limit and offset $parameter in Model::find/findFirst() method OR via paginator https://docs.phalcon.io/3.4/en/db-pagination