首页 > 解决方案 > 如何删除第一个数组值PHP

问题描述

我试图导出 csv 文件,所以我得到了一个像

Array
(
    [0] => Name
    [1] => Emp Code
    [2] => Designation
    [3] => Basic
    [4] => DA
    [5] => HRA
    [6] => CCA
    [7] => Conveyance
    [8] => Others
    [9] => Mgt Contr PF
    [10] => PL Encashment
    [11] => Income Tax
    [12] => Prof Tax
    [13] => Welfare Fund
)
Array
(
    [0] => Li
    [1] => 60
    [2] => Web Designer
    [3] => 14400
    [4] => 9600
    [5] => 4800
    [6] => 4800
    [7] => 1600
    [8] => 12800
    [9] => 800
    [10] => 0
    [11] => 0
    [12] => 0
    [13] => 20
)

这里的第一个数组值是 csv 文件列名,所以我不想将它们保存在数据库中。

这是我的代码

while (($data = fgetcsv($file, 1000, ",")) !== FALSE) {
                            $num = count($data);

                            for ($c=0; $c < $num; $c++) {
                                $importData_arr[$i][] = $data[$c];
                            }
                            $i++;
                        }
                          fclose($file);
                            $skip = 0;
                             foreach($importData_arr as $data){
                                 echo '<pre>';print_r($data);
                             }
        }

如何从数组中删除列名。请帮我

标签: phpcsv

解决方案


您可以通过在循环之前阅读第一行来跳过它。您还可以大大简化您的代码:

fgets($file);
while (($data = fgetcsv($file, 1000, ",")) !== FALSE) {
    $importData_arr[] = $data;                        
}
fclose($file);
$skip = 0;
foreach($importData_arr as $data){
    echo '<pre>';print_r($data);
}

推荐阅读