PHP - Why Mysql_fetch_array Into Multidimensional Array?

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 am having a bit of trouble with the following (just for theoretical purposes of course!).

Just wondered how you do the following code:

$products = array(); // makes a empty array called $products

$i = 1;
$icol = 1;
while($row = mysql_fetch_array($result)) {
$products[$i]['product1'] = $row[$icol][0];
$i = $i++;
}

All its meant to do is:

Quote

SELECT * FROM products


Which the table contains just 3 columns:
productid | product   | price
1 |  product1  |  25.55

That is it, very simple, but wanted to make a multi dimension array that will be 3 columns wide, then however many rows (hence the while loop and array fetch etc).

Any help is appreciated, just coming from a VBA background when it comes to the arrays in VB lol.

Thanks for any help in advance,
Jeremy.

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 have an array() in which I would like to manipulate certain elements:

Code: [Select]
Array
(
    [TESCO] => Array  (
            [Veg] => Array (
                    [Potatoe] => 12
                    [Cabbage] => 24
                    [Cucumber] => 56
                )
            [Meat] => Array (
                    [Chicken] => 54
                    [Beef] => 89
                )
        )

    [ASDA] => Array (
            [Veg] => Array (
                    [Potatoe] => 12
                    [Cabbage] => 24
                    [Cucumber] => 56
                )
            [Meat] => Array (
                    [Chicken] => 23
                    [Beef] => 90
                )
        )
)

How would I go about adding the price of my meat section together e.g. Chicken + Beef from ASDA = 113

Also how to add/remove elements from Meat/Veg?
Like adding Pork

Cheers

how to create multidimensional array in php

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'
)
);

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.

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.

I have a array as follows and I want to look by key where the key is 'ABCD', 'EFGH', etc.. I am using foreach but it is not working. How can I accomplish this?

Code: [Select]
Array
(
    [0] => Array
        (
            [ABCD] => Array
                (
                    [venue_id] => 1003
                    [has_dining] => X
                    [table_count] => 0
                    [serves_alcohol] => X
                )

        )

    [1] => Array
        (
            [EFGH] => Array
                (
                    [venue_id] => 1003
                    [has_dining] => X
                    [table_count] => 0
                    [serves_alcohol] => X
                )

        )
)

I have the following multidimensional array;

Array
(
    => Array
        (
            [value] => Alarm
            [safe] => Alarm
            [view] => Alarm
        )

    [1] => Array
        (
            [value] => Deadlocks
            [safe] => Deadlocks
            [view] => Deadlocks
        )

    [2] => Array
        (
            [value] => Security Doors
            [safe] => Security Doors
            [view] => Security Doors
        )

)

I'm trying to implode the array to end up with an output like "Alarm, Deadlocks, Security Doors".

But I cannot for the life of me work out the correct PHP.  I'm assuming i need some foreach loop? Any help would be greatly appreciated.

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

}

Trying to retun an array which gets a file from a directory and then returns the filename as the key and the complete file url as the value but when returning it it prints out "Array" for each file in the directory rather than the file name:
Doing this in wordpress.

Code: [Select]
function wsme_select_css_theme(){
$alt_css_template_path = WSME_THEME_CSS; // Define path to files
$alt_widgets_template = array(); // set array
$out = ''; // Set var

if ( is_dir($alt_css_template_path) ) { // If directory exists
if ($alt_css_template_dir = opendir($alt_css_template_path) ) { //opens directory
while ( ($alt_css_template_file = readdir($alt_css_template_dir)) !== false ) { //if files are in the directory
if(stristr($alt_css_template_file, ".css") !== false) { //if the files are .css files
$out[] = array($alt_css_template_file => WSME_THEME_CSS.'/'.$alt_css_template_file); //create the array(filename => file path) for each file in the directory
}
}
}
return $out; // return array
}
}


Code: [Select]
array(
            'name' => 'Style',
            'id' => WS_THEME_PREFIX . '_style',
            'headings' => array(
                array(
                    'name' => 'Theme CSS',
                    'options' => array(
                        array('name' => 'Homepage',
                            'desc' => ' select the css file of the theme you want for your site',
                            'id' => WS_THEME_PREFIX . '_theme_css',
                            'value' => '',
                            'options' => wsme_select_css_theme(),
                            'type' => 'select'
                        )
                    )
                )
            )

Any suggestions?

<?php
$_SESSION["cart_item"] = array(
'cart_item' => array(
'id' => $id,
'product_name' => $product_name
));
}
$cart_items = $_SESSION["cart_item"];

foreach ($cart_items as $cart_item) {
echo $cart_item["id"] . $cart_item["product_name"];
}
?>

I have tried several variations of the foreach loop like the one above and I mostly get the error message: Notice: Array to string conversion. When I use:
var_dump($cart_items);

I get the following output:

array(1) { ["cart_item"]=> array(2) { ["id"]=> array(2) { [0]=> string(1) "2" [1]=> string(1) "3" } ["product_name"]=> array(2) { [0]=> string(19) "Adult Female Bike" [1]=> string(18) "Kids Unisex Bike" } } }

I want to create an array based on data in a multidimensional array. Take, for example:

$table[1] = array('husband' => array ('firstname'=> 'Albert',
                                                           'lastname' => 'Einstein',
                                                           'age'      => 129),
                           'wife'         => array ('firstname' => 'Mileva',
                                                           'lastname'  => 'Einstein',
                                                           'age'       => 128));

What would be the best approach, when you want to
create an array with only the last names or the ages? Are there some
things like wildcards in the PHP array universe to skip the first array level?

Any suggestion is very appreciated. I tried several strategies, but ended up creating the same mulitdimensional array as above.