Show Code:
pieces-read.php
<?php include 'session.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title>Alexandria</title>
<link href="style1.css" rel="stylesheet" type="text/css">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyANqabCeXfuvJLMFOmswsDin9bAJzOSGF8"></script>
<script src="alexandria-maps.js"></script>
<body>
<?php include 'nav.php'; ?>
<?php include 'db-connect.php'; ?>
<main>
<div id="piece-container">
<?php
$sql="SELECT * FROM t_pieces JOIN t_artists ON artist_fk=artist_id JOIN t_mediums ON medium_fk=medium_id";
$result=mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($result)) {
echo '<div id="piece">';
echo '<img src="' . $row['piece_image'] . '">';
echo '<section>';
echo '<h2>' . $row['piece_name'] . '</h2>';
echo '<span>' . $row['artist_name'] . '</span>';
echo '<br><span>' . $row['medium_name'] . '</span><br>';
echo '<a href="piece-detail.php?piece_id='.$row['piece_id'].'">more...</a><br>';
echo '<a href="process-favourite.php?piece_id=' . $row['piece_id'] . '"><img src="icons/favourite.png"></a>';
echo '<a href="piece-update.php?piece_id=' . $row['piece_id'] . '"><img src="icons/update.png"></a>';
echo '<a href="piece-delete.php?piece_id=' . $row['piece_id'] . '"><img src="icons/delete.png"></a>';
echo '</section>';
echo '</div>';
echo PHP_EOL;
}
?>
<?php mysqli_close($con); //Close Connection ?>
</div>
<div id="sub-nav">
<a href="piece-create.php"><span>+</span><span>Piece</span></a>
</div>
</main>
</body>
</html>