通过将数组传递给MySQL PHP中的查询来动态创建OR条件 [英] Dynamically creating OR conditions by passing an array to a query in MySQL PHP

问题描述

我正在尝试使用数组动态创建OR条件.给定一个数组，当然是名称$courses = array('Eng, 'Deu', 'Bio', 'Chemi')，我想要一个SQL查询，该查询使用OR条件下的AND子句中的数组值:

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')

我试图在PHP MySQL中做到这一点.

I trying to do it in PHP MySQL.

任何帮助将不胜感激.

预先感谢.

推荐答案

除了这么多OR子句，您只需使用 IN(..) :

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

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

在PHP代码中，您可以使用 implode() 函数将数组转换为逗号分隔的字符串，并在查询字符串生成中使用它.

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.

这篇关于通过将数组传递给MySQL PHP中的查询来动态创建OR条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！