public function getPostsSearchPager(array $criteria, $page, $limit = 10, array $sort = array()) { $parameters = array(); $em = $this->postManager->getEntityManager(); $query = $em->createQueryBuilder()->select('p')->from('AppBundle:News\\Post', 'p')->orderBy('p.publicationDateStart', 'DESC'); if ($criteria['search']) { $query->andWhere('p.title LIKE :search'); $parameters['search'] = (string) '%' . $criteria['search'] . '%'; } /* d($parameters); */ $query->setParameters($parameters); /*dd($query->getQuery()->getResult());*/ /* d($query->getResult()); */ $pager = new Pager(); $pager->setMaxPerPage($limit); $pager->setQuery(new ProxyQuery($query)); $pager->setPage($page); /*dd($criteria);*/ $pager->init(); return $pager; }