PHP array with subarray

Question

Extracted data from excel

        $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
        $arrayCount = count($allDataInSheet);
       for($i=1;$i<=$arrayCount;$i++)
        {                   
            $arraydata[]= array(
                                "FoodOrder_ID" => $allDataInSheet[$i]["B"],
                                "FoodID" => $allDataInSheet[$i]["C"],
                                "FoodName" => $allDataInSheet[$i]["D"],
                                "FoodQuantity" => $allDataInSheet[$i]["E"]);

        }




        $result = array();
        foreach ($arraydata as $element) {
             $result[$element['FoodOrder_ID']][] = $element;
        }




        echo "<pre>";
        print_r($result);
        echo "</pre>";
        exit;

Above is my code that able to return data that in excel

Array
(
    [FO012] => Array
        (
            [0] => Array
                (
                    [FoodOrder_ID] => FO012
                    [FoodID] => 22
                    [FoodName] => Burger
                    [FoodQuantity] => 1
                )

            [1] => Array
                (
                    [FoodOrder_ID] => FO012
                    [FoodID] => 23
                    [FoodName] => Coke
                    [FoodQuantity] => 1
                )

            [2] => Array
                (
                    [FoodOrder_ID] => FO012
                    [FoodID] => 53
                    [FoodName] => Sprite
                    [FoodQuantity] => 1
                )

        )

    [FO013] => Array
        (
            [0] => Array
                (
                    [FoodOrder_ID] => FO013
                    [FoodID] => 12
                    [FoodName] => Salad
                    [FoodQuantity] => 1
                )

        )

    [FO014] => Array
        (
            [0] => Array
                (
                    [FoodOrder_ID] => FO014
                    [FoodID] => 64
                    [FoodName] => Sandwich
                    [FoodQuantity] => 1
                )

        )

)

Above is my return result. What i wanted to do : In subarray , only show "FoodID" and "FoodQuantity" ?

Currently in subarray also showing foodorder_id , but what i wanted is that in subarray only show 2 of the data.

Any idea how to exclude it ?

Remove the assignment of the other indicec, e.g. "FoodOrder_ID" => $allDataInSheet[$i]["B"],? — DarkBee
– DarkBee, Commented Sep 11, 2020 at 5:59
@DarkBee if i removed it , the below foreach will stop working. as i need the"FoodOrder_ID" to become the "parent" — greenboxgoolu
– greenboxgoolu, Commented Sep 11, 2020 at 6:04
Just move that logic in your first loop? That 2nd loop is redundant — DarkBee
– DarkBee, Commented Sep 11, 2020 at 6:05
Ahh got it , thanks , look like i still need to improve my array skill, thanks once again — greenboxgoolu
– greenboxgoolu, Commented Sep 11, 2020 at 6:27

verjas · Accepted Answer · 2020-09-11 06:24:51Z

3

You could try this something like this. (Like @Darkbee said, you don't need two for loops):

$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$arrayCount = count($allDataInSheet);

$result = array();
for($i=1;$i<=$arrayCount;$i++)
{
    $FoodOrder_ID = $allDataInSheet[$i]["B"];
    if (!isset($result[$FoodOrder_ID]))
        $result[$FoodOrder_ID] = array();
        
    $result[$FoodOrder_ID][] = array(
        "FoodID" => $allDataInSheet[$i]["C"],
        "FoodQuantity" => $allDataInSheet[$i]["E"]
    );
}

echo "<pre>";
print_r($result);
echo "</pre>";
exit;

Can you check if this solves it?

answered Sep 11, 2020 at 6:24

verjas

1,7931 gold badge15 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

PHP array with subarray

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related