Question

I am writing the following script up import a csv file into a mysql database. The user has to log in first and their security rights to upload are checked by another file, if this evaluates to true, the file can then be uploaded by the file up-loader which will only allow csv s to be uploaded and then the following part imports the file.

我在下文中采用正确的守则吗? 而且,如果真的放胎错,就有可能拒绝进口? 要求将这一特征作为这一项目的一项要求,因此,我只是试图使之成为可能的辅助证据。

<?php
$uploadedcsv =  ./uploads/ .$filename.  ;
$sql =  LOAD DATA LOCAL INFILE " .$uploadedcsv. " INTO TABLE  .$table.  FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" IGNORE 1 LINES  or die(mysql_error());
?>

Answer 1

Unless you are 100% rely on the user and it seems that you are not, it will be good not to blindly import uploaded file, but first to check if it s correct.

为此,您必须开放并阅读文档,例如fgetcsv,并逐条核对数据的一致性。

你可以在网上找到许多例子。

这里只是一些:

Answer 2

可以通过MySQL进行,但是,由于缺席,LOAD DATA INFILE的希望形式不同于CSV。文件:

If you specify no FIELDS or LINES clause, the defaults are the same as if you had written this:

FIELDS TERMINATED BY  	  ENCLOSED BY    ESCAPED BY  \ 
LINES TERMINATED BY  
  STARTING BY

文件说明,在处理CSV档案时:

LOAD DATA INFILE  data.txt  INTO TABLE tbl_name
FIELDS TERMINATED BY  ,  ENCLOSED BY  " 
LINES TERMINATED BY  
 
IGNORE 1 LINES;

Which is an example of dealing with comma separated values enclosed by "" and line-separated by

To use this to import a file, make sure your statement matches the CSV format of your upload files and you can import via this manner.

友情链接