index.php

<?php 
    include_once 'header.php';
    include_once 'db.php';

    $oeuvres = $pdo->query('SELECT * FROM oeuvre')->fetchAll();

?>
    <main>
        <div id="liste-oeuvres">
            <?php foreach ($oeuvres as $oeuvre): ?>
            <article class="oeuvre">
                <a href="oeuvre.php?id=<?php echo $oeuvre['id_oeuvre']; ?>">
                    <img src="<?php echo $oeuvre['lien_oeuvre']; ?>" alt="<?php echo $oeuvre['titre']; ?>">
                    <h2><?php echo $oeuvre['titre']; ?></h2>
                    <p class="description"><?php echo $oeuvre['artiste']; ?></p>
                </a>
            </article>
            <?php endforeach; ?>
            </article>
            
        </div>
    </main>
<?php include 'footer.php'; ?>