Guest User

Untitled

a guest
Dec 15th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. /**
  2. * Find/Show an Especie entity.
  3. *
  4. * @Route("/search", name="individuos_showby")
  5. * @Method("post")
  6. *
  7. */
  8.  
  9. public function searchAction($query)
  10. {
  11. $pattern = '%' . str_replace(' ', '%', $query) . '%';
  12.  
  13. $qb = $this->createQueryBuilder('e')->orderBy('e.nombrecomun', 'DESC');
  14. $qb->where($qb->expr()->orx(
  15. $qb->expr()->like('e.nombrecomun', ':comun'),
  16. $qb->expr()->like('e.nombrecientifico', ':cientifico')
  17.  
  18. ));
  19. $qb->setParameters(array('comun' => $pattern, 'cientifico' => $pattern));
  20. return $qb->getQuery()->execute();
  21. }
Add Comment
Please, Sign In to add comment