Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $title = $_POST['title'];
- $host = "localhost";
- $user = "root";
- $pass = "";
- $db = "c203";
- // open connection
- $link = mysqli_connect($host, $user, $pass, $db);
- // build SQL statement
- $query = "SELECT * FROM music";
- // execute SQL statement
- $result = mysqli_query($link, $query) or die(mysqli_error($link));
- mysqli_close($link);
- $row=mysqli_fetch_array($result);
- if ($title == $row[0]):
- echo "Title: ".$row[0]."<br>";
- echo "Music Album: ".$row[1]."<br>";
- echo "Artist: ".$row[2]."<br>";
- echo "Rating: ".$row[3]."<br>";
- echo "Review: ".$row[4]."<br>";
- else:
- echo "Song not in data";
- ?>
Add Comment
Please, Sign In to add comment