In this assignment, you will build two pages that pull data from the chinook SQLite database. All queries should use the PDO class.
Listing Playists
Create index.php
that displays all playlist names.
Each playlist should link to tracks.php?playlist=PLAYLIST_ID
, where PLAYLIST_ID
is replaced by the ID of the playlist.
Listing Tracks by Playist
Next, create tracks.php
. This page should display all tracks for the playlist
query string parameter. For each track, display the following information:
- Track name
- Album title
- Artist name
- Price
- Media type name
- Genre name
If there is no playlist
query string parameter, redirect back to index.php
.
If a playlist doesn't have any tracks, display "No tracks found for PLAYLIST_NAME" where PLAYLIST_NAME
is the name of the playlist.
Deploy to Heroku
Deploy your pages and database to Heroku. Create a README.md
file and add your Heroku link to it.