<?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.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- 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:
203.22 ms | 402 KiB | 345 Q