1. Home
2. php - Symfony - how to use an array as an parameter by using a querybuilder?

779 votes

1 answers

php - Symfony - how to use an array as an parameter by using a querybuilder?

Get the solution ↓↓↓

Solution:

I think you want to use "IN" syntax, not "=" syntax:

'SELECT w
    FROM WaiverBundle:Waiver w
    WHERE w.carrier IN (:carrier)
    AND w.market = :market
    ORDER BY w.id DESC'
Copy code

Undefined asked

2023-01-28

Write your answer

---

393

votes

Answer

Solution:

Your query is not complicated. I think you should consider QueryBuilder instead of DQL in this case. Something like this would do the trick:

    $qb = $em->createQueryBuilder();
    $qb->select('w')
        ->from('WaiverBundle:Waiver', 'w')
        ->where($qb->expr()->in('w.carrier', ':carrier'))
        ->andWhere($qb->expr()->eq('w.market', ':market'))
        ->orderBy('w.id', 'DESC')
        ->setParameters(
            array(
                'carrier'=>$user_airlines[0],
                'market'=>$user_markets[0)
        );
Copy code

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2023-01-28

Link To Source
Link To Answer People are also looking for solutions of the problem: foreach() argument must be of type array|object, null given

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

294 php - I cannot login using password_hash

135 php - Unrecognized field: user_name, while querying Via Doctrine using ZF2

118 php - Use different different shipping prices based on cart subtotal in Woocommerce

251 php - Passing second user model data to a controller in Laravel

829 php - How to return value from stored procedure using PDO on MSSQL database

856 php - Insert file into mysql database as varbinary datatype

111 php - How to effectively delete a user as an admin

227 php - Use of undefined constant message - assumed 'message'

149 php - i have same column name of first_name in database and have different user_type how to separated show in the two different column of site

502 php json array data in javascript

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Symfony

Symfony compares favorably with other PHP frameworks in terms of reliability and maturity. This framework appeared a long time ago, in 2005, that is, it has existed much longer than most of the other tools we are considering. It is popular for its web standards compliance and PHP design patterns.
https://symfony.com/