Loop and Insert multi-dimensional array items

Question

I am getting confused as to how I could loop trough my multidimensional associative array and pull the values separately to insert into my database. I am wanting to pull each item from the old array and populate it into a column called old and pull each item from the new array and populate it to the new column.

    $array = array(

        'old' => array('item1', 'item2'),
        'new' => array('item3', 'item4')

    );


    foreach($array as $items){

        foreach($items as $value){

        $model = new \Namespace\Model;
        $model->old = $items['old'];
        $model->new = $items['new']
        $model->save();

        }

    }

barbarity · Accepted Answer · 2015-03-09 17:20:01Z

2

Well, I think foreach is not going to help you here. Try this:

$array = array(

        'old' => array('item1', 'item2'),
        'new' => array('item3', 'item4')

    );

if(count($array['old'] == $array['new'])) {
    $model = new \Namespace\Model;
    for($i = 0; $i < count($array['old']); $i++){
        $model->old = $array['old'][$i];
        $model->new = $array['new'][$i];
        $model->save();
    }

}

answered Mar 9, 2015 at 17:20

barbarity

2,5181 gold badge25 silver badges30 bronze badges

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

1 Comment

barbarity Over a year ago

If you see, he is saving it in the model before i rewrite it. My guess is save persists it in a database. If not, you would be right, but if I'm right I save memory by doing it like this.

EnerGee_Clan Uk · Accepted Answer · 2015-03-09 19:23:44Z

1

try this:

$array = array( array("item1" => "1" , "item2" => "2") , array("item1" =>"1", "item2" =>"2");

You would have to parse each different array all the sub arrays would just run in a for loop like this:

for($i = 0, $i < $array->getLength;$i++){
$array["item1"][$i];
}

answered Mar 9, 2015 at 19:23

EnerGee_Clan Uk

421 bronze badge

Collectives™ on Stack Overflow

Loop and Insert multi-dimensional array items

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related