(double) probleme pour inserer donnes dans bdd

  <?php
$conn = mysqli_connect("localhost", "..............", "...............", "....................")
    or die("Impossible de se connecter : " . mysqli_error());
echo 'Connexion réussie';

?>

 require_once("db_connect.php");
  foreach ( $the_big_array as $ligne) {  
   foreach ( $ligne as $value) {   
   $data_ = [
   'name' => $value,
   'description' => $value,
   'price' => $value,
   ];
   $sql = "INSERT INTO produits (name,description,price)  VALUES (:name, :description, :price)";
   $stmt= $conn->prepare($sql);
   $stmt->execute($data_);

   echo'<br/>value <br/>';
   echo $value;

   }   //fin foreach 
  }   //fin foreach 
}     //fin if isset
 
   
     echo '<br/>sql <br/>';
     echo $sql;

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
$filename = 'amazon-fours.csv';
 
// The nested array to hold all the arrays
$the_big_array = [];
 
// Open the file for reading
if (($h = fopen("{$filename}", "r")) !== FALSE)
 {
 // Each line in the file is converted into an individual array that we call $data
 // The items of the array are comma separated
 include("db_connect.php");
 while (($data = fgetcsv($h, 0, ";")) !== FALSE)
  {
  // Each individual array is being pushed into the nested array
  $the_big_array[] = $data;
  foreach ($the_big_array as $table) 
  {
   foreach ($table as $contenu ) 
   {
    /*
    // module d'enregistrement #1
    mysqli_query($conn,'LOAD DATA LOCAL INFILE \'amazon-fours.csv\' INTO TABLE produits;
    FIELDS TERMINATED BY \';\'
    ENCLOSED BY \'"\'
    LINES TERMINATED BY \'\n\' ')
    or die("Erreur mise à jour table : ".mysqli_error($conn));

    
/   // module d'enregistrement #2   /*   $sql = <<<SQL   INSERT INTO produits   SET    ':name' = $contenu[0],   ':description' = $contenu[1],   ':price' = $contenu[2]   SQL ;   $conn->exec($sql);   */      // module d'enregistrement #3   $name = $contenu[0];   $description = $contenu[1];   $price = $contenu[2];   $req = $conn ->prepare('INSERT INTO produits (name,description,price) VALUES ($name,$description)');   $req->execute([$conn]);      } //fin foreach #2  } // fin foreach #1  } //fin while} // fin if $sh/* echo '<br/>name : <br/> '; echo $name ; echo '<br/>description : <br/>'; echo $description ; echo '<br/>price : <br/>'; echo $price ; echo '<br/>req : <br/>'; print_r($req); */  /* // afficher le code echo "<pre>"; var_dump($the_big_array); echo "</pre>"; */?>

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

try
 {
 $host = 'mysql:dbname=................;host=127.0.0.1'; 
 $dsn = '............................."
 $user = '............................';
 $password = '...................';
 $conn = new PDO($host, $user, $password);
 // Activation des erreurs PDO
 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
}
catch(PDOException $e) {
die('Erreur : ' . $e->getMessage());
}

<?php

error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

//Connexion à la bdd ( en PDO )
require_once("db_connect.php");

$filename = 'amazon-fours.csv';

// Open the file for reading
if (($h = fopen("{$filename}", "r")) !== FALSE) {
// Each line in the file is converted into an individual array that we call $row
// The items of the array are comma separated

  while (($row = fgetcsv($h, 0, ";")) !== FALSE) {

    //Si l'insert ne fonctionne toujours pas, merci de décommenter les lignes ci-dessous et de nous montrer ce que ça donne
    // echo '<br>';
    // print_r($row);
    
    //données contenues dans la ligne du fichier csv  
    $datas = [
        ':name' => !empty($row[0]) ? $row[0] : "",
        ':description' => !empty($row[1]) ? $row[1] : "",
        ':price' => !empty($row[2]) ? $row[2] : "",
    ];

    $sql = "INSERT INTO produits (name,description,price)  VALUES (:name, :description, :price)";
    //Execution de la requete
    try {
      $requete = $conn->prepare($sql);
      $requete->execute($datas);
    } catch (Exception $e) {
      // en cas d'erreur :
      echo "<br>Erreur ! " . $e->getMessage();
      echo "<br>Les datas :<br>";
      print_r($datas);
      exit;
    }
  }
}