PHP 2 mysql merge results

Question

I execute 2 queries on 2 different servers with the same table structure. How can I combine 2 arrays in PHP?

thanks

Answer 1

PDO :: query () returns a PDOStatement that implements the Traversable interface .
The SPL class IteratorIterator wraps any Callbacks as an Iterator .
And another SPL class, AppendIterator , can "concatenate" iterators to act as one iterator.

<?php
$result1 = $pdo1->query('SELECT * FROM foo');
$result2 = $pdo2->query('SELECT * FROM foo');

$it = new AppendIterator;
$it->append(new IteratorIterator($result1));
$it->append(new IteratorIterator($result2));

foreach($it as $row) {
  echo join(', ', $row), "\n";
}

Answer 2

array_merge.

array array_merge ( array $array1 [, array $... ] )

, . .

, . , , , , .

, .

Answer 3

, , ( db auto_increment), UUID .

, uuid , , , , .