Combine arrays PHP

Question

HELLO

SORRY FOR FRENCH , i will try english i have tree arrays like this

$keys = array("elment1","elment1","elment2","elment1");
// this one can have duplicates values , 

$operator = array("=","<",">","=");
// operators for Mysql query 

$queries = array("query1","query2","query3","query4");
// mixtes values

the question is :

how can i combine this tree arrays like so :

$string = "SELECT FROM tables 
           WHERE
           (elment1 = query1 OR elment1<query2 OR elment1=query4)
           // need group duplicates keys 
           AND
           elment2 > query3";
           // non duplicates 

why i'm asking that , because i need this for a multi queries filtres

the user push a (+) button to add keys+operator+query a many time as he like

i'm using jquery to create form elements , and a each() function to generate 3 arrays before posting all to php

if someone know a best approach then welcome and thank you very much

Answer 1

You asked a question in French, I'll answer in English and you can use Google Translate if you need a translation. [Utilisez Google Translate pour traduire cette réponse si vous voulez.]

First of all, you'll need to concatenate the pieces. Pay attention to the mysql_real_escape_string, which makes the whole operation a little bit safer.

$joined = array();
for($i = 0, $size = sizeof($keys); $i < $size; ++$i) {
    $joined[$i] = $keys[$i] . " " . $operator[$i] . " '" . mysql_real_escape_string($queries[$i]) . "'";
}

Then you can use implode:

$string = 'SELECT [...] WHERE (' . implode(' OR ', $joined) . ')';

Answer 2

Bonjour,

Here is the code. tried and tested. Voila le code... essayer avec succé

$keys = array("elment1","elment1","elment2","elment1");
// this one can have duplicates values , 
$operator = array("=","<",">","=");
// operators for Mysql query 
$queries = array("query1","query2","query3","query4");
// mixtes values

$joined = array();
for($i = 0, $size = sizeof($keys); $i < $size; ++$i)
{
    $joined[$keys[$i]][] = $keys[$i] . $operator[$i] . $queries[$i];
}

foreach ($joined as $key => &$value)
{
    $value = implode(' OR ', $value);
    $value = "(" . $value . ")";
}
$query = implode(' AND ', $joined);
print $query;