PHP - Creating Multidimensional Array Containing Database Output

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 looking at the code below:

Code: [Select]
$array = array(
                array(
                1, 2
          ),
          'a' => array(
                'b' => 1,
                'c'
        )
);       
Is this an example of a multidimensional array? If so how would I access the value of 1 from key b?

Also would the next line ('c') be automatically assigned to the asociative key of c?

I've been working on some code to:
1. Search a db for rows that have a particular "position" value
2. Search the same db for rows that have a particular "langs" value
3. Compare the two arrays resulting for 1 and 2
4. Create a multidimensional array $langsarray[langs][question id] if 3 is true.
5. For each langs array in $langsarray pick a random, non-duplicate value and add it to $qarray for a maximum of 12 elements (3 for each langs).

What I have works about 95%.

The problem is, in the first langs array, one of the 3 randomly picked values is almost always empty, and its not always the same element. Sometimes its the first, sometimes its the third, sometimes its the second...

I think I've narrowed down the issue to line 44 ($qtemp = ...). If I change the min/max values for the mt_rand function, it behaves slightly differently. Any help is much appreciated! Thanks in advance.

Code:
//Include MYSQL class and authentication information
require_once('./include/mysql.php');
require_once('./include/global.php');

//Grab apptype from URL querystring
$apptype = $_GET['apptype'];

//Declare arrays
$qarray = array();
$posarray = array();
$langs = array();
$langsarray = array();

//Get id's of all questions pertaining to position type
$sql = 'SELECT * FROM qa WHERE position = "' . $apptype . '"';
$result = $db->query($sql) or die(mysql_error());
while ($row = $result->fetch()) {
$posarray[] = $row['id'];
}

//Determine what types of questions should be pulled
if ($apptype == 'fed'){
$langs = array('html','css','javascript','jquery');
}
else if($apptype == 'bed'){
$langs = array('php','asp','javascript','jquery');
}

//Get each question of each language that matches the position type and store it in the multidimensional array $langsarray[language][question id]
$z = 0;
while ($z < count($langs)){
$sql = 'SELECT * FROM qa WHERE langs = "' . $langs[$z] . '"';
$result = $db->query($sql) or die(mysql_error());
while ($row = $result->fetch()) {
if (in_array($row['id'],$posarray)){
$langsarray[$langs[$z]][] = $row['id'];
}
}

//Takes a random question id from the current language ($z) and adds it to the final question array.
$y = 0;
while ($y < 3) {
//$qtemp = $langsarray[$langs[$z]][mt_rand(0,count($langsarray[$langs[$z]]))];
$qtemp = $langsarray[$langs[$z]][mt_rand(0,count($posarray))];

if (!in_array($qtemp,$qarray)){ 
$qarray[] = $qtemp;
echo $qtemp . ', ';
$y++;
}
}
echo $langs[$z];
print_r( $langsarray[$langs[$z]]); echo '<br />';
$z++;
}
        echo '<br />';
print_r($qarray);


Output:

5, , 2, htmlArray ( => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 )      <--Problem
7, 6, 9, cssArray ( => 6 [1] => 7 [2] => 8 [3] => 9 [4] => 10 )
14, 15, 13, javascriptArray ( => 11 [1] => 12 [2] => 13 [3] => 14 [4] => 15 )
21, 17, 20, jqueryArray ( => 16 [1] => 17 [2] => 18 [3] => 19 [4] => 20 [5] => 21 )

Array ( => 5 [1] => [2] => 2 [3] => 7 [4] => 6 [5] => 9 [6] => 14 [7] => 15 [8] => 13 [9] => 21 [10] => 17 [11] => 20 )   <-- Final $qarray

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 trying to write a dirty script that removes duplicate rows from a multidimensional array.

I want to be able to edit the function and spit the duplicates out to a CSV file.

Here is my test file:


$fullArray = array(array('Jim', 'Jones'),
array('Pete', 'Pumpkin'),
array('Barak', 'Obama'),
array('Jason', 'Newstead'),
array('Toby', 'Keith'),
array('Jim', 'Jones'),
array('Jim', 'Nelson'));


echo "<h1>Original</h2>";
for($i=0; $i<count($fullArray); $i++) {
echo $fullArray[$i][0] . " " . $fullArray[$i][1] . "<br />";
}

echo "<h2>Checked</h2>";
$cleanArray = array();
$cay = array();
$nn=0;
$dup=0;
// Loop the entire input array
foreach ($fullArray as $index => $item) {
echo "foreach index:$index<br>";

        // Start an internal pointer
for ($f=0; $f<count($fullArray); $f++) {
echo "for $f ";
                // if the index is lower or the same as the pointer, skip it to cut down on time
if ($f > $index) {
                        // if the rows are the same...
if($fullArray[$f][0] == $item[0] && $fullArray[$f][1] == $item[1]) {
echo "$item[0] DUP<br>";
                                // remove it from the array
$cay = array_push($cleanArray, array($item[0], $item[1]));
array_pop($fullArray[5]);

$dup++;
} else {
                                // not a duplicate
echo " not a dup<br>";
}

} else {
echo "ON THIS ONE<br>";
}
}
echo "<br><br>";
}
echo"<br>$dup duplicates found<br><br>";
print_r($fullArray);
echo "<br /><br>";
// print_r($item);
print_r($cleanArray);
?>


When I spit out the new fullArray variable, it still has an element from the duplicate record.

This is what I get for the output of the full array after the duplicate was removed:
Quote

Array ( => Array ( => Jim [1] => Jones ) [1] => Array ( => Pete [1] => Pumpkin ) [2] => Array ( => Barak [1] => Obama ) [3] => Array ( => Jason [1] => Newstead ) [4] => Array ( => Toby [1] => Keith ) [5] => Array ( => Jim )[/b] [6] => Array ( => Jim [1] => Nelson ) )

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?

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

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?

Hey guys I am trying to make a simple shopping cart but I can't seem to wrap my head around this.

I have $_SESSION['cart'] as an array and I can add an item to it and then echo specific elements of the item like so

echo $_SESSION['cart']['0']['Name'];

I can not seem to figure out how to add a second item to the array so I can do something like

echo $_SESSION['cart']['1']['Name'];

and it will echo the second item that I 'added' to my cart?

Thanks I hope that makes sense.

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

Hi guys, I'm working on a project and I can't wrap my head around on a calculation that needs to be done on a multidimensional array. Quick background, it's a hotel benchmarking tool and I need to calculate the market penetration index (MPI). I have an array with 3 main arrays. First 2 are the hotels which are being compared and the last one is the MPI array.

Each array contains an array  for every month the user selects. Inside THAT array is data that needs to be used for calculations.
Here is an example:
Code: [Select]
Array
(
    [Competitive set] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 13
                            [data] => 67.6
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 13
                            [data] => 63.6
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 13
                            [data] => 59.2
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 13
                            [data] => 54.6
                        )

                )

        )

    [Test] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 89
                            [data] => 71.5
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 89
                            [data] => 67.0
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 91
                            [data] => 63.1
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 89
                            [data] => 57.5
                        )

                )

        )

    [MPI] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 89
                            [data] => 71.5
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 89
                            [data] => 67.0
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 91
                            [data] => 63.1
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 89
                            [data] => 57.5
                        )

                )

        )

)
Currently the  'data' for MPI is wrong. That needs to become the data of the first array divided by the data of the second array and multiplied by 100 (percentage).

How would I go about doing that? The foreach loops are a bit too big for me on this one.

Hi, I have an array of type array_name[roll_number][aggregate_marks]. How do I sort such array on 'aggregate_marks'? My attempts on sort, asort haven't worked.

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.

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.

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?