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); }