导入数据时遇到问题 [英] getting problem while importing data

问题描述

这是我的代码..

here is my code..

$file_name=$_FILES["file"]["name"];
echo "Your have Uploaded Successfully "             . $file_name."<br/>";
$file_type=$_FILES["file"]["type"];
//echo $file_type."<br/>";
$location=C:\\xampp\\mysql\\data\\import2\\"
move_uploaded_file($_FILES["file"]["tmp_name"],$location . $_FILES["file"]["name"]);
connect_db();
$q="LOAD DATA LOCAL INFILE '$file_name' INTO TABLE import
                FIELDS TERMINATED BY ','
                LINES TERMINATED BY '\n'
                IGNORE 1 LINES
                (srno,@date,@mobno,@state,@type,@telecaller)
                SET srno=srno,date=@date,mobno=@mobno,state=@state,type=@type,telecaller=@telecaller";

推荐答案

file_name =

file_name=

_FILES ["file"] ["name"]; 回声您已成功上传".

_FILES["file"]["name"]; echo "Your have Uploaded Successfully " .

文件名." < br/ > ;

这篇关于导入数据时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！