?? ldi_check.php3
字號:
<?php/* $Id: ldi_check.php3,v 1.5 2000/07/31 13:17:26 tobias Exp $ *//* This file checks and builds the sql-string forLOAD DATA INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE table_name [FIELDS [TERMINATED BY '\t'] [OPTIONALLY] ENCLOSED BY "] [ESCAPED BY '\\' ]] [LINES TERMINATED BY '\n'] [(column_name,...)]*/if (isset($btnLDI) && ($textfile != "none")){ if(!isset($replace)) $replace = ""; $query = "LOAD DATA LOCAL INFILE '$textfile' $replace INTO TABLE $into_table "; if (isset($field_terminater)) { $query = $query . "FIELDS TERMINATED BY '".stripslashes($field_terminater)."' "; } if (isset($enclose_option) && strlen($enclose_option)>0) { $query = $query . "OPTIONALLY "; } if (strlen($enclosed)>0) { $query = $query . "ENCLOSED BY '$enclosed' "; } if (strlen($escaped)>0) { $query = $query . "ESCAPED BY '".stripslashes($escaped)."' "; } if (strlen($line_terminator)>0) { $query = $query . "LINES TERMINATED BY '".stripslashes($line_terminator)."' "; } if (strlen($column_name)>0) { $query = $query . "($column_name)"; } $sql_query = addslashes($query); require("sql.php3");}else{ require("ldi_table.php3");}?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -