Filtering array

[Andrew R]

Hi there

 

I have the following array .

 

$products = array(   array( Code => "CF1", 
                         Items => "Sand Tray",
                         Cat  => 'Tray',
                         ),
                  array( Code => "CF2", 
                         Items => "Mobile Computer Table",
                         Cat  => 'Table',
                         ),
                  array( Code => "CF3", 
                         Items => "General Service Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF4", 
                         Items => "TV Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF5", 
                         Items => "Overhead Projector Trolley",
                         Cat  => 'Trolley',
                         ),
                    array( Code => "CF6", 
                         Items => "Book Trolley",
                         Cat  => 'Tolley',
                         ), 
                         array( Code => "CF7", 
                         Items => "Stacking Chairs",
                         Cat  => 'Chairs',
                         ),     
  );  

 

What I want to do is select each by 'Cat'. For example I simply want to display all the trolleys. 

 

I was wondering how I do this? What functions would I use in PHP? 

 

Thanks a million 

[bh]

Hi,

 

try with array_walk_recursive function.

[ZacTopher]

I would just use a foreach

foreach ($products as $product) {
    $newProductsArray[$product['Cat']][] = $product;
    print_r($newProductsArray);
}

 

this would produce an array like this

Array
(
    [Tray] => Array
        (
            [0] => Array
                (
                    [Code] => CF1
                    [items] => Sand Tray
                    [Cat] => Tray
                )
        )
    [Table] => Array
        (
            [0] => Array
                (
                    [Code] => CF2
                    [items] => Mobile Computer Table
                    [Cat] => Table
                )
        )
    [Trolley] => Array
        (
            [0] => Array
                (
                    [Code] => CF3
                    [items] => General Service Trolley
                    [Cat] => Trolley
                )
            [1] => Array
                (
                    [Code] => CF4
                    [items] => TV Trolley
                    [Cat] => Trolley
                )
        )
)

[/code]

[Kieran Menor]

To be honest, it would seem like you would me much better off using a database.

 

For a specific solution, you could do something like this:

function filterByCat($dataset, $cat) {
    $result = array();
    foreach($dataset as $row) {
        if($row['Cat'] == $cat) {
            $result[] = $row;
        }
    }
    return $result;
}

[ZacTopher]

Boom.dk: then you wouldn't need that function at all. You would just do that where you fetch the data

[Kieran Menor]

Duh. The function was a solution to his specific problem, since he doesn't seem to be using a database.

[ZacTopher]

Well still you're showing him something that is overkill

[Kieran Menor]

Not really. The topic title is "Filtering array". In his post he mentions that he would like get all the entries that have a certain "Cat" value. My function does exactly that.

[ZacTopher]

yes but first you want him to get the info from the database then send the fetched array to another function instead of just using that function to do it all