Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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'>
- <option value=0>--Please select an artist--</option>
- <?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);
- </form>
- <input type="submit" required name="submit" value="Search artists songs>
- </select>
- <?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 = $result_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>© <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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement