Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/phpmyadmin/phpmyadmin.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'libraries/import/ldi.php')
-rw-r--r--libraries/import/ldi.php108
1 files changed, 0 insertions, 108 deletions
diff --git a/libraries/import/ldi.php b/libraries/import/ldi.php
deleted file mode 100644
index 77ba0c1b9c..0000000000
--- a/libraries/import/ldi.php
+++ /dev/null
@@ -1,108 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * CSV import plugin for phpMyAdmin
- *
- * @version $Id$
- * @package phpMyAdmin-Import
- */
-if (! defined('PHPMYADMIN')) {
- exit;
-}
-
-/**
- *
- */
-if ($plugin_param !== 'table') {
- return;
-}
-
-if (isset($plugin_list)) {
- if ($GLOBALS['cfg']['Import']['ldi_local_option'] == 'auto') {
- $GLOBALS['cfg']['Import']['ldi_local_option'] = FALSE;
-
- $result = PMA_DBI_try_query('SHOW VARIABLES LIKE \'local\\_infile\';');
- if ($result != FALSE && PMA_DBI_num_rows($result) > 0) {
- $tmp = PMA_DBI_fetch_row($result);
- if ($tmp[1] == 'ON') {
- $GLOBALS['cfg']['Import']['ldi_local_option'] = TRUE;
- }
- }
- PMA_DBI_free_result($result);
- unset($result);
- }
- $plugin_list['ldi'] = array(
- 'text' => 'strLDI',
- 'extension' => 'ldi', // This is nonsense, however we want to default to our parser for csv
- 'options' => array(
- array('type' => 'bool', 'name' => 'replace', 'text' => 'strReplaceTable'),
- array('type' => 'bool', 'name' => 'ignore', 'text' => 'strIgnoreDuplicates'),
- array('type' => 'text', 'name' => 'terminated', 'text' => 'strFieldsTerminatedBy', 'size' => 2, 'len' => 2),
- array('type' => 'text', 'name' => 'enclosed', 'text' => 'strFieldsEnclosedBy', 'size' => 2, 'len' => 2),
- array('type' => 'text', 'name' => 'escaped', 'text' => 'strFieldsEscapedBy', 'size' => 2, 'len' => 2),
- array('type' => 'text', 'name' => 'new_line', 'text' => 'strLinesTerminatedBy', 'size' => 2),
- array('type' => 'text', 'name' => 'columns', 'text' => 'strColumnNames'),
- array('type' => 'bool', 'name' => 'local_option', 'text' => 'strLDILocal'),
- ),
- 'options_text' => 'strOptions',
- );
- /* We do not define function when plugin is just queried for information above */
- return;
-}
-
-if ($import_file == 'none' || $compression != 'none' || $charset_conversion) {
- // We handle only some kind of data!
- $message = PMA_Message::error('strInvalidLDIImport');
- $error = TRUE;
- return;
-}
-
-$sql = 'LOAD DATA';
-if (isset($ldi_local_option)) {
- $sql .= ' LOCAL';
-}
-$sql .= ' INFILE \'' . PMA_sqlAddslashes($import_file) . '\'';
-if (isset($ldi_replace)) {
- $sql .= ' REPLACE';
-} elseif (isset($ldi_ignore)) {
- $sql .= ' IGNORE';
-}
-$sql .= ' INTO TABLE ' . PMA_backquote($table);
-
-if (strlen($ldi_terminated) > 0) {
- $sql .= ' FIELDS TERMINATED BY \'' . $ldi_terminated . '\'';
-}
-if (strlen($ldi_enclosed) > 0) {
- $sql .= ' ENCLOSED BY \'' . PMA_sqlAddslashes($ldi_enclosed) . '\'';
-}
-if (strlen($ldi_escaped) > 0) {
- $sql .= ' ESCAPED BY \'' . PMA_sqlAddslashes($ldi_escaped) . '\'';
-}
-if (strlen($ldi_new_line) > 0){
- if ($ldi_new_line == 'auto') {
- $ldi_new_line = PMA_whichCrlf() == "\n" ? '\n' : '\r\n';
- }
- $sql .= ' LINES TERMINATED BY \'' . $ldi_new_line . '\'';
-}
-if ($skip_queries > 0) {
- $sql .= ' IGNORE ' . $skip_queries . ' LINES';
- $skip_queries = 0;
-}
-if (strlen($ldi_columns) > 0) {
- $sql .= ' (';
- $tmp = split(',( ?)', $ldi_columns);
- $cnt_tmp = count($tmp);
- for ($i = 0; $i < $cnt_tmp; $i++) {
- if ($i > 0) {
- $sql .= ', ';
- }
- /* Trim also `, if user already included backquoted fields */
- $sql .= PMA_backquote(trim($tmp[$i], " \t\r\n\0\x0B`"));
- } // end for
- $sql .= ')';
-}
-
-PMA_importRunQuery($sql, $sql);
-PMA_importRunQuery();
-$finished = TRUE;
-?>