Projet

<?php

    include '../utilsession.php';
    startSession();

include_once('../utilbdd.php');

 if (isset($_GET['Id_piec']) )
 {
   $Id_piec=stripslashes($_GET['Id_piec']);
  $connexion = connexion();

  $Sup = $connexion->prepare ("delete piece.Id_piec, groupe_piece.designation_groupe, piece.Designation, facture.Num_fac, piece.Stock, facture_piece.prix "
                                            . "FROM piece "
                                            . "INNER JOIN facture_piece ON (piece.Id_piec = facture_piece.Id_piec) "
                                            . "INNER JOIN groupe_piece ON (piece.id_groupe_piece = groupe_piece.id_groupe_piece) "
                                            . "INNER JOIN facture ON (facture.Num_fac = facture_piece.Num_fac) where piece.Id_piec= '".$Id_piec."'");

       
        $Sup->execute();

        $Sup->closecursor();




echo "<a href='pieces.php' rel="nofollow noopener noreferrer" target="_blank">Liste de voiture</a>";
}

else

{

echo 'Veuillez renseigner le numéro de piece';

}
?>