ldi_table.php3

   1 <?php
   2 /* $Id$ */
   3
   4
   5 /**
   6  * This file defines the forms used to insert a textfile into a table
   7  */
   8
   9
  10 /**
  11  * Gets some core libraries and displays links
  12  */
  13 require('./tbl_properties_common.php3');
  14 $err_url   = 'ldi_table.php3' . $err_url;
  15 $url_query .= '&amp;back=ldi_table.php3';
  16 require('./tbl_properties_table_info.php3');
  17
  18
  19 /**
  20  * Displays the form
  21  */
  22 ?>
  23 <form action="ldi_check.php3" method="post" enctype="multipart/form-data">
  24     <table cellpadding="5" border="2">
  25     <tr>
  26         <td><?php echo $strLocationTextfile; ?></td>
  27         <td colspan="2"><input type="file" name="textfile" /></td>
  28     </tr>
  29 <?php
  30 if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
  31     $temp_charset = reset($cfg['AvailableCharsets']);
  32     echo '    <tr>' . "\n"
  33          . '        <td>' . $strCharsetOfFile . '</td>' . "\n"
  34          . '        <td colspan="2">' . "\n"
  35          . '            <select name="charset_of_file" size="1">' . "\n"
  36          . '                <option value="' . $temp_charset . '"';
  37     if ($temp_charset == $charset) {
  38         echo ' selected="selected"';
  39     }
  40     echo '>' . $temp_charset . '</option>' . "\n";
  41     while ($temp_charset = next($cfg['AvailableCharsets'])) {
  42         echo '                <option value="' . $temp_charset . '"';
  43         if ($temp_charset == $charset) {
  44             echo ' selected="selected"';
  45         }
  46         echo '>' . $temp_charset . '</option>' . "\n";
  47     } // end while
  48     echo '            </select>' . "\n";
  49     echo '        </td>' . "\n";
  50     echo '    </tr>';
  51 } // end if
  52 echo "\n";
  53 ?>
  54     <tr>
  55         <td><?php echo $strReplaceTable; ?></td>
  56         <td><input type="checkbox" name="replace" value="REPLACE" id="checkbox_replace" /><?php echo $strReplace; ?></td>
  57         <td><label for="checkbox_replace"><?php echo $strTheContents; ?></label></td>
  58     </tr>
  59     <tr>
  60         <td><?php echo $strFieldsTerminatedBy; ?></td>
  61         <td><input type="text" name="field_terminater" size="2" maxlength="2" value=";" /></td>
  62         <td><?php echo $strTheTerminator; ?></td>
  63     </tr>
  64     <tr>
  65         <td><?php echo $strFieldsEnclosedBy; ?></td>
  66         <td>
  67             <input type="text" name="enclosed" size="1" maxlength="1" value="&quot;" />
  68             <input type="checkbox" name="enclose_option" value="OPTIONALLY" id="checkbox_enclose_option" />
  69             <label for="checkbox_enclose_option"><?php echo $strOptionally; ?></label>
  70         </td>
  71         <td><?php echo $strOftenQuotation; ?></td>
  72     </tr>
  73     <tr>
  74         <td><?php echo $strFieldsEscapedBy; ?></td>
  75         <td><input type="text" name="escaped" size="2" maxlength="2" value="\" /></td>
  76         <td><?php echo $strOptionalControls; ?></td>
  77     </tr>
  78     <tr>
  79         <td><?php echo $strLinesTerminatedBy; ?></td>
  80         <td><input type="text" name="line_terminator" size="8" maxlength="8" value="<?php echo ((PMA_whichCrlf() == "\n") ? '\n' : '\r\n'); ?>" /></td>
  81         <td><?php echo $strCarriage; ?><br /><?php echo $strLineFeed; ?></td>
  82     </tr>
  83     <tr>
  84         <td><?php echo $strColumnNames; ?></td>
  85         <td><input type="text" name="column_name" /></td>
  86         <td><?php echo $strIfYouWish; ?></td>
  87     </tr>
  88 <?php
  89 // 2002/2/22 appended by Y.Kawada: Kanji encoding convert controls
  90 if (function_exists('PMA_set_enc_form')) {
  91     echo '    <tr>' . "\n"
  92          . '        <td>' . $strKanjiEncodConvert . '</td>' . "\n"
  93          . '        <td colspan=2>' . "\n"
  94          . PMA_set_enc_form('            ')
  95          . '        </td>' . "\n"
  96          . '    </tr>' . "\n";
  97 } // end if
  98 ?>
  99     <tr>
 100         <td colspan="3" align="center"><?php print PMA_showMySQLDocu('Reference', 'LOAD_DATA'); ?></td>
 101     </tr>
 102     <tr>
 103         <td colspan="3" align="center">
 104             <input type="hidden" name="lang" value="<?php echo $lang; ?>" />
 105             <input type="hidden" name="convcharset" value="<?php echo $convcharset; ?>" />
 106             <input type="hidden" name="server" value="<?php echo $server; ?>" />
 107             <input type="hidden" name="db" value="<?php echo $db; ?>" />
 108             <input type="hidden" name="table" value="<?php echo $table; ?>" />
 109             <input type="hidden" name="zero_rows" value="<?php echo $strTheContent; ?>" />
 110             <input type="hidden" name="goto" value="tbl_properties.php3" />
 111             <input type="hidden" name="back" value="ldi_table.php3" />
 112             <input type="hidden" name="into_table" value="<?php echo $table; ?>" />
 113             <input type="submit" name="btnLDI" value="<?php echo $strSubmit; ?>" />&nbsp;&nbsp;
 114             <input type="reset" value="<?php echo $strReset; ?>" />
 115         </td>
 116     </tr>
 117 </table>
 118 </form>
 119
 120
 121 <?php
 122 /**
 123  * Displays the footer
 124  */
 125 require('./footer.inc.php3');
 126 ?>