1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| <?php
try {
$bdd = new PDO('mysql:host=localhost; dbname=care', 'root', 'root', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_LOCAL_INFILE => true));
} catch (Exception $e) {
die('Erreur : ' . $e->getMessage());
}
$requete = ("LOAD DATA LOCAL INFILE 'monchemin\fichier.csv'
INTO TABLE tab_identification (@dummy, sexe, dateNaissance, prenom, nom, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy)
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\\r\\n'
IGNORE 1 LINES;");
echo $requete;
$prepared = $bdd->prepare($requete);
$prepared->execute();
?> |
