解析上传的 CSV 文件并将数据存储到数据库

2022-01-09 00:00:00 csv upload php

我想要使用 php 的以下功能

I want the following functionality using php

我有一个 csv 文件.每个文件对应我数据库中的一行

I have a csv file. Each file corresponds to a row in my database

有一个 html 表单可以让我选择 csv 文件.

There is a html form that will allow me to choose the csv file.

然后，一旦表单提交，我必须解析 csv 文件并将数据相应地插入到数据库中

Then once the form is submitted, I must parse the csv file and insert data into the db accordingly

我该怎么做呢?

推荐答案

读取 CSV 文件通常可以使用 fgetcsv 函数 (根据您的 CSV 文件类型，您可能需要指定分隔符、分隔符...作为参数)

Reading a CSV file can generally be done using the fgetcsv function (depending on your kind of CSV file, you might have to specify the delimiter, separator, ... as parameters)

这意味着逐行浏览文件不会比这样更难:

Which means that going through you file line by line would not be much harder than something like this :

$f = fopen('/path/to/file', 'r');
if ($f) {
    while ($line = fgetcsv($f)) {  // You might need to specify more parameters
        // deal with $line.
        // $line[0] is the first column of the file
        // $line[1] is the second column
        // ...
    }
    fclose($f);
} else {
    // error
}

(未测试，但在 fgetcsv 的手册页上给出的示例应该可以帮助您入门)

(Not tested, but example given on the manual page of fgetcsv should help you get started)

当然，您必须获得上传文件的正确路径——参见 $_FILE 超全局，以及关于 处理文件上传，了解更多信息.

Of course, you'll have to get the correct path to the uploaded file -- see the $_FILE superglobal, and the section on Handling file uploads, for more informations about that.

而且，要将数据保存到您的数据库中，您必须使用适合您的数据库引擎的 API——如果使用 MySQL，您应该使用:

And, to save the data into your database, you'll have to use the API which suits your DB engine -- if using MySQL, you should use either :

  • mysqli
    • 请注意，您应该更喜欢 mysqli，而不是旧的 mysql 扩展(不支持 MySQL >= 4.1 中添加的功能)

相关文章