php - 我需要删除此 php 代码中的标头

Question

<?php
include_once "delete.php";
?>

<?php
$databasehost = "localhost";
$databasename = "";
$databasetable = "Main_CSV_Table";
$databaseusername="contalso_OK";
$databasepassword = "";
$fieldseparator = ";";
$lineseparator = "\n";
$csvfile = "arquivo1/arquivo1.csv";




if(!file_exists($csvfile)) {
    die("File not found. Make sure you specified the correct path.");
}

try {
    $pdo = new PDO("mysql:host=$databasehost;dbname=$databasename", 
        $databaseusername, $databasepassword,
        array(
            PDO::MYSQL_ATTR_LOCAL_INFILE => true,
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
        )
    );
} catch (PDOException $e) {
    die("database connection failed: ".$e->getMessage());
}

$affectedRows = $pdo->exec("
    LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." INTO TABLE `$databasetable`
      FIELDS TERMINATED BY ".$pdo->quote($fieldseparator)."
      LINES TERMINATED BY ".$pdo->quote($lineseparator));

echo "Loaded a total of $affectedRows records from this csv file.\n";

?>

我需要删除此 php 代码中的标头。我需要从 csv 文件中删除第一行吗？enter code here Alguma 有没有人建议删除标题

在此处输入图像描述

标签： php

Answer 1

见：https ://dev.mysql.com/doc/refman/8.0/en/load-data.html

$affectedRows = $pdo->exec("
    LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." INTO TABLE `$databasetable`
      FIELDS TERMINATED BY ".$pdo->quote($fieldseparator)."
      LINES TERMINATED BY ".$pdo->quote($lineseparator)."
      IGNORE 1 LINES");