PHP Doctrine2 search "Like" with an Array "%$array%"

Question

Doctrine2.5 With PHP 5.6

I have an array of things to search, example: in a table of user, i want to search for the names of everyone that have the name "Reis" or "Shimidt" in the field name. With the array

$arraySearch = ['Reis', 'Shimidt'];

I want to bring for example the following entries,

John Reis Carlson,
Mary Shimidt Lincoln,
Bill Reis Abdonor Gates.

I tried something like this:

$this->query->andWhere(" pb.name LIKE '%:name%' ");
$this->query->setParameter('name', $name, \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY);

It doesnt work, i also tried like this, but obviously returned array to string conversion:

$this->query->setParameter('name', '%'.$name.'%', \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY);

Any ideas how to solution this, without to do a messy code ?

Albert Abdonor · Accepted Answer · 2017-07-25 08:59:30Z

1

I advise you to use something like this:

foreach ($arraySearch as $search) {
    $this->query->orWhere(" pb.name LIKE :search ");
    $this->query->setParameter("search", '%'.$search.'%');
}

edited Jul 25, 2017 at 8:59

Albert Abdonor

9579 silver badges16 bronze badges

answered Jul 25, 2017 at 7:56

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alessandro Minoccheri Over a year ago

Glad to help you! Accept the answer to help other persons with your same problem @AlbertAbdonor

Adri · Accepted Answer · 2017-07-25 08:28:09Z

0

Try this :

$this->query->setParameter('name', implode("%', OR name LIKE '%", $arraySearch));

edited Jul 25, 2017 at 8:28

answered Jul 25, 2017 at 7:56

Adri

3954 silver badges20 bronze badges

1 Comment

Adri Over a year ago

Edited, sorry about that

Collectives™ on Stack Overflow

PHP Doctrine2 search "Like" with an Array "%$array%"

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related