Doctrine ORM : Undefined offset 2

Question

I'm working on a request to pick up some result from the database but I have an error and I don't know how to resove it

in my repository :

public function findBySearchField($salary, $contract, $experience, $training)
{
    return $this->createQueryBuilder('a')
        ->andWhere('a.salary = :sal')
            ->setParameter('sal', $salary)
        ->andWhere('a.contract = :con')
            ->setParameter('con', $contract)
        ->andWhere('a.experience = :exp')
            ->setParameter('exp', $experience)
        ->andWhere('a.training = :tra')
            ->setParameter('tra', $training)
        ->orderBy('a.postedAt', 'DESC')
        ->getQuery()
        ->getResult()
        ;
}

in my controller :

public function index(Request $request, AdvertRepository $advertRepository): Response
{
    $form = $this->createForm(ResearchType::class);
    $form->handleRequest($request);

    if ($request->getMethod() == 'POST') {
        $salary = $form->get('salary')->getData();
        $contract = $form->get('contract')->getData();
        $experience = $form->get('experience')->getData();
        $training = $form->get('training')->getData();

        return $this->render('advert/index.html.twig', [
            'form' => $form->createView(),
            'adverts' => $advertRepository->findBySearchField(
                ['salary' => $salary],
                ['contract' => $contract],
                ['experience' => $experience],
                ['training' => $training]
            ),
        ]);
    }

    return $this->render('advert/index.html.twig', [
        'form' => $form->createView(),
        'adverts' => $advertRepository->findAll(),
    ]);
}

I have an error "Notice: Undefined offset: 2"

However when I make this request in phpMyAdmin it returns what I am looking for

Hi Romain, I don't see any issue with the queries, how about your View files — ecarrizo, Mar 28 '19 at 17:24
_"Notice: Undefined offset: 2"_ What FILE and what LINE? Show that line. — AbraCadaver, Mar 28 '19 at 17:33

score 0 · Answer 1 · answered Mar 29 '19 at 16:53

thank you for your feedback, I found the solution, in my method findBySearchField I gave arrays instead of giving variables. This solution works :

    public function index(Request $request, AdvertRepository $advertRepository): Response
    {
        $form = $this->createForm(ResearchType::class);
        $form->handleRequest($request);

        if ($request->getMethod() == 'POST') {
            return $this->render('advert/index.html.twig', [
                'form' => $form->createView(),
                'adverts' => $advertRepository->findBySearchField(
                    $salary     = $form->get('salary')->getData(),
                    $contract   = $form->get('contract')->getData(),
                    $experience = $form->get('experience')->getData(),
                    $training   = $form->get('training')->getData()
                ),
            ]);
        }

        return $this->render('advert/index.html.twig', [
            'form' => $form->createView(),
            'adverts' => $advertRepository->findAll(),
        ]);
    }

Doctrine ORM : Undefined offset 2

1 Answers1