在UNION查询中将php数组中的值作为参数传递

Question

I want to pass values from array as individual parameter in a query and use them as below

Array
(
    [0] => some
    [1] => text
)

I want this kind of function

public function getData($some,$text)
{
$sql = " select * from table where field1 = '{$some}' OR field3 = {$some}      ";
$union = " UNION ";
$sql = " select * from table where field2 = '{$text}' or field4 = {$text}  ";
}

Note: The array may have Nth number of index.

Answer 1

You can use the following:

public function getQuery($dataArray) {
    $queryArray = array();
    foreach($dataArray as $data) {
        $query = "SELECT * from `table`";
        $conditionArray = array();
        foreach($data as $key => $value) {
            $conditionArray[] = "`$key` = `$value`";
        }
        if (!empty ($conditionArray)) {
            $query .= " WHERE ". implode(" OR ", $conditionArray);
        }
        $queryArray[] = $query;
    }
    return implode(" UNION ", $queryArray);
}