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.">
        <?
$pageTitle = 'Artists'; // Call this in your pages' files to define the page title
?>
        <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">

				<form method="POST">
								<select name='artist'>
									<option>Please select an artist</option>
									<?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 Artist_ID, Artist_name FROM artist";

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

										if ($result->num_rows > 0) {
											// output data of each row
											while($row = $results->fetch_assoc()){
												$artist_name = $row['Artist_name'];
												echo '<option value=' . $row['Artist_ID'] . '>' . $artist_name . '</option>';
											}
										} else {
											 echo "0 results";
										}
									?>
								</select>
								<input type="submit" name="submit" value="Search artists songs">
				</form>
				<?php
                    if(isset($_POST['submit'])){
                        $selected_artist_id = $_POST['artist'];
                        $sql_songs_by_artist = "SELECT * FROM songs WHERE songs.Artist_ID = '$selected_artist_id'";
                        $results_songs = $conn->query($sql_songs_by_artist);

                        $chosen_artist = $connection->query("SELECT * FROM artist WHERE artist.Artist_ID = '$selected_artist_id'");
                        $chosen_artist_row = $chosen_artist->fetch_assoc();
                        $chosen_artist_name = $chosen_artist_row['First_name'] . ' ' . $chosen_artist_row['Last_name'];

                        if($results_songs->num_rows >= 1){
                            echo '<table border="1">
                              <tr>
                                <td>Song ID</td>
                                <td>Song Name</td>
                                <td>Artist Name</td>
                                <td>Genre</td>
                                <td>Release Date</td>
                                <td>Price</td>
                              </tr>';

                            while($rows = $results_songs->fetch_assoc()){
                                echo '
                                    <tr>
                                        <td>' . $rows['Song_ID'] . '</td>
                                        <td>' . $rows['Song_Name'] . '</td>
                                        <td>' . $chosen_artist_name . '</td>
                                        <td>' . $rows['Genre'] . '</td>
                                        <td>' . $rows['Release_date'] . '</td>
                                        <td>' . $rows['Price'] . '</td>
                                    </tr>';
                            }
                            echo '</table>';
                        }else{
                            echo 'No songs found by ' . $chosen_artist_name . '.';
                        }
                    }
                ?>

            </div>
            <div class="footer">
                <p>&copy; <a href="http://www.mmu.ac.uk/" title="MMU homepage">MMU 2016</a> | STUDENT COURSEWORK | TUTOR <a href="mailto:c.dawson@mmu.ac.uk">Chris Dawson</a> | <a href="http://validator.w3.org/check?uri=referer" title="W3C HTML Validation Service" >Valid HTML</a> </p>
            </div>
        </div>
    </body>
</html>