PHP - Complex (multidimensional Array) Csv Creation

Hi guys,

I'm using the API for Remember the Milk through a PHP class that I found online called PHP-RTM. Anyway after so much headaches (the authentication for the Remember the Milk API is one of the hardest I've ever come across) I've finally connected everything and gotten to the stage that I have some raw data inside an array. The next step is to work with that data.

Basically I want to access the names of the task in a complex multi demensional array and I have no idea how to do this. I have done a var_dump of the array I am working with to show you the complexity. Just remember that in the complex var_dump below there are only 4 tasks:

array(2) { ["stat"]=> string(2) "ok" ["tasks"]=> array(2) { ["rev"]=> string(31) "nxeir6vy9pcgcggoss4wwwooc8cwo8w" ["list"]=> array(3) { [/tt][list][li][tt]=> array(2) { ["id"]=> string( 8) "13927305" ["taskseries"]=> array(2) { [/tt][/li][li][tt]=> array(11) { ["id"]=> string(9) "104056511" ["created"]=> string(20) "2011-02-02T12:48:48Z" ["modified"]=> string(20) "2011-02-02T12:48:48Z" ["name"]=> string(42) "Send confirmation email to luxury car hire" ["source"]=> string(13) "iphone-native" ["url"]=> string(0) "" ["location_id"]=> string(0) "" ["tags"]=> array(0) { } ["participants"]=> array(0) { } ["notes"]=> array(0) { } ["task"]=> array(9) { ["id"]=> string(9) "156815180" ["due"]=> string(20) "2011-02-02T13:00:00Z" ["has_due_time"]=> string(1) "0" ["added"]=> string(20) "2011-02-02T12:48:48Z" ["completed"]=> string(0) "" ["deleted"]=> string(0) "" ["priority"]=> string(1) "N" ["postponed"]=> string(1) "0" ["estimate"]=> string(0) "" } } [1]=> array(11) { ["id"]=> string(9) "104148150" ["created"]=> string(20) "2011-02-03T01:25:57Z" ["modified"]=> string(20) "2011-02-03T01:26:17Z" ["name"]=> string(40) "Confirm that post has been sent with DVD" ["source"]=> string(2) "js" ["url"]=> string(0) "" ["location_id"]=> string(0) "" ["tags"]=> array(0) { } ["participants"]=> array(0) { } ["notes"]=> array(0) { } ["task"]=> array(9) { ["id"]=> string(9) "156951316" ["due"]=> string(20) "2011-02-02T13:00:00Z" ["has_due_time"]=> string(1) "0" ["added"]=> string(20) "2011-02-03T01:25:57Z" ["completed"]=> string(0) "" ["deleted"]=> string(0) "" ["priority"]=> string(1) "N" ["postponed"]=> string(1) "0" ["estimate"]=> string(0) "" } } } } [1]=> array(2) { ["id"]=> string( 8) "13925842" ["taskseries"]=> array(12) { ["id"]=> string( 8) "98105089" ["created"]=> string(20) "2010-12-19T11:25:25Z" ["modified"]=> string(20) "2011-02-02T13:01:42Z" ["name"]=> string(25) "Read for one hour per day" ["source"]=> string(13) "iphone-native" ["url"]=> string(0) "" ["location_id"]=> string(0) "" ["rrule"]=> array(2) { ["every"]=> string(1) "1" ["$t"]=> string(21) "INTERVAL=1;FREQ=DAILY" } ["tags"]=> array(0) { } ["participants"]=> array(0) { } ["notes"]=> array(0) { } ["task"]=> array(9) { ["id"]=> string(9) "156576423" ["due"]=> string(20) "2011-02-02T13:00:00Z" ["has_due_time"]=> string(1) "0" ["added"]=> string(20) "2011-02-01T13:01:45Z" ["completed"]=> string(0) "" ["deleted"]=> string(0) "" ["priority"]=> string(1) "N" ["postponed"]=> string(1) "0" ["estimate"]=> string(0) "" } } } [2]=> array(2) { ["id"]=> string( 8) "17007566" ["taskseries"]=> array(11) { ["id"]=> string(9) "104017503" ["created"]=> string(20) "2011-02-02T05:45:04Z" ["modified"]=> string(20) "2011-02-03T02:29:55Z" ["name"]=> string(96) "Hook up watermark for both videos (check email) and send to Rachelle and Steve at compare quotes" ["source"]=> string(2) "js" ["url"]=> string(0) "" ["location_id"]=> string(0) "" ["tags"]=> array(0) { } ["participants"]=> array(1) { ["contact"]=> array(3) { ["id"]=> string(7) "2150286" ["fullname"]=> string(10) "Samuel Nam" ["username"]=> string(10) "samuel.nam" } } ["notes"]=> array(0) { } ["task"]=> array(9) { ["id"]=> string(9) "156754354" ["due"]=> string(20) "2011-02-02T13:00:00Z" ["has_due_time"]=> string(1) "0" ["added"]=> string(20) "2011-02-02T05:45:04Z" ["completed"]=> string(20) "2011-02-03T02:32:00Z" ["deleted"]=> string(0) "" ["priority"]=> string(1) "N" ["postponed"]=> string(1) "0" ["estimate"]=> string(0) "" } } } } } }


Anyone know the code i can use to simply get the "name" keys from the complex array below.

I've created a movie to show what I'm trying to achieve, please click below to view:
http://screenr.com/XIY


MOD EDIT: formatted text to get rid of errant smilies  . . . [/list]

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

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

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.

I have a array as follows and I want to look by key where the key is 'ABCD', 'EFGH', etc.. I am using foreach but it is not working. How can I accomplish this?

Code: [Select]
Array
(
    [0] => Array
        (
            [ABCD] => Array
                (
                    [venue_id] => 1003
                    [has_dining] => X
                    [table_count] => 0
                    [serves_alcohol] => X
                )

        )

    [1] => Array
        (
            [EFGH] => Array
                (
                    [venue_id] => 1003
                    [has_dining] => X
                    [table_count] => 0
                    [serves_alcohol] => X
                )

        )
)

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

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?

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.

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

}

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!

Hi.
I have a multidimensional array and i need sort it by two different key.
I've tried almost every sort function but no chance.

Code: [Select]
Array (
[0] => Array (
[0] => 1 [id] => 1
[11] => this is test [main_txt] => this is test
[12] => 943965420 [add_time] => 943965420
[13] => 1323356400 [add_date] => 1323356400 )
[1] => Array (
[0] => 3 [id] => 3
[11] => another test [main_txt] => another test
[12] => 943965120 [add_time] => 943965120
[13] => 1323702000 [add_date] => 1323702000 )
[2] => Array (
[0] => 32 [id] => 32
[11] => oppss one more test [main_txt] => oppss one more test
[12] => 943944900 [add_time] => 943944900
[13] => 1323702000 [add_date] => 1323702000 )
[3] => Array (
[0] => 5 [id] => 5
[11] => okay, this is last one. Seriously [main_txt] => okay, this is last one. Seriously
[12] => 943937160 [add_time] => 943937160
[13] => 1323615600 [add_date] => 1323615600 )
)
I need sort by add_date(Newer to Older) first then add_time(Later to Earlier) later.

I hope i made my self clear.

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.