导入CSV，排除第一行

只设置一个变量$i = 0然后只在$i = 1或更多时插入

if (isset($_POST['submit'])) {
    $i=0; //so we can skip first row
    if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
        echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
        echo "<h2>Displaying contents:</h2>";
        readfile($_FILES['filename']['tmp_name']);
    }
    //Import uploaded file to Database
    $handle = fopen($_FILES['filename']['tmp_name'], "r");
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        if($i>0) {
            $import="INSERT into tictoc(employee,taskname,tasktime,sessiontime,sessionstart,sessionend,sessionnotes) values('".$userinfo['first_name']." ".$userinfo['last_name']."','$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')";
            mysql_query($import) or die(mysql_error());
        }
        $i++;
    }
    fclose($handle);
    print "Import done";
}

您可以简单地使用MySQL的LOAD DATA INFILE命令，这将比将CSV解析为PHP快得多，为每条记录构建INSERT语句，将其作为字符串提交给MySQL，并让MySQL为SQL解析所述字符串（存在SQL注入的风险）：

LOAD DATA INFILE ? INTO TABLE tictoc
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
(tasktime, sessiontime, sessionstart, sessionend, sessionnotes)
SET employee = ?, taskname = ?

使用PDO:

$dbh = new PDO('mysql:dbname='.$dbname, $username, $password);
if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
  $qry = $dbh->prepare('
    LOAD DATA INFILE :filepath INTO TABLE tictoc
    FIELDS TERMINATED BY '','' OPTIONALLY ENCLOSED BY ''"''
    IGNORE 1 LINES
    (tasktime, sessiontime, sessionstart, sessionend, sessionnotes)
    SET employee = :employee, taskname = :taskname
  ');
  $qry->execute(array(
    ':filepath' => $_FILES['filename']['tmp_name'],
    ':employee' => $userinfo['first_name'],
    ':taskname' => $userinfo['last_name']
  ));
}

如果你喜欢，也许你可以用这种方式：

$i=0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $i++;
    if($i==1) continue;
    $import="INSERT into tictoc(employee,taskname,tasktime,sessiontime,sessionstart,sessionend,sessionnotes) values('".$userinfo['first_name']." ".$userinfo['last_name']."','$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')";
     mysql_query($import) or die(mysql_error());
}

不需要任何变量。它比这个简单得多。这里有一个解决方案，它需要最少的外来代码，并且运行良好。尝试投放：

$headers = fgetcsv($handle, 1000, ",");

在while（）循环获取CSV数据之前。这会抓取标头，但不会将它们插入数据库。while循环开始后，第一行已经返回，因此将它们排除在mysql插入之外。除此之外，似乎还需要标头，因此这也解决了这个问题。

所以最后

if (isset($_POST['submit'])) {
    if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
        echo "<h1>" . "File " . $_FILES['filename']['name'] . " uploaded successfully." . "</h1>";
        echo "<h2>Displaying contents:</h2>";
        readfile($_FILES['filename']['tmp_name']);
    }
    //Import uploaded file to Database
    $handle = fopen($_FILES['filename']['tmp_name'], "r");
    //Grab the headers before doing insertion
    $headers = fgetcsv($handle, 1000, ",");
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $import = "INSERT into tictoc(employee,taskname,tasktime,sessiontime,sessionstart,sessionend,sessionnotes) values('" . $userinfo['first_name'] . " " . $userinfo['last_name'] . "','$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')";
        mysql_query($import) or die(mysql_error());
    }
    fclose($handle);
    print "Import done";
}

你可以试试这个：

array_shift($data);

我已经实现了这段代码，它是经过测试的代码。我认为这是非常有用的全

你必须遵循一些规则：-

1.根据数据库表名创建csv文件（例如：数据库表名为users，csv应为users.csv）

2.您的csv文件的第一行应该是启动数据输入后的数据库表字段名称（例如：Id、名称等）

3.您可以从以下位置下载数据源类：-http://code.google.com/p/php-csv-parser/因为我在下面的代码中有require_one'CSV/DataSource.php'；

<?php
ini_set('memory_limit','512M');
$dbhost = "localhost";
$dbname = "excel_import";
$dbuser = "root";
$dbpass = "";
$conn=mysql_connect ($dbhost, $dbuser, $dbpass) or die ("I cannot connect to the database because: " . mysql_error());
mysql_select_db($dbname) or die("Unable to select database because: " . mysql_error());

require_once 'CSV/DataSource.php';

$filename = "users.csv";
$ext = explode(".",$filename);
$path = "uploads/".$filename;
$dbtable = $ext[0];
import_csv($dbtable, $path);

function import_csv($dbtable, $csv_file_name_with_path)
{
    $csv = new File_CSV_DataSource;
    $csv->load($csv_file_name_with_path);
    $csvData = $csv->connect();
    $res='';
    foreach($csvData  as $key)
    {
        $myKey ='';
        $myVal='';
        foreach($key as $k=>$v)
        {
            $myKey .=$k.',';
            $myVal .="'".$v."',";
          }
        $myKey = substr($myKey, 0, -1);
        $myVal = substr($myVal, 0, -1); 
        $query="insert into ".$dbtable." ($myKey)values($myVal)";
        $res=  mysql_query($query);
    }
    if($res ==1)
    {
                echo "record successfully Import.";
    }else{
                echo "record not successfully Import.";
    }
}

在while循环之前声明一个变量

$row=1;

则在while循环中，将此条件放入

if($row==1){
   $row++; 
   continue;
}