PHP - Multidimensional Array Can't Comprehend

Hi everybody,

I generally find any assistance that I need on various sites, but this one has me stumped. I'm not overly advanced with my use of arrays, so I'd like some help here if anyone knows what I am looking for.

I have a form that I would like to submit to a MySQL database. In that form, there is the ability to add up to 3 harddrives:
Code: [Select]
Brand: <input type="text" name="hdds[0][hddbrand]" id="hddbrand"><br/>
Model and/or size,type: <input type="text" name="hdds[0][hddtype]" id="hddtype"><br/>
SN: <input type="text" name="hdds[0][hddsn]" id="hddsn"><br/>
Notes: <input type="text" name="hdds[0][hddnotes]" id="hddnotes" size="50">
Obviously the next harddrive would be hdds[1][hddbrand], etc.

I am having an awful time looping through this to get more than 1 harddrive's information, however. I've tried foreach embedded in foreach and been messing around with this for a good 3-4 hours now and I feel like I am just missing something.

I've got this right now to debug:
Code: [Select]
foreach($_POST['hdds'] as $key => $a) {
$hddbrand = $a['hddbrand'];
}
my print_r($a) comes up with the following:
Code: [Select]
Array ( [hddbrand] => Toshiba [hddtype] => Shaba 500gb [hddsn] => 5fu8bvw4 [hddnotes] =>none ) 1
Good. That's what I want. But I need some help constructing my array/loop to get the values of more than 1 drive should I have to enter information for more than 1 drive.

I feel like I am close, but I am just not getting what I need. I have not had to work with multidimensional arrays before and they are proving to be more trickier than I expected. Any help would be enormously appreciated!

Patrick

I am trying to store all the elements of my tree in an array.My code produces multi dimensional array, but i want it to be one dimensional. How can i get it ?

Code:-
Code: [Select]
function tree_gather($node)   //Function to calculate count
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
   
    if(!empty($array['lchild']) || !empty($array['rchild']))
    {
   
      $child[] = $array['lchild'];
      $child[] = $array['rchild'];
      $child[] = tree_gather($array['lchild']);
      $child[] = tree_gather($array['rchild']);
     
    }
     return $child;
  }
Result:-
Code: [Select]
Array
(
    [0] => 2
    [1] => 3
    [2] => Array
        (
            [0] => 4
            [1] => 5
            [2] => Array
                (
                    [0] => 10
                    [1] => 11
                    [2] =>
                    [3] =>
                )

            [3] => Array
                (
                    [0] => 8
                    [1] => 9
                    [2] =>
                    [3] =>
                )

        )

    [3] => Array
        (
            [0] => 7
            [1] => 6
            [2] => Array
                (
                    [0] => 15
                    [1] => 14
                    [2] => Array
                        (
                            [0] => 16
                            [1] => 17
                            [2] =>
                            [3] =>
                        )

                    [3] =>
                )

            [3] => Array
                (
                    [0] => 13
                    [1] => 12
                    [2] =>
                    [3] =>
                )

        )

)

Table: -

I recently posted a simple query about ISSET and finally got that simple problem solved thanks to you guys. But I've hit a new snag. I've create a simple sort of cart, or record counter. While I can add/remove/clear items and display their affilated arrays, I don't know how to cycle through a multidimensional array that is dynamically set.   Something like $_SESSION['Primary'][$items][$attributes] - Where $items is a dynamic set, and $attributes is a fixed set of keys with values.   I can target individual $Items, or display all the items in there. But I can't display all the Items and their subsequent $attributes aswell. Do I have to write 1 set of Ajax code for just displaying the $items, and another for each individual set of $attributes? Or is their a way to cycle through each $item, and then all of it's(or specific) $attributes and values? I've tried using loops which logically work, but I can't pass it through json_encode.   Is there any documentation I could read in relation to this? I feel this is the key component to manuvering through a database of sorts. I'm just not entirely sure how to go about accessing multidimensional Array's without a ton of code that becomes redudent. And even then, it wouldnt work well with a dynamic setup.
Edited by 7blake, 07 November 2014 - 01:39 PM.

Hi, I am trying to get a random monster from my multidimensional "monsters" array. I have array monsters, and inside that I have array "ocean" and inside that are "fish", "shark" etc.
like the below, and I am trying to pick out a random monster from the Ocean array. Any help greatly appreciated. thank you. Derek

here is the array

Code: [Select]
$monsters = array
(
'Ocean'=>array
(
'octalisk'=>array
(
'name'=>'octalisk',
'hp'=>100,
'damageLow'=>1,
'damageHigh'=>15,
'exp'=>10,
'ac'=>'HAVE TO LOOK THIS UP',
'monsterInitiativeModifier'=>'HAVE TO LOOK THIS UP'),

'shark',
'eel'
),
'Desert'=>array
(
'sand_snake'
),
'Forest'=>array
(
'frog',
'lizard',
'spider'
)
);

Ok I have a multidimensional array and what I want to know is how to use it. I need to pick the items from the array but only the items specified or individual keys in the array how would I go about doing that. Here is the array:
<?php
$monstors = array
(
  "Skeleton"=>array
  (
  "mob_name"=>"Skeleton",
  "mob_attack"=>"5",
  "mob_hp"=>"30",
  "mob_level"=>"1"
  ),
  "Skeleton Fighter"=>array
  (
  "mob_name"=>"Skeleton Fighter",
  "mob_attack"=>"10",
  "mob_hp"=>"35",
  "mob_level"=>"2"
  ),
  "Skeleton Warrior"=>array
  (
  "mob_name"=>"Skeleton Warrior",
  "mob_attack"=>"15",
  "mob_hp"=>"40",
  "mob_level"=>"3"
  )
);
?>
How would I like print_r the element in the array called Skeleton Warrior?

I'm trying to pull out a list of id's into a simple array, but I seem to be getting is a multidimensional array. All I need is a simple array with the list of id's. What am I doing wrong?
//Get list of all sentence id's selected for test in database
$allSentenceQuery = mysql_query("SELECT id FROM associations WHERE validate='checked'") or die("First Query: ".mysql_error());
while ($allSentenceResult = mysql_fetch_array($allSentenceQuery)){
$allSentences[] = $allSentenceResult['id'];
//echo "allSentences: ".$allSentenceResult['id'];
}

And what I get:
 "Array ( => Array ( [1] => 2 [2] => 3 etc...."

Thanks for your help!

Hey guys, quick question.

I have an array that looks like (blow). How can i sort it based on array[0][3], the #'s 1,2,3,4,5,6 are what i want to sort by in ASC order.

Code: [Select]
<?php

Array ( 
[0] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 1 
[4] => fy 
) 
[1] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 2 
[4] => fy 
) 
[2] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 3 
[4] => fy 
) 
[3] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 4 
[4] => fy 
) 
[4] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 5 
[4] => fy 
) 
[5] => Array ( 
[1] => Link Name 
[2] => URL
[3] => 6 
[4] => fy 
)

?>

Thanks for the help.

I am a beginner, so forgive me all to whom this is trivial...

I have an array, generated from simpleXML object, trying to parse...  The array is not symmetrical & I am having trouble finding the right code to make it work.  Help & comments are welcomed..

Here is the raw array with print_r:
Code: [Select]
Array
(
    [Area] => Array
        (
            [0] => Array
                (
                    [Name] => Basement
                    [Id] => 1
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Equipment
                                    [Id] => 1
                                )

                            [1] => Array
                                (
                                    [Name] => Theater
                                    [Id] => 9
                                )

                            [2] => Array
                                (
                                    [Name] => Wine Cellar
                                    [Id] => 10
                                )

                        )

                )

            [1] => Array
                (
                    [Name] => 1st Floor
                    [Id] => 2
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Kitchen
                                    [Id] => 2
                                )

                            [1] => Array
                                (
                                    [Name] => Main Hall
                                    [Id] => 4
                                )

                            [2] => Array
                                (
                                    [Name] => Foyer
                                    [Id] => 8
                                )

                            [3] => Array
                                (
                                    [Name] => Stone Room
                                    [Id] => 14
                                )

                            [4] => Array
                                (
                                    [Name] => Garage Foyer
                                    [Id] => 16
                                )

                            [5] => Array
                                (
                                    [Name] => Dining Room
                                    [Id] => 17
                                )

                            [6] => Array
                                (
                                    [Name] => Living Room
                                    [Id] => 18
                                )

                            [7] => Array
                                (
                                    [Name] => Hearth Room
                                    [Id] => 19
                                )

                            [8] => Array
                                (
                                    [Name] => Office
                                    [Id] => 20
                                )

                            [9] => Array
                                (
                                    [Name] => Powder Room
                                    [Id] => 21
                                )

                        )

                )

            [2] => Array
                (
                    [Name] => 2nd Floor
                    [Id] => 3
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Landing
                                    [Id] => 7
                                )

                            [1] => Array
                                (
                                    [Name] => Master Bedroom
                                    [Id] => 11
                                )

                            [2] => Array
                                (
                                    [Name] => Nannys Room
                                    [Id] => 13
                                )

                            [3] => Array
                                (
                                    [Name] => East Kids Bed
                                    [Id] => 27
                                )

                            [4] => Array
                                (
                                    [Name] => West Kids Bed
                                    [Id] => 28
                                )

                            [5] => Array
                                (
                                    [Name] => Kids Bath
                                    [Id] => 29
                                )

                            [6] => Array
                                (
                                    [Name] => Robs Closet
                                    [Id] => 31
                                )

                            [7] => Array
                                (
                                    [Name] => Kelli's Office
                                    [Id] => 32
                                )

                        )

                )

            [3] => Array
                (
                    [Name] => 3rd Floor
                    [Id] => 7
                    [Room] => Array
                        (
                            [Name] => Bonus room
                            [Id] => 5
                        )

                )

            [4] => Array
                (
                    [Name] => Outside Areas
                    [Id] => 8
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Veranda
                                    [Id] => 22
                                )

                            [1] => Array
                                (
                                    [Name] => Back Outdoor
                                    [Id] => 23
                                )

                            [2] => Array
                                (
                                    [Name] => Christmas Lights
                                    [Id] => 33
                                )

                            [3] => Array
                                (
                                    [Name] => Front Outdoor
                                    [Id] => 34
                                )

                            [4] => Array
                                (
                                    [Name] => Garage
                                    [Id] => 35
                                )

                            [5] => Array
                                (
                                    [Name] => Poolhouse Kitchen
                                    [Id] => 24
                                )

                            [6] => Array
                                (
                                    [Name] => Poolhouse Utility
                                    [Id] => 25
                                )

                        )

                )

        )

)
Here is the code:
Code: [Select]
foreach($xml2['Area'] as $v){
echo $v['Name'],' <br>';
foreach($v['Room'] as $v2){
echo '  ',$v2['Name'],' <br>';
}
}
Here is the result:
Code: [Select]
Basement
  Equipment
  Theater
  Wine Cellar
1st Floor
  Kitchen
  Main Hall
  Foyer
  Stone Room
  Garage Foyer
  Dining Room
  Living Room
  Hearth Room
  Office
  Powder Room
2nd Floor
  Landing
  Master Bedroom
  Nannys Room
  East Kids Bed
  West Kids Bed
  Kids Bath
  Robs Closet
  Kelli's Office
3rd Floor
  B
  5
Outside Areas
  Veranda
  Back Outdoor
  Christmas Lights
  Front Outdoor
  Garage
  Poolhouse Kitchen
  Poolhouse Utility
The problem lies with the "3rd Floor" which should contain "Bonus Room" as the room.  I know that this is the only element that has no "Rooms" array, but I can't figure out how to code the trap for it.  With this data, the condition could exist anywhere, not just my example, but I am stumped with the non symmetrical array that I am unfamiliar with.  Any help?  Thanks. --akaweed

Hi All

I'm new to php and I have a multidimensional array set up which I need to sort for a results list from an assessment.

The array is $gradout['name']['userid']=score.

I need to sort the array by score in a decending order. 

['name'] is a string and ['userid'] is a numeric.

I've tried looking at the php manual but It's just confusing me.  Can anyone explain to me in laymans terms what I need to do and why.

Hey guys im trying to insert these values from this array into the distance function I made and then it turns it into a string. Took me like 8 hours of problem solving just to find out this wasnt working. really could use some help with this. $arr is the array



Array ( [0] => Array ( [b_x] => 85 [b_y] => 71 ) [1] => Array ( [b_x] => 436 [b_y] => 130 )

$b_x = 295;
$b_y = 163;
foreach($arr as $db) {

$db_x = $db['b_x'];
$db_y = $db['b_y'];

$distance .= distance($b_x,$b_y,$db_y,$db_x) . "-";
}
end result is suppose to look like $distance-$distance-$distance and so forth

Ok I'm really lost here, what I need to do is shuffle a 2D array. Now when I shuffle them I want to keep both columns aligned to say. Like I only want the index to change.

Kinda like this:

Index         Id           URL
0                [2          www.e] I want the bracketed stuff to stay aligned.
1                [6          www.b]
2                [12        www.c]
3                [60        www.h]

But I want them in different positions on every page load. So when I echo array[1][0] it will always be different. Is this even possible?

Hi,

Could really do with some help.

So I've got a Multidimensional array like so

Code: [Select]
Array
(
    [Asia] => Array
        (
            [0] => China
            [1] => Japan
        )

    [Europe] => Array
        (
            [0] => France
            [1] => Germany
            [2] => Spain
            [3] => UK
        )
)

I have a Mysql table (continents pre-filled)

Code: [Select]
Continent - Country
Asia       
Europe

I need to update country where continent is xxx

So I need a query/php function which will when run would fill in "china, japan" into "asia" and "france, germany, spain, uk" into "europe", like so

Code: [Select]
Continent - Country
Asia          - China, Japan
Europe     - France, Germany, Spain, UK

I don't really know where to start so I don't have a code. Would really appreciate some assistance.

Hi All

How do I go about splitting a multidimensional array into seperate smaller ones?

Currently I have $grade[region][userid]=value.

I'd like to split as $region1[userid]=value $region2[userid]=value $region3[userid]=value $region4[userid]=value $region5[userid]=value $region6[userid]=value
Is there an inbuilt function for this?

how to create multidimensional array in php

Code: [Select]
while($row=mysql_fetch_assoc($query)) {   
   $id = $row['id'];
   $col1 = $row['name1'];
   $col2= $row['name2'];
   $col3= $row['name3'];

 ${"$id"} = array("$col1","$col2","$col3");
    ${"$s".$i}[] = ${"$id"};
    }
This is just a brief example of what i'm trying to accomplish,$i is incremented somewhere else. I'm trying to implode the arrays in the array. So below i have imploded the main array but how do i implode the other arrays?

Code: [Select]
for($i=0;$i<11;$i++) {
$array = ${"s" . $i};
$outcomes = implode("",$array); //implodes main array

}