如何使用HTML Dropdown获取数据库值

I am making a Music database site for University using PHPMyAdmin. Right now, I need to make a process dropdown that allows the user to click on a drop down menu of artist names. When the user clicks on one of the given artists and clicks the send button, I want it to link to a page that contains the songs & details of the artist.. These are the Tables. I need the SQL code in order to successfully link these together/ THANKS

Here is the HTML Drop Down code

-- Please select artist name --

    <option>Drake</option>
    <option>ILOVEMAKONNEN</option>
    <option>Justin Bieber</option>
    <option>Kanye West</option>
    <option>Kendrick Lamar</option>
    <option>Post Malone</option>
    <option>ScHoolboy Q</option>
    <option>Taylor Swift</option>
    <option>Travis Scott</option>
    <option>Young Thug</option>
    </select>
            <input type="submit" value="Send">

From database fetch the artist name. Then use for() or foreach loop() let say it is your arrtist array: $arrArtist =('Drake','ILOVEMAKONNEN','Justin Bieber');

In html page

<select name="arrtistname">
<?php 
foreach($arrArtist as $artist)
{
<?php>
  <option value='<?php echo $artist?>'><?php echo $artist?></option>
<?php
}
?>
</select>