PHP - Looping Over A Multidimensional Array

Hi, I'm trying to explode an array into a multidimensional array using <br /> tags as splitters but just can't get the syntax right! I can do lines of the array one by one, but not the whole lot at once. I'd really appreciate a quick example of an explode inside an array.

$myarray looks something like this with print_r:
(
    [0] => 
    [1] => some_html<br />some_html<br />some_html<br />
    [2] => some_html<br />some_html<br />some_html<br />
    [3] => some_html<br />some_html<br />some_html<br />
)

and I want to turn it into this:
(
    [0] => 
    [1] =>
     [0]some_html
     [1]some_html
     [2]some_html
    [2] => 
     [0]some_html
     [1]some_html
     [2]some_html
    [3] =>
     [0]some_html
     [1]some_html
     [2]some_html
)

I've tried this
$myarray = explode ("<br />", $myarray);
but it doesn't work …

It doesn't matter too much if there's are a few empty lines in the array from the final <br /> tags.

Many thanks, as ever, for any help.

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?

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

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

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

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.

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

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.

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.

how to create multidimensional array in php