Show Code:
mediums-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>
<body>
<?php include 'nav.php'; ?>
<?php include 'db-connect.php'; ?>
<main>
<?php
$sql="SELECT * FROM t_mediums";
$result=mysqli_query($con,$sql);
while ($row=mysqli_fetch_array($result)){
echo '<div class="medium">';
echo '<h2>'.$row['medium_name'].'</h2>';
echo '<span>'.$row['artist_name'].'</span>';
echo '<a href="medium-update.php?medium_id='.$row['medium_id'].'"><img src="icons/update.png"></a>';
echo '<a href="medium-delete.php?medium_id='.$row['medium_id'].'"><img src="icons/delete.png"></a>';
echo '</div>';
echo PHP_EOL;
}
?>
<?php mysqli_close($con); //Close Connection ?>
<div id="sub-nav">
<a href="medium-create.php"><span>+</span><span>Medium</span></a>
</div>
</main>
</body>
</html>