work with criteria

Question

work with criteria

Farkhod Jun '13

Created Jun '13	Last Reply Oct '13	Replies 2	Views 1592	Votes 1

Farkhod 42.1k

Jun '13

Hello all!!!

$query = Criteria::fromInput($this->di, 'Models\SomeModel', $this->request->getPost()); how to add an additional condition. for example $auth = $this->auth->get('auth-identity'); $additionalCondition = 'user_id = ' . $auth['user_id'];

and whether you can use a placeholder???

1

Phalcon · Answer 1 · 2013-06-19T10:40:49-07:00

You can create a query builder based on the parameters processed by Phalcon\Mvc\Model\Criteria:

$auth = $this->auth->get('auth-identity');

$criteria = Criteria::fromInput($this->di, 'Models\SomeModel', $this->request->getPost());

$result = $this->modelsManager
                    ->createBuilder($criteria->getParams())
                    ->andWhere('user_id = :user_id:', ['user_id' => $auth['user_id']]);
                    ->getQuery()
                    ->execute();

Farkhod · Answer 2 · 2013-06-19T10:56:13-07:00

Farkhod
42.1k

Jun '13

Thanks

mywebcontent · Answer 3 · 2013-10-02T14:08:41-07:00

Hello

I have the same issue, and I have the following code

        $criteria = Criteria::fromInput($this->di,'Categories', $this->request->getPost());
        $result = $this->modelsManager
        ->createBuilder($criteria->getParams())
        ->andWhere('languagekey = :languagekey:', ['languagekey' => 'en'])
        ->getQuery()
        ->execute();

Categories is my model (without namespaces), but executing this piece of code into my program It shows an empty screen with the following message:

At least one model is required to build the query

Do i forgot something?

Running code like this:

            $query = Criteria::fromInput($this->di, "Categories", $criteria);
            $extra = $this->modelsManager->createBuilder($query->getParams());
            $this->persistent->searchParams = $query->getParams();

works normal.