Untitled

<!DOCTYPE html>
<html lang="en-gb">
    <head>
        <meta charset="utf-8">
        <title>iSongs by Atish Khadka</title>
        <meta name="iSongs online music shop" content="An online commerce business where customers can purchase various types of music.">
        <link rel="stylesheet" href="isongs.css">
    </head>
    <body>
        <div class="container">
            <div class="header">
                <h1>iSongs</h1>
            </div>
            <div class="nav">
                <ul>
                    <li><a href="index.php">Home</a></li>
                    <li><a href="songs_artists.php">Songs and artists</a></li>
                    <li><a href="songs_artists_dropdown.php">Artist</a></li>
                    <li><a href="reg_form.php ">Register</a></li>
                    <li><a href="view_customers.php">Customers</a></li>
                    <li><a href="search_customer.php">Transactions</a></li>
                    <li><a href="#">User guide</a></li>
                </ul>
            </div>
       <div class="content">

                <table border="1">
                    <tr>

                        <th>Song ID</th>
                        <th>Song Name</th>
                        <th>Artist ID</th>
                        <th>Artist</th>
                        <th>Release date</th>
                        <th>Genre</th>
                        <th>Price</th>
                        <th>Nationality</th>
                            <th>Label</th>
                    </tr>

<?php
$servername = "80.82.112.181";
$username = "15095173u2";
$password = "15095173p2";
$dbname = "15095173_music_db";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
}


$sql = "SELECT Song_ID, Song_name, songs.Artist_ID, Release_date, Genre, Price, Nationality, Label, Artist_name, artist.Artist_ID FROM songs LEFT JOIN artist on songs.Artist_ID = artist.Artist_ID ORDER BY `songs`.`Song_name` ASC ";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
     // output data of each row
     while($row = $result->fetch_assoc()) {
         echo "
<tr>
         <td> ". $row["Song_ID"]. " </td>
         <td> " . $row["Song_name"]. "</td>
         <td> " . $row["Artist_ID"]." </td>
         <td> " . $row["Artist_name"]. " </td>
         <td> " . $row["Release_date"]."</td>
         <td> " . $row["Genre"]."</td>
         <td> " . $row["Price"]."</td>
         <td> " . $row["Nationality"]."</td>
         <td> " . $row["Label"] ."</td></tr>";

     }
} else {
     echo "0 results";
}

$conn->close();
?>
       </table>
</div>
</div>
</body>
</html>