$intCount++;
print $intCount . ']';
$strColumns = 'pkid';
$strValues = 'NULL';
foreach ($arrResult as $strKey => $strValue) {
$strColumns .= ', `' . strtolower($strKey) . '`';
if (strlen($strValue)) {
$strValues .= ", '" . $objMySql->escape_string($strValue) . "'";
} else {
$strValues .= ', NULL';
}
}
$strSql = sprintf('INSERT INTO `%s` VALUES (%s);', strtolower($strTableName), $strValues);
$objMySql->query($strSql);
}
print " Done.\r\n";
}
$strConnectionArray = unserialize(DB_CONNECTION_3);
$objOdbc = odbc_connect(ACS_ODBC, null, null);
$objMySql = new MySqli($strConnectionArray['server'], $strConnectionArray['username']);
$objMySql->select_db($strConnectionArray['database']);
$objResult = $objMySql->query('SHOW TABLES;');
$intRowCount = $objResult->num_rows;
$intIndex = 1;
while ($strArray = $objResult->fetch_array()) {
printf('[%3s/%3s] ', $intIndex, $intRowCount);
$strTableName = $strArray[0];
ImportData($objOdbc, $objMySql, $strTableName);
$intIndex++;
}
$objMySql->close();
