Agenda

Planning des manifestations

Documents financiers connect_error) { die("Erreur de connexion MySQL : " . $conn->connect_error); } // Annees a afficher $annees = range(2026, 2019); foreach ($annees as $annee) { $sql = "SELECT finance_num, finance_nom FROM finances WHERE YEAR(finance_date) = ? ORDER BY finance_num ASC"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $annee); $stmt->execute(); $result = $stmt->get_result(); // On n'affiche le titre que si l'annee a des documents if ($result->num_rows === 0) { $stmt->close(); continue; } echo '

Documents ' . htmlspecialchars((string) $annee) . '

'; echo '

'; while ($donnees = $result->fetch_assoc()) { $lien = "http://www.ville-tonnerre.com/affpdf2.php?sel1=/finances/" . rawurlencode($donnees['finance_num']); echo '

'; echo '

'; echo ''; echo '

' . htmlspecialchars($donnees['finance_num']) . '

'; echo '

' . htmlspecialchars($donnees['finance_nom']) . '

'; echo ''; echo '

'; echo '

'; echo 'Consulter'; echo '

'; echo '

'; } echo '

'; $stmt->close(); } $conn->close(); ?>