使用PHP在MySQL中导入.xsl和.csv文件

似乎您遇到了定界符问题。

fgetcsv（$ handle，1000，“，”）

如果我使用定界符“;”保存文件，则可以重现此问题。因此，您可能会发现保存了哪些定界符文件并使用它：

<?php
function detectDelimiter($csvFile)
{
    $delimiters = array(
        ';' => 0,
        ',' => 0,
        "\t" => 0,
        "|" => 0
    );

    $handle = fopen($csvFile, "r");
    $firstLine = fgets($handle);
    fclose($handle); 
    foreach ($delimiters as $delimiter => &$count) {
        $count = count(str_getcsv($firstLine, $delimiter));
    }

    return array_search(max($delimiters), $delimiters);
}
#print_r(detectDelimiter('chart_column.csv'));


$handle = fopen('chart_column.csv', "r");
$delimiter = detectDelimiter('chart_column.csv');
echo "I checked file and found that its delimiter is \"$delimiter\". Will use it further. \n";

$c = 0;
while(($filesop = fgetcsv($handle, 1000, $delimiter)) !== false)
    {
        $name = $filesop[0];
        $email = $filesop[1];           
        echo "emailid = $name , pass = $email\n";
#        $sql = mysql_query("INSERT INTO selleruser (emailid, pass) VALUES ('$name','$email')");
        $c = $c + 1;
    }

结果，我得到了：

~$ cat chart_column.csv 
emailid;pass
asd;asd
fdga;ewrdf
asdf;56gfh
fgh5;fgh
dfg;dfgdf
dfg;dfgdf

~$ php delimiter.php
I checked file and found that its delimiter is ";". Will use it further. 
emailid = emailid , pass = pass
emailid = asd , pass = asd
emailid = fdga , pass = ewrdf
emailid = asdf , pass = 56gfh
emailid = fgh5 , pass = fgh
emailid = dfg , pass = dfgdf
emailid = dfg , pass = dfgdf

希望这会有所帮助。