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...