1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| $file_csv = $_FILES['monfichier']['tmp_name'];
echo 'file CSV : '.$file_csv;
$con = 'mysql:host=hhhhhhhh;dbname=bbbbbbbb;charset=utf8'; //;port=3306
try {
$pdo = new \PDO($con, 'bbbbbbbb' , 'PW', array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_PERSISTENT => true, PDO::MYSQL_ATTR_LOCAL_INFILE => true));
// $conn = new \PDO("mysql:host=$server;dbname=$database;", "$user", "$password", array(PDO::MYSQL_ATTR_LOCAL_INFILE => true,));
echo "<br />Connexion OK ! ";
}
catch (PDOException $exception) {
exit('<br />Erreur de connexion à la base de données');
}
$sql = "LOAD DATA LOCAL INFILE '$file_csv'
INTO TABLE myTable
FIELDS
TERMINATED BY ';'
ENCLOSED BY ''
LINES TERMINATED BY '\\r\\n'
(dateOp, Libelle)";
echo "Requete : ".$sql;
$prepared = $pdo->prepare($sql);
$prepared->execute(); |
Partager