Re: [PHP] combining 2 arrays

[James Ausmus]

Array merge won't work as he needs to add the numerical values
involved, not just merge the arrays - there are overlap on the text
values, and any overlap needs to result in a val1 + val2.

-James


On 10/16/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Ladislav Andel [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 16, 2007 1:05 PM
> > To: James Ausmus; PHP List
> > Subject: Re: [PHP] combining 2 arrays
> >
> > Thank you very much!
> > It's exactly the code I was looking for!
> >
> > Lada
> > PS: my previous ungly code is half long now :)
> >
> > James Ausmus wrote:
> > > On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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
>
> Wouldn't this work?
> http://us2.php.net/manual/ro/function.array-merge.php
> http://us2.php.net/manual/ro/function.array-merge-recursive.php
>
> Also, you don't need to do (and shouldn't do):
>
> $arr1["$key"]
>
> Just make it
>
> $arr1[$key]
>
> No " marks. The quotes are a waste of time and will slow down your script if
> you have many rows.
>
> --
> 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

RE: [PHP] combining 2 arrays

[Daevid Vincent]

> -Original Message-
> From: Ladislav Andel [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 16, 2007 1:05 PM
> To: James Ausmus; PHP List
> Subject: Re: [PHP] combining 2 arrays
> 
> Thank you very much!
> It's exactly the code I was looking for!
> 
> Lada
> PS: my previous ungly code is half long now :)
> 
> James Ausmus wrote:
> > On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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

Wouldn't this work?
http://us2.php.net/manual/ro/function.array-merge.php
http://us2.php.net/manual/ro/function.array-merge-recursive.php

Also, you don't need to do (and shouldn't do):

$arr1["$key"]

Just make it

$arr1[$key]

No " marks. The quotes are a waste of time and will slow down your script if
you have many rows.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] combining 2 arrays

[Ladislav Andel]

Thank you very much!
It's exactly the code I was looking for!

Lada
PS: my previous ungly code is half long now :)

James Ausmus wrote:

On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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

Re: [PHP] combining 2 arrays

[Ladislav Andel]

nope, merge is not doing what I want and also using FEDERATED 
 
engine in mysql I think is not the simplest way to go or even not 
appropriate.
Anyhow, I did it an ugly way ( tablearray follows DB queries with the 
same fields; one row of a query is e.g.

count=5, server_name="Asterisk" )
Variable dbs is an array with MySQL URIs.

Lada

function get_data($dbs, $tablearray, $query) {
   $id = 0;
   $result = array();
   $records = 0;
   $db_select = 0;
   for ($c = 0; $c < $len; $c++) {
   $db =& DB::Connect( $dbs[$db_select] );
   if (PEAR::isError($db)) { echo "Can't connect to 
DB".$db_select.""; }

   else {
   $res = $db->query($query, array() );
   while( $res->fetchInto( $row ) ) {
   $cols = count($row);
   if ($db_select > 0) {
   for ($i=0; $i < $records; $i++) {
   if (in_array($row[1],$result[$i])) {
   $result[$i][$tablearray[0]] = $row[0] + 
$result[$i][$tablearray[0]];

   break;
   }
   else {
   if ([EMAIL PROTECTED]) {
   @$entered = True;
   for ($b=0; $b<$cols; $b++) {
   $result[$id][$tablearray[$b]] = 
$row[$b];

   }
   $id++;
   }
   }
   }
   @$entered = False;
   }
   else {
   for ($i=0; $i<$cols; $i++) {
   $result[$id][$tablearray[$i]] = $row[$i];
   }   
   $id++;

   }
   }
   }
   $db_select++;
   $records = count($result);
   return $result;
}


Philip Thompson wrote:

On 10/16/07, Greg Donald <[EMAIL PROTECTED]> wrote:
  

On Tue, 16 Oct 2007, Paul Scott wrote:


You could try something like:

$result[] = $arrayDB1;
$result[] .= $arrayDB2;
  

That .= doesn't do what you think it does when used with arrays.




Take this same concept (of creating a new array) and see if you can use
array_merge. I know you mentioned earlier that it wasn't what you were
looking for... however, maybe the combination will work???

Good luck,
~Philip

  


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] combining 2 arrays

[James Ausmus]

On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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

Re: [PHP] combining 2 arrays

[Philip Thompson]

On 10/16/07, Greg Donald <[EMAIL PROTECTED]> wrote:
>
> On Tue, 16 Oct 2007, Paul Scott wrote:
> > You could try something like:
> >
> > $result[] = $arrayDB1;
> > $result[] .= $arrayDB2;
>
> That .= doesn't do what you think it does when used with arrays.


Take this same concept (of creating a new array) and see if you can use
array_merge. I know you mentioned earlier that it wasn't what you were
looking for... however, maybe the combination will work???

Good luck,
~Philip

Re: [PHP] combining 2 arrays

[Greg Donald]

On Tue, 16 Oct 2007, Paul Scott wrote:
> You could try something like:
>
> $result[] = $arrayDB1;
> $result[] .= $arrayDB2;

That .= doesn't do what you think it does when used with arrays.


-- 
Greg Donald
Cyberfusion Consulting
http://cyberfusionconsulting.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] combining 2 arrays

[Paul Scott]

On Tue, 2007-10-16 at 16:42 +0200, Ladislav Andel wrote:
> 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'))
> 

You could try something like:

$result[] = $arrayDB1;
$result[] .= $arrayDB2;

If I understand the question correctly.

--Paul

All Email originating from UWC is covered by disclaimer 
http://www.uwc.ac.za/portal/uwc2006/content/mail_disclaimer/index.htm 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] combining 2 arrays

[Ladislav Andel]

Ladislav Andel wrote:

Miles Thompson wrote:

array_merge() function?

If your db is MySQL, look at this thread, Google being your friend:
http://lists.mysql.com/mysql/204616

  

Thanks for quick reply.
Array_merge doesn't do what I want.

And also those databases are at different locations.. Not the same 
machines.

I found something here http://www.linux.com/articles/52390
but not sure if it is what I want but will read up.


This is not what I'm looking for either.. (replicating).
Data at each database are mostly different.


Thanks,
Lada



Cheers - Milesx

On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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'))

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

Re: [PHP] combining 2 arrays

[Ladislav Andel]

Miles Thompson wrote:

array_merge() function?

If your db is MySQL, look at this thread, Google being your friend:
http://lists.mysql.com/mysql/204616

  

Thanks for quick reply.
Array_merge doesn't do what I want.

And also those databases are at different locations.. Not the same machines.
I found something here http://www.linux.com/articles/52390
but not sure if it is what I want but will read up.

Thanks,
Lada



Cheers - Milesx

On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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'))

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

Re: [PHP] combining 2 arrays

[Miles Thompson]

array_merge() function?

If your db is MySQL, look at this thread, Google being your friend:
http://lists.mysql.com/mysql/204616

Cheers - Milesx

On 10/16/07, Ladislav Andel <[EMAIL PROTECTED]> 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'))
>
> 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] combining 2 arrays

[Ladislav Andel]

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'))

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