Untitled

<!DOCTYPE html>
<html lang="en-gb">
    <head>
        <meta charset="utf-8">
        <title>Artists Search</title>
        <meta name="iSongs online music shop by Atish Khadka" content="Search for an Artist to see more information about them.">

        <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 action="process_dropdown.php" method="post">
                                <select name='artist'>


<?php

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

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

                                        $sql = "SELECT Artist_ID, Artist_name FROM artist";

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


             echo "debug 1";
  ?>

<?php /* Select queries return a resultset */
if ($result = $mysqli->query("SELECT Artist_ID, Artist_name FROM artist")) {


    while ($row = $result->fetch_array()) {
        echo '<option>' . $row['Artist_name'] .'</option>';
    }


    /* free result set */
    $result->close();
}


                                      <option value>--Please select an artist--</option>
                                    <input type="submit" name="submit" value="Search artists songs">

                          </select>
</form>

?>


            </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>