PHP - Help With Returning Multidimensional Array

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 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'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!

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

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.

I'm trying to create a multidimensional array of movies organized by genre. This should take the form of an associative array with genres as keys.  Each of the arrays elements should be an array containing movie names.

This is what I have:
<?php
$movies = array(
        array("SF" => "", "Terminator", "Soylent Green", "I Robot", "frankenstein"),
         array("horror" => "exorcist", "IT", "frankenstein"),
         array("comedy" => "holy grail", "blazing saddles", "young frankenstein")
    );
   
//echo $movies[0][0]."<br>";
//echo $movies[1][0]."<br>";
//echo $movies[2][0];

foreach ($movies as $c) {
        while (list($k, $v) = each ($c)) {
echo "$k ... $v <br/>";
        }
}
?>

this is the output:
SF ...
0 ... Terminator
1 ... Soylent Green
2 ... I Robot
3 ... frankenstein
horror ... exorcist
0 ... IT
1 ... frankenstein
comedy ... holy grail
0 ... blazing saddles
1 ... young frankenstein

you'll see Terminator is only listed as element 0 because there's an empty string in front of it. The first item in the array is liated as the value to the key while the second value is listed as element 0.  It doesn't seem right to me.

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.

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 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?

I am having trouble searching for an item in a multi-dimensional array.

Is there a way to search only one column in a multi-dimensional array?

i.e:

MULTI-DIMENSIONAL ARRAY

ID  Name  DataTable
0   John  Employee
1   Dan   Employee
2   Matt  Boss
3   Becky Supervisor


Is there a way to only search the column "Name"(Column 2) using array_search() or similar? (i.e array_search("John",$ARRAY[Column2])

The help would be very much appreciated!

Cheers, Dan 

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 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

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.

Hi freaks,

Got a simple one for ya, I THINK?

I have a multi-array that resembles this..
Code: [Select]
$_SESSION["book_array"] = array(0 => array("plantID" => $plantID, "botanicalName" => $botanicalName, "commonName" => $commonName, "use" => $use));

I would like to sort it by the botanicalName key of the inner array before I call the forech loop that renders the display so that after it renders the table the items will be seen alphabetically, code below..
Code: [Select]
<?php 
$bookOutput = "";
//$plant_use_array = '';
if (!isset($_SESSION["book_array"]) || count($_SESSION["book_array"]) < 1) {
    $bookOutput = '<tr><td colspan="4"><h6>Your Book is EMPTY!</h6></td></tr>';
} else {
// Start the For Each loop
$i = 0; 
    foreach ($_SESSION["book_array"] as $each_item) { 
$plantID = $each_item['plantID'];
$botanicalName = $each_item['botanicalName'];
$botanicalName = stripslashes($botanicalName);
$commonName = $each_item['commonName'];
$commonName = stripslashes($commonName);
$use = $each_item['use'];
//$x = $i + 1; 
// Dynamic table row assembly
$bookOutput .= "<tr>";
$bookOutput .= '<td><a href="plant_details.php?plantID=' . $plantID . '" id="bodyLink">' . $botanicalName . '</a></td>';
$bookOutput .= '<td>' . $commonName . '</td>';
$bookOutput .= '<td><strong>' . $use . '</strong></td>';
$bookOutput .= '<td><form action="book.php" method="post"><input name="removeBtn" type="submit" value="Remove"/><input name="index_to_remove" type="hidden" value="' . $i . '" /></form></td>';
$bookOutput .= '</tr>';
$i++; 
    } 
}
?>

Any help would be much appreciated!  Thanks in advance.

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.