上传数据库中的csv文件,但最后一个文件添加了一个空白数据


upload csv file in database but last filed add one more data blank

我上传了数据库中的csv文件,但当我上传csv文件并显示数据表时,它会在表中多上传一行。就像我上传了10个数据,但在数据表中插入了11行。

 // path where your CSV file is located
define('csvfile/',
        'plivo/dialer/csvfile/');
  // Name of your CSV file
$csv_file = $target_dir . "$file";
if (($handle = fopen($csv_file,
        "r")) !== FALSE) {
    fgetcsv($handle);
    while (($data = fgetcsv($handle,
    1000,
    ",")) !== FALSE) {
        $num = count($data);
        for ($c = 0;
                $c < $num;
                $c++) {
            $col[$c] = $data[$c];
        }
       echo '<br>'. $col1 = $col[0];
        echo 'data'.$col1.'<br>';
        if($col1 != ' ' || $col1 != NULL){
            // SQL Query to insert data into DataBase
       $query = "INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('$caller_id','" . $col1 . "','$play_url','$row_id')";
        print_r("INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('$caller_id','" . $col1 . "','$play_url','$row_id')");
        $s = mysql_query($query);
        if ($s) {
            echo 'pass';
            header("location:dashboard.php");
        } else {
            echo 'fail<br>';
        }
        }            
    }
    fclose($handle);
}

当我打印查询显示

 1data1
 INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','1','www.test.com','15')
2data2
INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','2','www.test.com','15')
3data3
INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','3','www.test.com','15')
4data4
INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','4','www.test.com','15')
5data5
INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','5','www.test.com','15')
data
INSERT INTO callblast(`callerid`, `phoneno`, `playurl`,`campaignid`) VALUES('9988776655','','www.test.com','15')

最后的数据是这样添加的

数据库中更多行加载项的问题是什么。

请帮忙。

谢谢。

您应该这样检查$col1 != ' 'trim($col1) != '',因为文件的最后一行包含EOF/EOL和更多的空格/制表符。