function Do_ImportTableData($link)
{
if (count($_POST) && isset($_POST['mysql_confirm'])) {
$mysqlQ = 'SELECT ';
$sqlitQ = 'INSERT INTO ' . brackets($GLOBALS['table']) . '(';
echo '<table class="Browse"><thead><tr><td class="Browse">Transfert... </td></tr></thead><tr><td style="padding:10px">';
foreach ($_SESSION['plugin_mysql_tables'] as $key => $value) {
if (substr($key, 0, 4) == 'col_') {
$mysqlQ .= $value . ', ';
$sqlitQ .= brackets(substr($key, 4)) . ', ';
}
}
$mysqlQ = substr($mysqlQ, 0, strlen($mysqlQ) - 2);
$sqlitQ = substr($sqlitQ, 0, strlen($sqlitQ) - 2);
$mysqlQ .= ' FROM `' . $_SESSION['plugin_mysql_tables']['mysql_tables'][0] . '`;';
$sqlitQ .= ') VALUES ( %%VALUES%% );';
echo '<b>MYSQL : ' . htmlentities($mysqlQ) . '<br/>';
echo 'SQLITE : ' . htmlentities($sqlitQ) . '</b><br/><br/>';
$cnt = 0;
$err = 0;
if (!($res = mysql_query($mysqlQ, $link))) {
die(mysql_error());
} else {
sqlitem_query($GLOBALS['workDb']->connId, 'BEGIN;');
while ($row = mysql_fetch_array($res, MYSQL_NUM)) {
foreach ($row as $key => $val) {
$row[$key] = "'" . $val . "'";
}
$query = str_replace('%%VALUES%%', implode(',', $row), $sqlitQ);
if ($resInsert = sqlitem_query($GLOBALS['workDb']->connId, $query)) {
$cnt++;
echo implode(',', $row) . "<br/>";
} else {
sqlitem_query($GLOBALS['workDb']->connId, 'ROLLBACK;');
echo "<b>REQUETE EN ERREUR : <br/>" . $query . "</b><br/>";
$err = true;
break;
}
}
mysql_free_result($res);
echo '</td></tr>';
echo '</table>';
if (!$err) {
sqlitem_query($GLOBALS['workDb']->connId, 'COMMIT;');
echo "<b>{$cnt} lignes importées !</b>";
} else {
return false;
}
}
return false;
//$res;
}
echo '<form method="POST"><input type="hidden" name="mysql_confirm" value="doIt">';
echo '<table class="Browse"><thead><tr><td class="Browse">Résumé: </td></tr></thead><tr><td style="padding:10px">';
echo 'A transférer depuis la base <b>' . $_SESSION['plugin_mysql_base'] . '</b> du serveur MySQL <b>' . $_SESSION['plugin_mysql_server'] . '</b> :</br><ul>';
foreach ($_POST as $key => $value) {
if (substr($key, 0, 4) == 'col_') {
echo '<li>' . htmlentities('`' . $value . '` => ' . substr($key, 4)) . '</li>';
}
}
echo '</ul>';
echo '</td></tr>';
echo '<tr><td style="padding-bottom:10px" align="center"><input type="submit" class="button" value="Importer"></td></tr>';
echo '</table>';
echo '</form>';
}
function sqlitem_unbuffered_query($dbh, $query)
{
return sqlitem_query($dbh, $query);
}
