On 10/16/07, Ladislav Andel <ladaan@xxxxxxxxx> wrote:
> Hi list!
> I read data from 2 databases and for the purpose of displaying the
> information at my web interface as one piece
> I need to combine the data into one array first.. Here is my problem:
>
> Firstly, it reads from first DB and get this array: (it's a sum of
> server names in table)
>
> arrayDB1 = array(array('8', 'SER'), array('5','Asterisk'))
>
> When finished then it starts reading from second DB
> where I would get
>
> arrayDB2 = array(array('6', 'XIP'), array('4','Asterisk'))
>
>
> Is there any function where I would get
> result = array(array('8', 'SER'), array('9','Asterisk'), array('6','XIP'))
If you have to have data manipulation when combining the arrays (such
as adding the two separate values for "Asterisk" as per your example),
then there isn't a pre-defined function to do what you want. I'd
change the arrangement of your arrays a bit, so that they looked
something like the following (very untested):
$arrDB1 = array('Asterisk' => 5, 'SER' => 8);
$arrDB2 = array('Asterisk' => 4, 'SER' => 6);
function addArrays($arr1, $arr2)
{
$res = array();
if (is_array($arr1) and is_array($arr2))
{
$keys = array_merge(array_keys($arr1), array_keys($arr2));
foreach ($keys as $key)
{
$res["$key"] = $arr1["$key"] + $arr2["$key"]; //May have to
check isset of each $arrX["$key"] before addition, not sure
}
} else
{
//Do appropriate error handling here...
}
return $res;
}
>
> Probably, it would be best to add number of Asterisk while cycling
> through data of second DB.
> The problem could be when databases have thousands of rows in each DB.
>
> I'm just asking in case you know a better approach.
>
> Thank you,
> Lada
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
