PHP - Multidimensional Array - How To Get Specific Values From Sub Array

Hi all,

I hope someone can help me out here as I think I am close but am not sure where to go from here.  The problem is:
I have a cms where a user can see a list of photos in the gallery.
I provide them the ability to select what photos they want to appear on a particular webpage.
The problem I have is that the user wants to be able to put the photos in whatever order they choose.

So, I have a form (see attached), the html code is:

          <table width="566px" cellspacing="0" border="0">              <tr>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='119' />&nbsp;Bathroom Sin...
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='113' />&nbsp;Courtyard 1
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' name='photos[][0]' value='114' />&nbsp;Courtyard 2
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value=""/>                  </div>
                </td>
              </tr>...

Now, lets assume that the user ticked the box next to 'Courtyard 2' and entered an integer '1' in the input box to signify that this image should be displayed 1st on the chosen webpage.  These 2 values go into the multidimensional array (photoid, ranking) and are submitted in the form to php in the photos[][] array.

But here is where I have the problem.  I am trying to extract the values from the array and then do an insert to a table in mysql.  My syntax must be wrong somewhere so I am asking anyone to please offer any advice:

  if (isset($_REQUEST['submitted'])){   
       $photos = $_REQUEST['photos'];
...

    if(!empty($photos)){
       foreach($photos as $photoID){
         $sql = "INSERT IGNORE INTO menuItemPhotos
                SET photoid='$photoID[0]', menuItemid='$id', ranking='$photoID[1]'";
        $ok = @mysql_query($sql); // execute the query
      } // End of foreach($photos as $photoID){
    } // End of if(!empty($photos)){

Thanks
Conor

[attachment deleted by admin]

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 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 have mysql select query shown below retrieving data from a database:

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

On inspection of the retrieved array with var_dump(), i have these result below:

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

 How do I get at and print out the highest score from this set of array values within this context.
 I tried this echo max($row['count']) but i understandably got this feedback:
Warning: max(): When only one parameter is given, it must be an array   Thanks.

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

Hi I have An array of file paths that I want to build into an array which I can then loop and display in a "file viewer", the problem been that I only want to output the folder name once and then the files within this folder. My solution is below but it doesnt work well once your 2+ subdirs in, the problem is if I have the same folder name deeper in the paths the second time it isnt output. Ideally a multidimensional array would work better that I can just lopp and print from $result['folder'] $result['files'] Iv tried this but when it comes to a subdir I hit a wall any help/pointers is very welcome iv lost 2 days on this and feel Like im just going around in circles now.

The array I have is, This is stored in a database with to columns filename and size, this is provided by the user as a string so I cant get the info myself sadly.
Code: [Select]
array (7)
{
'0' => string (15) test2/test2.txt
'1' => string (15) test1/test1.txt
'2' => string (33) test/test_test/test10/test101.txt
'3' => string (32) test/test_test/test10/test10.txt
'4' => string (23) test/test_test/test.txt
'5' => string (13) test/test.txt
'6' => string (9) test.root
}
This is the function iv currently got.
function getFiles($array, $size)
{
global $BASEPATH;
include($BASEPATH . '/include/fileTypes.php');
$i = 0;
$folderIcon = getFileTypeIcon('folder');
$string = '<div class="torDesc_fileTitle">Name<span class="torDesc_fileSizeTitle torDesc_right">Size</span></div>';
$string .='<div class="torDesc_file torDesc_fileAlt1 torDesc_folderName">' . $folderIcon . '</div>';
$lastCount = 0;
$lowerLevel = false;
$alt = 1;
//First we loop the files
foreach($array as $key => $value)
{
++$i;
$level = 0;
//Split the path
$keys = strpos($value, '/') !== false ? explode('/', $value) : array($value);
$count = count($keys);
$padding = 5;
if($lastCount < $count)
$upperLevel = true;
else
$upperLevel = false;

//Now we loop each item in this path
foreach($keys as $k => $v)
{
++$level;
if($upperLevel && $level == $lastCount)
$showFolder = true;
else
$showFolder = false;
$folder = false;
//First level folder
if($level == 1 && $count !== 1)
{
//Only output the folder if we havent already done so.
if($showFolder || !isset($output[md5($v . $level)]))
{
$repeater = $level;
$tabs = '|' . str_repeat('_', ($repeater) * $padding);
$alt = ($alt === 1 ? 2 : 1);
$output[md5($v . $level)] = true;
$string .= '<div class="torDesc_file torDesc_fileAlt' . $alt . '">&nbsp;&nbsp;' . $tabs . '<span class="torDesc_folderName">&nbsp;' . $folderIcon . '&nbsp;' . htmlentities($v) . 'a</span></div>';

}
}
//Second+ Level folder
elseif($level != $count)
{
//Only output the folder if we havent already done so.
if($showFolder || !isset($output[md5($v . $level)]))
{
$folder = true;
$repeater = $level - 1;
$tabs = '|' . str_repeat(str_repeat('&nbsp;', $padding * 2) . '|', $repeater) . str_repeat('_', $padding);
$alt = ($alt === 1 ? 2 : 1);
$output[md5($v . $level)] = true;
$string .= '<div class="torDesc_file torDesc_fileAlt' . $alt . '">&nbsp;&nbsp;' . $tabs . '<span class="torDesc_folderName">&nbsp;' . $folderIcon . '&nbsp;' . htmlentities($v) . 'b</span></div>';
}
}
//Its a file
else
{
$alt = ($alt === 1 ? 2 : 1);
$ext = explode('.', $v);
$ext = strtolower($ext[count($ext) -1]);
$img = getFileTypeIcon($ext);
$repeater = $level - 1;
$tabs = '|' . str_repeat(str_repeat('&nbsp;', $padding * 2) . '|', $repeater) . str_repeat('_', $padding);
$string .=  '<div class="torDesc_file torDesc_fileAlt' . $alt . '">&nbsp;&nbsp;' . $tabs . '<span class="torDesc_fileName">&nbsp;' . $img . '&nbsp;' . htmlentities($v) . 'c</span><span class="torDesc_fileSize">' . mksize($size[($i -1)]) . '</span></div>';
}
}
$lastCount = $count;
}
return $string;
}

I have an array created to control the down states of the my buttons in my navigation. Which is working well. This array will have quite a few strings in it before I'm done.

I then want to conditionally load a CSS file for all the files in that array with the exception of two, is this possible?

In plain in english I want to say If in array apart from these values then load my css file.

My array (will have more values when complete)

Code: [Select]
$otherTitles = array('Product Selector', 'Avon Range', 'Knightsbridge Range', 'Kingston Range' );

My code to load a css file

Code: [Select]
<?php if (in_array($title, $otherTitles)) { ?>
<link rel="stylesheet" type="text/css" href="homepage.css"/>
<?php } ?>

I want all titles in the otherTitles array to get this CSS file apart from two Product Selector and Avon Range.

Thanks

Richard

I need to some how pull comma separated images $data[23] from this $data array and then put them into there own array so I can insert them into separate rows in a database.


    
This is the provided array:

$data[0] => VIN
$data[1] => StockNumber
    
...(all the other number here)
    
$data[23] => Image_URLs (comma seperated)
$data[24] => Equipment


// I need something like this (obviously doesn't work?!@#)

$delimiter = ",";
$img = explode($delimiter, $data[23]);

foreach($img as $pic){
$sqlPic = "insert into class_prodimages (pid image rank) values('".$LastId['id']."', '$pic', '".rand(1,20)."')"; 

}



Any help here?

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

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?