[RESOLVED] Dynamic Multidimensional Array

[edie]

I'm making my first dynamic multidimensional array and I have run into problems code below is what I got so far

<?php
require("class.php");
$q = "SELECT DISTINCT menu_type FROM menu";
$r = @mysqli_query ($dbc, $q);

$cart=array();
if ($r){
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

 $cart[$row['menu_type']]=$row['menu_type'];

}
mysqli_free_result ($r); 
}

foreach ($cart as $value){
	$q = "SELECT DISTINCT menu_subtype FROM menu WHERE menu_type = '$value'";
	//echo $q;
	$r = @mysqli_query ($dbc, $q);
	while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
		$cart[''.$value.''] = array($row['menu_subtype']);
	}
}
print_r($cart);
?>

problem is on the 2rd dimension over rides its self what I mean is if there are 4 subtypes the 1st first gets over rid by the 2nd then the 2nd by the 3rd by the 4th so if the 4th is last in the loop only the 4th will be in the array when the loop is done

I’m after something like the below
Array (
[INDENT][Breads] => Array ( [0] => )
[Risotto] => Array ( [0] => )
[Salads] => Array ( [0] => )
[Pizza] => Array ( [0] => )
[Kids Menu] => Array ( [0] => )
[Desserts] => Array ( [0] => )
[Drinks] => Array ( [INDENT][Coffee] => Coffee
[Tea] => Tea
[Soft Drink] => Soft Drink
[Hot Chocolate] => Hot Chocolate)[/INDENT][/INDENT]
)

But all I get is
Array (
[INDENT][Breads] => Array ( [0] => )
[Risotto] => Array ( [0] => )
[Salads] => Array ( [0] => )
[Pizza] => Array ( [0] => )
[Kids Menu] => Array ( [0] => )
[Desserts] => Array ( [0] => )
[Drinks] => Array ( [ Hot Chocolate] => Hot Chocolate)[/INDENT]
)

Sorry for any spelling or Grammar errors

[johanafm]

You should solve this by using one query with a join rather than one query for the super types and one additional query for each of those, but...

edie;10975116 wrote:

		$cart[''.$value.''] = array($row['menu_subtype']);

		$cart[''.$value.''][$row['menu_subtype']] = $row;

[edie]

Using

$cart[''.$value.''][$row['menu_subtype']] = $row;

gives me

Array (
[INDENT][Breads] => Areads
[Risotto] => Aisotto
[Salads] => Aalads
[Pizza] => Aizza
[Kids Menu] => Aids Menu
[Desserts] => Aesserts
[Drinks] => Arinks[/INDENT]
)

and I have limited know how with JOIN querys not sure how to use it for this problem

[johanafm]

Ah, missed the last bracket pair to keep appending

$cart[''.$value.''][$row['menu_subtype']][] = $row; 

As for the join problem I just realized that you are using one table rather than two as I would have expected. So there is no need to perform a join (but I'd recommend normalizing your data and joining your two tables). Anyway, using one query

SELECT menu_type, menu_subtype, other_fields_needed FROM menu

Will get you rows looking something like

Drinks, Coffee
Drinks, Hot Chocolate
Drinks, Soft Drink
Drinks, Tea
Pizza, Salami
Pizza, MultiCheese

And then you'd need to adapt your php code to do only one loop since you have all the data allready

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC))
{
	$cart[$row['menu_type']['menu_subtype'][] = $row;
}

[edie]

when using

$cart[''.$value.''][$row['menu_subtype']][] = $row;

i get the error "Fatal error: Cannot use string offset as an array in C:\xampp\htdocs\arrays2.php on line 23"

line 23 being the above code

and when trying to make one queue like the one you posted i get the error
"Parse error: syntax error, unexpected ';', expecting ']' in C:\xampp\htdocs\arrays2.php on line 17"

line 17 being

$cart[$row['menu_type']['menu_subtype'][] = $row;

[johanafm]

You'd have to post more code for the first issue.

For the second one, you have several errors

# wrong  one
$cart[$row['menu_type']['menu_subtype'][] = $row; 

# and here you can easily see that you miss a ]
$cart[$row['menu_type']    ;# ['menu_subtype'][] = $row; 

# which gives this
$cart[$row['menu_type']];

# and inspecting the second parts shows us this which has no meaning whatsoever
['menu_subtype']     ;#[] = $row;

# while this does
$row['menu_subtype']

#and putting those together gives
$cart[$row['menu_type']][$row['menu_subtype']][] = $row;

# or looking at it from the opposite direction
$row['menu_type'] = 'drinks';
$row['menu_subtype'] = 'coffee';

# then you get this by substitution
$cart[   'drinks'   ][   'coffee'   ][] = $row

[edie]

require("db_class.php");
//$q = "SELECT menu_type, menu_subtype FROM menu";
$q = "SELECT DISTINCT menu_type, menu_subtype FROM menu";
$r = @mysqli_query ($dbc, $q);

$cart=array();
if ($r){
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC))
{
    $cart[$row['menu_type']][$row['menu_subtype']][] = $row;
}
mysqli_free_result ($r); 
}
print_r($cart);

gives me

Array
(
[INDENT] [Breads] => Array
[INDENT] (
[INDENT][] => Array
[INDENT] (
[INDENT][0] => Array
(
[INDENT][menu_type] => Breads
[menu_subtype] => [/INDENT][/INDENT]
)[/INDENT]
[/INDENT]
)[/INDENT]

    )

[/INDENT]
[INDENT] [Salads] => Array
[INDENT] (
[INDENT] [] => Array
(
[INDENT] [0] => Array
(
[INDENT][menu_type] => Salads
[menu_subtype] =>[/INDENT] [/INDENT]
)[/INDENT]

            )[/INDENT]

    )[/INDENT]

[INDENT][Drinks] => Array

[INDENT] (
[INDENT] [Soft Drink] => Array
[INDENT] (
[0] => Array
(
[menu_type] => Drinks
[menu_subtype] => Soft Drink
)

            )

        [Tea] => Array
            (
                [0] => Array
                    (
                        [menu_type] => Drinks
                        [menu_subtype] => Tea
                    )

            )

        [Coffee] => Array
            (
                [0] => Array
                    (
                        [menu_type] => Drinks
                        [menu_subtype] => Coffee[/INDENT]
                    )[/INDENT]

            )[/INDENT]

    )[/INDENT]

)

this is the kinda thing i have been looking for thank you for the help with this problem but i have one more question, what would be the best way to call this information out of the array later on

i want to make links dynamically like the below using the multidimensional array

<a href='index.php?page=menu&ty=Breads'>Breads</a>

once again thank you for the help so far

[JVassie]

edie;10975966 wrote:

this is the kinda thing i have been looking for thank you for the help with this problem but i have one more question, what would be the best way to call this information out of the array later on

i want to make links dynamically like the below using the multidimensional array

<a href='index.php?page=menu&ty=Breads'>Breads</a>

once again thank you for the help so far[/QUOTE]

I would use a combination of foreach and for/while loops.

Seems to me first though you need to tidy up your arrays, because it looks like some of them aren't needed.

[CODE][Breads] => Array

(

    [] => Array

        (

            [0] => Array
            (

                [menu_type] => Breads
                [menu_subtype] => 

        )

)

)

becomes

[Breads] => Array

(

            [0] => Array
            (

                [menu_type] => Breads
                [menu_subtype] => 

            )

)

)

[edie]

require("db_class.php");
$q = "SELECT DISTINCT menu_type, menu_subtype FROM menu";
$r = @mysqli_query ($dbc, $q);

//$cart=array();
if ($r){
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC))
{
    $cart[$row['menu_type']][$row['menu_subtype']][] = $row;
}
mysqli_free_result ($r); 
}
foreach ($cart as $type=>$arrayone){
	echo "<p>".$type."</p><ul>";
	foreach ($arrayone as $sub=>$arraytwo){
		if (!empty($sub)){
		echo "<li>".$sub."</li>";
		}
	}
	echo "</ul>";
}
//print_r($cart);

after playing around i worked out how to read from my Dynamic Multidimensional Array using:

foreach ($cart as $type=>$arrayone){
	echo "<p>".$type."</p><ul>";
	foreach ($arrayone as $sub=>$arraytwo){
		if (!empty($sub)){
		echo "<li>".$sub."</li>";
		}
	}
	echo "</ul>";
}

but it looks like the code making the array needs be cleaned up and have been playing around with it but no luck so far

[edie]

have cleaned it up a little by removing the [] from

$cart[$row['menu_type']][$row['menu_subtype']][] = $row;

so now looks like

$cart[$row['menu_type']][$row['menu_subtype']] = $row;

[JVassie]

edie;10976276 wrote:

have cleaned it up a little by removing the [] from

$cart[$row['menu_type']][$row['menu_subtype']][] = $row;

so now looks like

$cart[$row['menu_type']][$row['menu_subtype']] = $row;

And did the simplifying help at all?

[edie]

it removed one of the empty arrays