Storing array within an array using PHP

Question

foreach ($topicarray as $key=>$value){
    $files = mysql_query("mysqlquery");

    while($file = mysql_fetch_array($files)){ extract($file);
        $topicarray[$value] = array( array($id=>$title)
                      );
       }
    }

The first foreach loop is providing me with an array of unique values which forms a 1-dimensional array.

The while loop is intended to store another array of values inside the 1-dimensional array.

When the while loop returns to the beginning, it is overwriting it. So I only ever get the last returned set of values in the array.

My array ends up being a two dimensional array with only one value in each of the inner arrays.

Feels like I'm missing something very basic here - like a function or syntax which prevents the array from overwriting itself but instead, adds to the array.

Any ideas?

Paolo Bergantino · Accepted Answer · 2012-06-20 22:18:38Z

2

Step 1. Replace $topicarray[$value] with $topicarray[$value][]
Step 2. ???
Step 3. Profit

answered Jun 20, 2012 at 22:18

Paolo Bergantino

490k83 gold badges523 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thisisready Over a year ago

Can't believe I didn't try that. I think I got lost in the array, forgetting the fundamentals of how to start an array!

Ry- · Accepted Answer · 2012-06-20 22:19:40Z

2

Make $topicarray[$value] an array of rows, instead of one row. Also, don't use extract here.

foreach ($topicarray as $key => $value) {
    $rows = array();
    $files = mysql_query("mysqlquery");

    while($file = mysql_fetch_array($files)) {
        $rows[] = array($file['id'] => $file['title']);
    }

    $topicarray[$value] = $rows;
}

Also, you should switch to PDO or MySQLi.

answered Jun 20, 2012 at 22:19

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

2 Comments

thisisready Over a year ago

Any particular reason not to use extract()?

Ry- Over a year ago

@chocolatecoco: It could overwrite random variables in your code if you add columns to the query/table later on, and it's just not as obvious or as efficient as accessing them through array indices.

Collectives™ on Stack Overflow

Storing array within an array using PHP

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related