LOAD DATA INFILE (MySQL)

mysql-load-data-infile.php

<?php
$dbHost = ''; 
$dbName = ''; 
$dbTable = ''; 
$dbUser = ''; 
$dbPassword = ''; 

$fieldSeparator = ','; 
$lineSeparator = "\n";
$csvFile = 'filename.csv';

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

try {
  $pdo = new PDO(
    'mysql:host=' . $dbHost . ';dbname=' . $dbName,
    $dbUser,
    $dbPassword,
    array(
      PDO::MYSQL_ATTR_LOCAL_INFILE => true,
      PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    )
  );
} catch (PDOException $e) {
  die('database connection failed: ' . $e->getMessage());
}

// http://dev.mysql.com/doc/refman/5.7/en/load-data.html
$affectedRows = $pdo->exec(
  'LOAD DATA LOCAL INFILE ' . $pdo->quote($csvFile) . ' ' .
  'INTO TABLE `' . $dbTable . '` ' .
  'FIELDS TERMINATED BY ' . $pdo->quote($fieldSeparator) . ' ' .
  'LINES TERMINATED BY ' . $pdo->quote($lineSeparator)
);

echo 'Loaded a total of ' . $affectedRows . ' records from csv file.';