\n";
}
foreach ($ArrayOfTables as $TableName) {
$sql = "select * from " . $TableName . ";";
$columns = array();
if ($DisplayCopyAction)
{
print "
\n";
print "" . $sql . "Columns = \n";
}
$QueryResults = $PDO_dbh_Src->query($sql);
foreach ($QueryResults as $row) {
foreach ($row as $key=>$value)
{
if (is_numeric($key) || $key == $ExcludedColumn)
continue;
$columns[] = $key;
if ($DisplayCopyAction) print $key . "; ";
}
break;
}
if ($DisplayCopyAction)
{
print " |
\n";
}
foreach ($QueryResults as $row) {
$sql = "insert into " . $TableName . " (";
$values = ") values (";
$indx = 0;
foreach ($columns as $colName)
{
if ($indx)
{
$sql = $sql . ", ";
$values = $values . ", ";
}
$sql = $sql . $colName;
$values = $values . "'" . $row[$colName] . "'";
$indx++;
}
$sql = $sql . $values . ");";
if ($DisplayCopyAction) print "" . $sql . " |
\n";
$PDO_dbh_Target->exec($sql);
}
}
if ($DisplayCopyAction)
{
print "\n";
print "******* CopyDatabase By David Maisonave (http://axter.com) ********\n";
}
}
?>