Creating Sub Arrays with PHP

Question

Not having much luck creating a sub array, partially because I don't fully grasp how keys work.

Here is what I am trying to do:

$sql = "select * from products";
$db->query($sql);
$products = $db->rows();

foreach($products as $key=>$row) {

    $sql = "select * from sub_products WHERE productid = " . (int)$row['ID'] . "";
    $db->query($sql);
    $subproducts = $db->rows();

    $products[$key]['subproducts'] = $subproducts;

    foreach($products[$key]['subproducts'] as $rr=>$x) {

        $sql = "select * from subsubproducts WHERE subproducts = " . (int)$x['ID'] . "";
        $db->query($sql);
        $subsubproducts = $db->rows();

        $products[$key]['subproducts']['subsubproducts'] = $subsubproducts;
    }

}

I am not really grasping the concept of keys here and so therefore I am having a hard time understanding how to insert sub-arrays into other sub-arrays.

Currently, the code above, instead of placing the subsubproducts array as an array/item within the subproducts array, it is tagging it on as another item/array. i.e. under subproducts you have:

subproduct1
subproduct2
subsubproducts

Whereas it should be:

subproduct1
---subsubproductslisting

subproduct2
---subsubproductslisting.

jefffan24 · Accepted Answer · 2014-07-25 20:47:40Z

3

You've almost got it you just need to do replace this:

$products[$key]['subproducts']['subsubproducts'] = $subsubproducts;

with this:

$products[$key]['subproducts'][$rr]['subsubproducts'] = $subsubproducts;

In the second foreach loop

answered Jul 25, 2014 at 20:47

jefffan24

1,3263 gold badges21 silver badges35 bronze badges

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

Comments

Patrick Moore · Accepted Answer · 2014-07-25 20:48:08Z

If I follow your train of thought, it should be as easy as identifying the key and using it in the second loop to identify the correct array.

    $products[$key]['subproducts'][ $rr ]['subsubproducts'] = $subsubproducts;

In context:

$sql = "select * from products";
$db->query($sql);
$products = $db->rows();

foreach($products as $key=>$row) {

    $sql = "select * from sub_products WHERE productid = " . (int)$row['ID'] . "";
    $db->query($sql);
    $subproducts = $db->rows();

    $products[$key]['subproducts'] = $subproducts;

    foreach($products[$key]['subproducts'] as $rr=>$x) {

        $sql = "select * from subsubproducts WHERE subproducts = " . (int)$x['ID'] . "";
        $db->query($sql);
        $subsubproducts = $db->rows();

        $products[$key]['subproducts'][ $rr ]['subsubproducts'] = $subsubproducts;
    }

}

Steve Buzonas · Accepted Answer · 2014-07-25 20:52:00Z

1

You are properly adding depth to the arrays, your logical context is just off.

foreach($products[$key]['subproducts'] as $key=>$row) will assign the index to $key and the value to $row for each iteration.

foreach($products[$key]['subproducts'] as $rr => $x) will assign the index to $rr and the value to $x for each iteration.

When you assign to $products[$key]['subproducts']['subsubproducts'] you are assigning a value to the key subsubproducts at the subproducts level.

Changing the assignment to:

$products[$key]['subproducts'][$rr]['subsubproducts'] = $subsubproducts;

should give you the desired result.

answered Jul 25, 2014 at 20:52

Steve Buzonas

5,7501 gold badge35 silver badges56 bronze badges

1 Comment

CRAIG Over a year ago

Thanks for the extra information Steve. Once I saw it on Jeffan's answer it made sense to me.

Collectives™ on Stack Overflow

Creating Sub Arrays with PHP

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related