QueryBuilder query array values

Question

I have a query to get a username from the entity with date:

return $this->createQueryBuilder('t')
    ->select('t.username')
    ->where('t.date = :date')
    ->andWhere('t.username = :username')
    ->setParameter('date', $date)
    ->setParameter('username', $username)
    ->getQuery()
;

However, when I want to find a username in the array, I use this:

if (in_array($user_array, $username) != true) {

I get this $username array:

array(1) {
  [0] =>
  array(1) {
    'username' =>
    string(9) "username1"
  }
}
array(1) {
  [0] =>
  array(1) {
    'username' =>
    string(10) "username90"
  }
}
array(1) {
  [0] =>
  array(1) {
    'username' =>
    string(10) "username12"
  }
}

Is it even possible to search if the username is within the array? Do I need to adjust my QueryBuilder code or do I need to resort to another solution in Symfony?

Adjust your QueryBuilder is cleaner

6be709c0
– 6be709c0

2015-08-03 09:37:30 +00:00
Commented Aug 3, 2015 at 9:37 — 6be709c0
– 6be709c0, Commented Aug 3, 2015 at 9:37

Matteo · Accepted Answer · 2015-08-03 09:41:17Z

6

you can use the in function. As Example:

    public function getUser($arrays, $date)
    {
 $qb = $this->createQueryBuilder('t');
return $qb
    ->select('t.username')
    ->where('t.date = :date')
    ->andWhere($qb->expr()->in('t.username', $arrays) )
    ->setParameter('date', $date)
    ->getQuery()
;
}

More info here

Hope this help

answered Aug 3, 2015 at 9:41

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

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

2 Comments

user4793675 Over a year ago

That is a good best practice. I now check if the username is not in the array in the function. Thank you for the referenced document.

Matteo Over a year ago

Hi @Ricardo you are welcome! Of course, exist the expression $qb->expr()->notIn

Collectives™ on Stack Overflow

QueryBuilder query array values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related