Convert a nested array into a flat array with PHP

Question

Hello all,

I'm trying to create a generic database mapping class with PHP. Collecting the data through my functions is going well, but as expected I'm retrieving a nested set.

A print_r of my received array looks like:

Array
(
    [table] => Session
    [columns] => Array
        (
            [0] => `Session`.`ID` AS `Session_ID`
            [1] => `Session`.`User` AS `Session_User`
            [2] => `Session`.`SessionID` AS `Session_SessionID`
            [3] => `Session`.`ExpiresAt` AS `Session_ExpiresAt`
            [4] => `Session`.`CreatedAt` AS `Session_CreatedAt`
            [5] => `Session`.`LastActivity` AS `Session_LastActivity`
            [6] => `Session`.`ClientIP` AS `Session_ClientIP`
        )

    [0] => Array
        (
            [table] => User
            [columns] => Array
                (
                    [0] => `User`.`ID` AS `User_ID`
                    [1] => `User`.`UserName` AS `User_UserName`
                    [2] => `User`.`Password` AS `User_Password`
                    [3] => `User`.`FullName` AS `User_FullName`
                    [4] => `User`.`Address` AS `User_Address`
                )

            [0] => Array
                (
                    [table] => Address
                    [columns] => Array
                        (
                            [0] => `Address`.`ID` AS `Address_ID`
                            [1] => `Address`.`UserID` AS `Address_UserID`
                            [2] => `Address`.`Street` AS `Address_Street`
                            [3] => `Address`.`City` AS `Address_City`
                        )

                )

        )

)

To simplify things I want to recreate this nested array to a flat array so I can easily loop through it and use the 'columns' key to create my SELECT query.

I'm kinda struggling with this for a while now and figures, maybe some users at SO can help me out here.

I've tried multiple things with recursion, all without luck so far...

Any help is much appriciated!

Thanks in advance, Ben Fransen

Answer 1

http://stackoverflow.com/questions/1222821/php-flatten-multidimensional-array

http://stackoverflow.com/questions/1319903/how-to-flatten-a-multidimensional-array

http://stackoverflow.com/questions/526556/how-to-flatten-a-multi-dimensional-array-to-simple-one-in-php

http://stackoverflow.com/questions/929222/how-do-i-flatten-an-associative-array-into-an-array-with-only-values-in-php

http://stackoverflow.com/questions/2289475/converting-php-array-of-arrays-into-single-array

http://stackoverflow.com/questions/2473844/how-to-get-array-of-values-from-an-associative-arrays

That's just the first page of results when searching the site for "flatten array php"