gistfile1.txt

public function productSearchAction(Request $request)
    {
        $q = $request->query->get('q');
        $q = preg_split('/\s+/', $q);
        $dql = array();
        $em = $this->getDoctrine()->getManager();
        $search = $em->getRepository('DmitroShopBundle:Product');
        $qb = $search->createQueryBuilder('prod');
        foreach ($q as $i => $_q) {
            $dql[] = "prod.name LIKE :q$i";
            $qb->setParameter("q$i", '%' . $_q . '%');
        }
        $qb->andwhere('(' . implode(' OR ', $dql) . ')');
        $adapter = new DoctrineORMAdapter($qb, false);

        $pagerfanta = new Pagerfanta($adapter);
        $pagerfanta->setMaxPerPage(20);
        $pagerfanta->setCurrentPage($request->query->get('page', 1));

        if (!$pagerfanta->getNbResults()) {
            throw $this->createNotFoundException('Ci dispiace, ma il prodotto non è stato trovato'. implode(" ", $q));
        }
        return $this->render(
            'product/listProduct.html.twig',
            array('productsPagerfanta' => $pagerfanta)
        );
    }