Afficher une liste de participants

function participant(){
    if(isset($_POST['nomParticipant']) && isset($_POST['prenomParticipant']) && isset($_POST['fonctionParticipant']) && isset($_POST['serviceParticipant'])) {
        $nomParticipant = $_POST['nomParticipant'];
        $prenomParticipant = $_POST['prenomParticipant'];
        $fonctionParticipant = $_POST['fonctionParticipant'];
        $serviceParticipant = $_POST['serviceParticipant'];

        if(empty($nomParticipant)){
            header("Location: index_admin.php?error=Nom du participant requis");
            exit();
        } else {
            $query = "INSERT INTO participant (nomParticipant, prenomParticipant, fonctionParticipant, serviceParticipant) VALUES ('$nomParticipant', '$prenomParticipant', '$fonctionParticipant', '$serviceParticipant')";
            if($sql = $this->conn->query($query)) {

                echo "<div class='card w-25' style='padding:20px;color: #FFBC42; margin:auto;'>
                <h5 style='text-align:center'>
                <i class='fas fa-check-circle'></i>  <b><q> ".$_POST['nomParticipant']." ".$_POST['prenomParticipant']." </q> 
                a bien été enregistré pour cette formation</b></h5>
                <a href='../admin/index_admin.php' style='color:grey;text-align:center'>Retour vers la page d'accueil</a>
                </div>";
                exit();
            } else {
                header("Location:index_admin.php");
                exit();
            }
        }
    }
    
}

public function getAllParticipant(){
    $data = null;
    $query = "SELECT P.participantID
    ,P.programmeChoisi
    ,P.nomParticipant
    ,P.prenomParticipant
    ,P.fonctionParticipant
    ,P.serviceParticipant
    ,F.programme 
    FROM participant P
    LEFT JOIN forma F  ON P.programmeChoisi = F.programme
    ORDER BY nomParticipant ASC";
    if($sql = $this->conn->query($query)) {
        while($row = mysqli_fetch_assoc($sql)) {
            $data[] = $row;
        }
    }
    return $data;
}   

<td style="text-align:center;vertical-align:middle"><a href="#staticBackdropParticipant">
                    <button type="button" class="btn btn-secondary" data-bs-toggle="modal" data-bs-target="#staticBackdropParticipant">
                    Afficher
                    </button>
 </td>

  <!-- Modal pour afficher les Participant -->
<div class="modal fade" id="staticBackdropParticipant" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
                            <div class="modal-dialog modal-xl modal-dialog-centered modal-dialog-scrollable">
                                <div style="margin-top:120px;width:800px" class="modal-content">
                                    <div class="modal-header">
                                        <h5 class="modal-title" id="staticBackdropLabel" style="color:rgb(40, 87, 216);"><b>Liste des Participants</b> </h5>
                                        <a href="#"><button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button></a>
                                    </div>

                                    <div class="modal-body">
                                        <table class="table table-bordered table-striped table-hover">
                                            <thead>
                                                <tr style="color:white;background:#45509E;text-align:center">
                                                <th scope="col">Nom</th>
                                                <th scope="col">Prénom</th>
                                                <th scope="col">Fonction</th>
                                                <th scope="col">Service</th>
                                                </tr>
                                            </thead>
                                            <tbody>

                                            <?php if(!empty($rowsallParticipant)) {
                                            foreach($rowsallParticipant as $rowParticipant) {?> 
                                                <tr>
                                                    <td><?php echo $rowParticipant['nomParticipant']?></td>
                                                    <td><?php echo $rowParticipant['prenomParticipant']?></td>
                                                    <td><?php echo $rowParticipant['fonctionParticipant']?></td>
                                                    <td><?php echo $rowParticipant['serviceParticipant']?></td>
                                                </tr>
                                                <?php }
                                                }else {
                                                    exit();
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>

                                    <div class="modal-footer">
                                        <a href="#"><button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Fermer</button></a>
                                    </div>
                                </div>
                            </div>
            </div>