How to loop through array of multiple arrays in php

Question

I am trying to loop through array of arrays in php. Usually get stalked with complex array sometimes but I need your kind assistance with this.

var_dump($array) produced the array below:

    $arrayVal = array(6) {
      ["item_id"]=>
      array(2) {
        [0]=>
        string(1) "1"
        [1]=>
        string(1) "2"
      }
      ["request_explanation"]=>
      array(2) {
        [0]=>
        string(7) "Welcome"
        [1]=>
        string(11) "Hello World"
      }
      ["quantity"]=>
      array(2) {
        [0]=>
        string(1) "4"
        [1]=>
        string(1) "4"
      }
      ["unit_cost"]=>
      array(2) {
        [0]=>
        string(1) "4"
        [1]=>
        string(1) "3"
      }
      ["total_cost"]=>
      array(2) {
        [0]=>
        string(1) "0"
        [1]=>
        string(1) "0"
      }
      ["supporting_document"]=>
      string(0) ""
    }

My database table:

I want to be able to save each of the value in that array into the table above. Thanks for helping me.

Barmar · Accepted Answer · 2018-07-25 22:38:20Z

1

Use the indexes of one of the sub-arrays to access all the other sub-arrays:

foreach ($array['item_id'] as $i => $item_id) {
    $request_explanation = $array['request_explanation'][$i];
    $quantity = $array['quantity'][$i];
    // repeat this for all the columns
    // Now you can insert all these variables into the database
}

answered Jul 25, 2018 at 22:38

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

Oyedele Femi Over a year ago

Thank you @Barmar, this finally worked for me. Negligence is not good most times. I think I was frustrated the first time I attempted it but once again, thank

Kisaragi · Accepted Answer · 2018-07-25 23:28:22Z

0

Use a loop to build 2 separate arrays:

foreach($array['ExpensesList'] as $index => $val){
    $array1[$index] = $array['ExpensesList'][$index][0];
    $array2[$index] = $array['ExpensesList'][$index][1];
}

Then insert each array into your database individually.

This will not work if any sub array contains an index at 2, so this is explicitly for the example structure you provided.

answered Jul 25, 2018 at 23:28

Kisaragi

2,2183 gold badges19 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to loop through array of multiple arrays in php

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related