CODEWITHSUNDEEP
phpmysqlarraysconditional-statementsclause
Musayyab Naveed
Musayyab Naveed

Reputation: 35

Dynamically creating OR conditions by passing an array to a query in MySQL PHP

I am trying to create OR condition dynamically using an array. Given an array, of course names $courses = array('Eng, 'Deu', 'Bio', 'Chemi') I want to have a SQL query that uses the values of the array in its AND clause with OR conditions like:

    SELECT *
        FROM classe
        /* The OR conditions should be created in AND clause using array */
        WHERE class = 'EFG' AND (course = 'Eng' OR course = 'Deu' OR course = 'Bio')

I trying to do it in PHP MySQL.

Any help would be really appreciated.

Thanks in Advance.

Upvotes: 1

Views: 904

Answers (2)

user3783243
user3783243

Reputation: 5224

The IN clause will be easier to use than ORs. If you are using PDO you can take advantage of its execute binding and build the placeholders dynamically then just pass your array to it.

$courses = array('Eng', 'Deu', 'Bio', 'Chemi');
$placeholders = rtrim(str_repeat('?, ', count($courses)), ', ');
$query = "select * from table WHERE class = 'EFG' AND course in ({$placeholders})";
$stmt = $pdo->prepare($query);
$stmt->execute($courses);

Demo: https://3v4l.org/jcFSv (PDO bit non functional)

Upvotes: 1

Madhur Bhaiya
Madhur Bhaiya

Reputation: 28834

Instead of so many OR clauses, you can simply use IN(..):

SELECT *
FROM classe
WHERE class = 'EFG' AND course IN ('Eng' ,'Deu', 'Bio')

In the PHP code, you can use implode() function to convert the array into a comma separated string, and use it in the query string generation.

Upvotes: 2

Related Questions