Mise à jour de formulaire

<?php
//----------------------------------------------//
//Affichage des erreurs php
//----------------------------------------------//
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

//----------------------------------------------//
//fonctions
//----------------------------------------------//
  // Connexion à la bdd
  function getDb(){
      $serveur = "localhost";
      $dbname = "#";
      $user = "root";
      $pass = ""; 
    try{
      //On se connecte à la BDD
      $dbco = new PDO("mysql:host=$serveur;dbname=$dbname",$user,$pass);
      $dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      $dbco->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    } catch(PDOException $e) {
        die('Erreur : ' . $e->getMessage());
    }
    return $dbco;
  }
  
  function getAll(){
    $bdd = getDb();
    $sql='select * from ...'; 
    //Execution de la requete
    try{
      $requete = $bdd -> prepare($sql) ;
      $requete->execute() ;
      return $requete->fetchAll(); // on retourne un array avec tous les résultats
    }catch(Exception $e){
      // en cas d'erreur :
       echo " Erreur ! ".$e->getMessage();     
    }
  }
  
  
  function updCommande($date_reception_log,$date_transmission_at,$peniche,$lesNumeroCompte=array()){
    $bdd = getDb();
    
    $liste = join("','",$lesNumeroCompte);
    
    $sql = "UPDATE commande
            SET date_reception_log=:date_reception_log, 
                date_transmission_at=:date_transmission_at, 
                peniche=:peniche
            WHERE numerocompte in ('" .$liste . "')" ;
            
    try{
      $sth = $dbco->prepare($sql);
      $sth->bindParam(':date_reception_log',$date_reception_log,PDO::PARAM_STR);
      $sth->bindParam(':date_transmission_at',$date_transmission_at,PDO::PARAM_STR);
      $sth->bindParam(':peniche',$peniche,PDO::PARAM_STR);
      return $sth->execute();
    }catch(Exception $e){
       echo " Erreur ! ".$e->getMessage();     
    } 
          
  }  
  

//----------------------------------------------//
//récupération des variables
//----------------------------------------------//
 $date_reception = !empty($_POST["date_reception"]) ? $_POST["date_reception"] : '';
 $date_transmission = !empty($_POST["date_transmission"]) ? $_POST["date_transmission"] : '';
 $peniche = !empty($_POST["peniche"]) ? $_POST["peniche"] : '';
 $date_reception_log = !empty($_POST["date_reception_log"]) ? $_POST["date_reception_log"] : '';
 $date_reception = !empty($_POST["date_reception"]) ? $_POST["date_reception"] : '';
 $date_transmission_at = !empty($_POST["date_transmission_at"]) ? $_POST["date_transmission_at"] : '';
 $lesNumeroCompte =  !empty($_POST["listeCmd"]) ? $_POST["listeCmd"] : '';; 
 
//----------------------------------------------//
// Traitement du formulaire
//----------------------------------------------//
  
  //le temps des tests :
  echo "<pre>Variables POST : <br>";
  print_r($_POST);
  echo "</pre>";


if(isset($_POST['Envoyer']))  {
     echo 'date 1 ' .$date_reception;
     echo 'date 2 ' .$date_transmission;
     echo 'peniche ' .$peniche;

    if(!isset($date_reception_log) || $date_reception==''){
      echo '<script>alert("Veuillez saisir la date reception")</script>';
    }
    
    if(!isset($date_transmission_at) || $date_transmission_at ==''){
      echo '<script>alert("Veuillez saisir la date transmission")</script>';
    }
    
    if(!isset($peniche) || $peniche == ''){
      echo '<script>alert("Veuillez saisir la péniche SVP")</script>';
    }
     
    if(empty($lesNumeroCompte)){
      echo '<script>alert("Veuillez choisir une commande")</script>';
    } 
  
    if( updCommande($date_reception_log,$date_transmission_at,$peniche,$lesNumeroCompte)) {
      //On renvoie l'utilisateur vers la page de remerciement
      //header("Location:espacelogistique.php"); // on desactive la redirection le temps des tests
      echo "Update OK !";
      exit(); //toujours mettre un exit après une redirection.
   }
}

?>
<!DOCTYPE html>
<html>
<head>
 <meta charset="utf-8"/>
 <title>Recherche</title>
 <style>
  table{width:100%;border-collapse:collapse}
  table tr,table th,table td{border:1px solid black;}
  table tr td{text-align:center;padding:1em;}
 </style>
</head>
<body>
 <?php include('connection_database.php');?>
 <form method='post' action='#'>
  <label for="date_reception_log">Date réception : </label>
   <input type='date' placeholder='date_reception' name="date_reception"/>
  <label for="date_transmission">Date transmission : </label>
   <input type='date' placeholder='date_transmission' name="date_transmission"/>
        
   
   <input type='submit' value="Envoyer" name="Envoyer"/>
 <table>
  <thead>
   <tr>
      <th>Choisir</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>
   <th>#</th>

   </th>
   
   </tr>
  </thead>
  <tbody>
   <?php
    
    $resultats = getAll();
    
    if(!empty($resultats) ) {
      foreach( $resultats as $d){
     ?>
      <tr>
         <td><input type='checkbox' name='listeCmd[]' value="<?php echo $d['numerocompte']; ?>"></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td>
        <td><?=$d['']?></td><td>
        <input type='varchar' id="peniche_<?php echo $d['peniche']; ?>" name="peniche" value="<?php echo $d['peniche']; ?>"></td>
      </tr>
     <?php
     }
    } else {
      echo '<tr><td colspan=4>aucun résultat trouvé</td></tr>'.
    }

   ?>
  </tbody>
 </table>
 </form>
 </body>
</html>