Extract from Php Array using Conditions

Question

I would like to extract the data groups from the PHP arrays depending on the "RouterName". So, in the end, I will get 4 Big Arrays (ArrDeviceA, ArrDeviceB, etc.)

I don't want to use foreach and loop every rows and put into the separate array. Moreover, there might be the chance that some arrays might contain more than 3 rows. The number of rows are not constant.

Is there any function to query the array in PHP?

The raw data of php array are as follow:

mexique1 · Accepted Answer · 2010-06-26 11:40:27Z

3

I don't want to use foreach and loop every rows and put into the separate array.

Why ? That's 4 lines of crystal clear code, and you could even save a line... Stay simple.

$indexedByRouterName = array();
foreach ($array as $key => $value) {
    $routerName = $value['RouterName'];
    $indexedByRouterName[$routerName][] = $value;
}

Having an unknown number of lines is not a problem if you use the [] operator.

answered Jun 26, 2010 at 11:40

mexique1

1,69311 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cusspvz · Accepted Answer · 2010-06-26 11:18:59Z

Is there any function to query the array in PHP?

In PHP you can use the function in_array() ( http://www.php.net/manual/en/function.in-array.php ) to check if some key exists, and array_search() ( http://www.php.net/manual/en/function.array-search.php ) that makes almost the same of in_array() function, but returns the index value of the array instead of a boolean value.

They won't query as mysql_query() function, but you can make something like this:

function array_query($array,$what){
    if(in_array($what, $array)){
         return $array[array_search($what, $array)];
    }
    return false;
}

I Hope this work for you

EDIT: I've found an array_search() like for multidimensional arrays (your example), the code is above, you only have to trade on my function the array_search($what, $array) function with recursiveArraySearch($array,$what) function:

function recursiveArraySearch($haystack, $needle, $index = null)
{
    $aIt     = new RecursiveArrayIterator($haystack);
    $it    = new RecursiveIteratorIterator($aIt);

    while($it->valid())
    {       
        if (((isset($index) AND ($it->key() == $index)) OR (!isset($index))) AND ($it->current() == $needle)) {
            return $aIt->key();
        }

        $it->next();
    }

    return false;
}

Mark Baker · Accepted Answer · 2010-06-26 11:42:12Z

1

There's the SQL4Array library from absynthe that allows you to execute SQL queries against a PHP array. I don't believe it yet supports GROUP BY clauses, but it may provide an alternative to other methods of searching arrays

answered Jun 26, 2010 at 11:42

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

Extract from Php Array using Conditions

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related