implode multidimensional php array

Tani

I am working on e-commerce site in php. I've multidimensional php array like this :-

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
            [3] => 4
        )
[1] => Array
    (
        [0] => 5
        [1] => 6
        [2] => 7
    )

)

I am working on Advance search option. I've two table first one is product and another one is productattributes. I want to implode zero index array value by OR operator, One Index array value by OR Condition and then final array with zero index AND first index like this :-

select * from tbl_product where id IN(select product_id from tbl_vehicleproductequipments where (equipmentvalue_id = 1 OR equipmentvalue_id = 2 OR equipmentvalue_id = 3 OR equipmentvalue_id = 4) AND (equipmentvalue_id = 5 OR equipmentvalue_id = 6 OR equipmentvalue_id = 7)

I've tried this code :-

$eqpcond = "";
    if(!empty($_REQUEST["equipmentarr"])){
        foreach($_REQUEST["equipmentarr"] as $y => $equipval){
            $eqpcond = "select * from tbl_product where id IN (select product_id from tbl_vehicleproductequipments where ";
            foreach($equipval as $s => $vl){
                $equipcarr[] = " OR equipmentvalue_id = $vl";
            }
        }

        if(!empty($equipcarr)){
            $eqpcond = implode(" AND ",$equipcarr).")";
        }
    }

and i got the query like this which is not correct.

select * from tbl_product where id IN(select product_id from tbl_vehicleproductequipments where equipmentvalue_id = 1 AND OR equipmentvalue_id = 2 AND OR equipmentvalue_id = 3 AND OR equipmentvalue_id = 4 AND OR equipmentvalue_id = 5 AND OR equipmentvalue_id = 6 AND OR equipmentvalue_id = 7)

Please help me as I got stuck in this situation and I don't know how to do this. Any Help will be appreciated.

Thanks in Advance

Sanchit

Try this..I thinks this will produce the desired query. If not, please post the generate query and will make necessary changes.

$eqpcond = "";
        if (!empty($_REQUEST["equipmentarr"])) {
            foreach ($_REQUEST["equipmentarr"] as $y => $equipval) {
                $equipcstr = "";
                $equipcarr = array();
                $eqpcond = "select * from tbl_product where id IN (select product_id from tbl_vehicleproductequipments where ";
                foreach ($equipval as $s => $vl) {
                    $equipcstr .= " OR equipmentvalue_id = $vl";
                }
                $equipcstr = trim($equipcstr, 'OR');
                $equipcarr[] = $equipcstr;
            }

            if (!empty($equipcarr)) {
                $eqpcond = implode(" AND ", $equipcarr) . ")";
            }
        }

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

php implode multidimensional array

From Dev

implode multidimensional php array

From Dev

Implode multidimensional array with different glue in php

From Dev

Implode a multidimensional JSON array (PHP) without loops

From Dev

how to implode multidimensional array

From Dev

multidimensional array implode whole inner array elements function in php

From Dev

php array implode for insert

From Dev

Php implode empty array

From Dev

Implode / Explode PHP array

From Dev

How can I implode() a multidimensional array into a string?

From Dev

PHP array in table using implode()

From Dev

PHP: How to implode these array values?

From Dev

PHP implode array to create query

From Dev

php array implode explode with symbol

From Dev

PHP: How to implode these array values?

From Dev

How to implode multiple array in php?

From Dev

Implode array with skipping specific array items in php

From Dev

How can I implode() only one column from a multidimensional array?

From Dev

PHP implode explode first and last array value

From Dev

PHP is possible to implode ignoring specific array?

From Dev

Why is the PHP function "implode" returning the string "array"?

From Dev

implode array strings two by two - php

From Dev

php implode function empty array is not working

From Dev

Multidimensional array to array in PHP

From Dev

php compare multidimensional array

From Dev

php session multidimensional array

From Dev

PHP to Javascript multidimensional array

From Dev

PHP - Multidimensional Array Adding

From Dev

PHP - print multidimensional array