PHP - Parse Xml File To Multidimensional Array

I need to extract data from a CSV file and insert it into a MySQL database. I am able to extract the data, however I cannot figure out how to group it.

Sample File:
01   ISBN  Name of Book   Price
02   ISBN  Name of Book   Price

So far I have an array with the entire file (reading file with PHP):

Array ([0] => 01 [1] => 12345678X [2] => Title [3] => 120.00 ...etc.

How can I modify the array to create groups of four for each item? Each item is its own array?

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

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?

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.

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?

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

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

}

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

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

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.

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