Top 10 - USA Songs of the Week
By: James Mc Ginty, Rodman Bourne, Tyler Stanley
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT album_url, album_image, album_release_date, lyrics_body, album_name, track_name, artist_name FROM spotipy";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$album_str = $row["album_url"];
$album_str = substr($album_str, 31);
$str = "https://open.spotify.com/embed/track/";
$str .= $album_str;
echo "
'". $row["album_name"]. "' || '". $row["track_name"]. "' || '". $row["artist_name"]. "'
". '
'. "
Album Release Date:
" . $row["album_release_date"]. "
Song Lyrics:
Expand to View
". $row["lyrics_body"]. '...
';
}
} else {
echo "0 results";
}
$conn->close();
?>
All content and graphics on this web site are the property of the company Refsnes Data.