Online PHP editor | output for e7nWu

@ 2013-09-05T06:36:11Z

<?php
    function splitDatabaseArray($array)
        {
        ksort($array);
        $return = array();
        $last_database_table = array();
        foreach ($array as $index => $value)
            {
            $database_table = array();
            list($database_table[0], $database_table[1]) = explode('.', $index);
            if ($last_database_table != $database_table)
                $row = &$return[];
            $last_database_table = $database_table;
            $row[$index] = $value;
            }
        return $return;
        }
    
    $array = array
        (
        'database1.table1.fieldname' => "test",
        'database1.table1.fieldname1' => "test1",
        'database2.table2.fieldname' => "test2");
    
    var_dump(splitDatabaseArray($array));

Output for 5.2.1 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.36, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.10, 7.2.29 - 7.2.33, 7.3.12 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.14: array(2) { [0]=> array(2) { ["database1.table1.fieldname"]=> string(4) "test" ["database1.table1.fieldname1"]=> string(5) "test1" } [1]=> array(1) { ["database2.table2.fieldname"]=> string(5) "test2" } }
Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0: array(2) { [0]=> &array(2) { ["database1.table1.fieldname"]=> string(4) "test" ["database1.table1.fieldname1"]=> string(5) "test1" } [1]=> array(1) { ["database2.table2.fieldname"]=> string(5) "test2" } }

preferences:dark modelive previewkey bindings