php - 将 csv 导入到 mysql 数据库表期间找不到文件

Question

我的网站的文件夹结构如下:www.mysite.it/site/scripts。

在此路径中有两个文件:import.php 和 tabella.csv。

tabella.csv 是一个 CSV 文件，如下所示:

"2016-09-02", 100.01, 4005.09, 5000, 1.09, 120.09, 100.5, 200.77
"2016-09-03", 150.01, 4205.09, 5600, 1.10, 150.09, 300.5,300.77

import.php 是执行导入的 PHP 脚本，它是一个如下所示的文件:

<?php

    $csvFile = "../scripts/tabella.csv";

    $db = @mysql_connect('****', '****', '****');
    @mysql_select_db('******');

    $query = 'LOAD DATA LOCAL INFILE \' '. $csvFile .' \' INTO TABLE rame
        FIELDS TERMINATED BY \',\'
        LINES TERMINATED BY \'\r\n\' 
        IGNORE 1 LINES
        (
            giorno,
            lmedollton,
            changedolleuro,
            euroton,
            lmesterton,
            delnotiz,
            girm,
            sgm
        )';
    if(!mysql_query($query)){
        die(mysql_error());
    }

    mysql_close($db);

?>

错误是“找不到文件”:我尝试使用“tabella.csv”和 realpath(使用 realpath PHP 函数)，但错误始终相同。我必须分配给 $csvFile 变量的正确字符串是什么？你能帮我一下吗？

Answer 1

您应该提供 csv 文件的绝对路径，例如

$csvFile = "/var/www/htdocs/site/scripts/tabella.csv"

因为mysql将无法解析相对于apache httpdoc-root目录的路径。另请参阅Mysql-Doc :

If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client program was started.