Filtering a Multidimensional Array based of another array [duplicate]

Question

I'm creating a PHP class that manipulates csv files. As part of the class I have a function that allows the data to be filtered showOnlyWhere. However I get this error Invalid argument supplied for foreach() on line 331 (the line with the foreach statement). I tried adding global $arr; but that didn't work. How would i fix it?

$this -> rows is a multi-dimensional array that contains all the csv data.

$arr is in the format:

$key=>$val array(
$key = Column Name
$val = value that column should contain
)

Below is the showOnlyWhere function

function showOnlyWhere($arr)
    {

                if($this->showOnlyWhere == true){
                    $rows = $this->filteredRows;
                }
                else{
                    $rows = $this->rows;
                }

                $filter = function ($item){
                        global $arr; // didn't work
                        foreach($arr as $chkCol => $chkVal){
                            if ($item[$arr[$chkCol]] != $chkVal ){
                                return false;
                                break(3);
                            }                      
                        }
                        return true;
                    };


                $this->filteredRows = array_filter($rows,$filter);                  


                $this->showOnlyWhere = true;    
}

I think the error might have something to do with the Anonymous function - but I'm not really sure.

FuzzyTree · Accepted Answer · 2014-07-20 03:05:12Z

2

instead of using global $arr you can make $arr available to the anonymous function via use

$filter = function ($item) use ($arr) {
    //global $arr; // didn't work
    foreach($arr as $chkCol => $chkVal){
        if ($item[$arr[$chkCol]] != $chkVal ){
            return false;
        }                      
    }
    return true;
};

Also, I noticed that you are assigning $rows = $this->filteredRows; before you populate $this->filteredRows. I'm not sure if that's intentional?

edited Jul 20, 2014 at 3:05

answered Jul 20, 2014 at 3:00

FuzzyTree

32.4k3 gold badges58 silver badges87 bronze badges

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

Comments

user1735921 · Accepted Answer · 2014-07-20 03:05:38Z

0

Format for your $arr is wrong.

this is wrong:

$key=>$val array(
$key = Column Name
$val = value that column should contain
)

You cannot supply class objects to foreach, it should be a valid array.

It should be like this:

$arr=array(
$key => 'Column Name',
$val = 'value that column should contain'
);

So first convert your object to a valid array.

answered Jul 20, 2014 at 3:05

user1735921

1,3991 gold badge24 silver badges47 bronze badges

1 Comment

mickmackusa Over a year ago

This isn't the asker's actual code, this is poorly formatted pseudo code. I understand your confusion.

Collectives™ on Stack Overflow

Filtering a Multidimensional Array based of another array [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related