importing csv file into mysql using php

csv-importer.php

<?php

define("DB_HOST", "localhost");
define("DB_NAME", "db_name");
define("DB_USER", "root");
define("DB_PASSWORD", "");
define("CSV_FILE", "file.csv");

$db = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . "," . DB_USER . "," . DB_PASSWORD);

if (($handle = fopen(CSV_FILE, "r")) !== FALSE) {
    
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {   // fgetcsv(file, buffer, delimiter)
        
        // query
        $sql = "INSERT INTO mytable (name,email) VALUES (:name,:email)";
        $q = $db->prepare($sql);
        $q->execute(array(':name'=>$data[0],
                            ':email'=>$data[1]));
    }
    fclose($handle);
} else {
    die("Can't open file " . CSV_FILE);
}