Untitled
unknown
plain_text
2 years ago
1.4 kB
9
Indexable
############################################# index.php ############################################# <?php require_once('view/picture-list.php'); try { $pdo = new PDO('mysql:host=localhost;dbname=book;charset=utf8', 'root', ''); } catch (PDOException $e) { exit('Erreur : ' . $e->getMessage()); } $stmt = $pdo->prepare('SELECT * FROM photo'); $stmt->execute(); $photos = []; while ($photo = $stmt->fetchObject()) { $photos[] = $photo; } ?> ############################################# liste-photo.php ############################################# <html lang="fr"> <head> <title>Mon book</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> </head> <body> <header> <h1>Mon book</h1> </header> <section> <nav> <ul> <li><a href="/">Accueil</a></li> </ul> </nav> <article> <?php foreach ($photos as $photo): ?> <img src="photos/<?= $photo->fichier ?>" width="250" /> <h2><?= $photo->titre ?></h2> <?php endforeach; ?> </article> </section> <footer> <p>Mon book - Tous droits réservés</p> </footer> </body> </html>
Editor is loading...