-
Notifications
You must be signed in to change notification settings - Fork 0
/
lyrics.php
27 lines (22 loc) · 890 Bytes
/
lyrics.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<?php
$PageTitle = "Lyrics";
$Description = "The lyrics to just about every song Pat has written.";
include "header.php";
$total = $mysqli->query("SELECT * FROM lyrics");
?>
<h2><a href="songlist.php">The Big Ass Song List</a></h2>
This is where you can find a list of <?php echo $total->num_rows; ?> of Pat's songs, including all the albums. Many have links to the lyrics and guitar tabs. You can also go straight to the individual albums below.<br>
<br>
<div id="lyrics-album">
<?php
$albums = $mysqli->query("SELECT * FROM albums ORDER BY year DESC");
while($row = $albums->fetch_array(MYSQLI_ASSOC)) {
?>
<a href="album.php?<?php echo $row['id']; ?>" style="background-image: url(images/cds/<?php echo $row['cover_image']; ?>);">
<div><?php echo $row['title']; ?></div>
</a>
<?php
}
?>
</div>
<?php include "footer.php"; ?>