function listingAdherents($filename)
{
$output = "";
$rows = file($filename);
// resultat sous forme de tableau indéxé
foreach ($rows as $rows) {
$elements = explode(";", $rows);
// subdivise la chaine de caractere en plusieurs élémentsstocké dans un tb indx
if (count($elements) === 7) {
$output .= "<tr>\n <td>" . $elements[1] . "</td>\n <td>" . $elements[2] . "</td>\n <td>" . $elements[3] . "</td>\n <td>" . calculAge($elements[4]) . "</td>\n <td>" . $elements[5] . "</td>\n <td>" . $elements[6] . "</td>\n <tr>";
}
}
return $output;
}
function listingAdherents($conn)
{
$query = "SELECT * FROM adherents order by date_naissance ASC";
// requete de type select sur la table adhrents
$statement = $conn->query($query);
$output = "";
foreach ($statement as $row) {
$output .= "<tr>";
// boucle d'affichage des résultats ligne par ligne
$output .= "<td>" . $row['civilite'] . "</td>";
// utf8_encode fonction native permet l'affichage en
$output .= "<td>" . utf8_encode($row['nom']) . "</td>";
// utf8_encode fonction native permet l'affichage en
$output .= "<td>" . utf8_encode($row['prenom']) . "</td>";
// utf8_encode fonction native permet l'affichage en
$output .= "<td>" . $row['email'] . "</td>";
$output .= "<td>" . calculAge($row['date_naissance']) . "</td>";
$output .= "<td>\n <ul>\n <li><a href='adherent.php?action=voir&id=" . $row['id_adherent'] . "'>Voir</a></li>\n <li><a href='adherent.php?action=modifier&id=" . $row['id_adherent'] . "'>Modifier</a></li>\n <li><a href='#' onclick='redirectMe(" . $row['id_adherent'] . ");'>Supprimer</a></li>";
$output .= "</ul>\n </td>";
$output .= "</tr>";
}
return $output;
}
