Untitled

<html>
  <head>
    <title="Griff's Book Shop">
  <head>
        <style>
          .titlebar {
            width:1000px;
            height:150px;
            margin:auto;
            border: 1px solid #000000;
            font-size: 62;
            text-align: center;
          }
          .mainarea {
            width:1000px;
            height:600px;
            margin:auto;
            border: 1px solid #000000;
            overflow:scroll;
          }
          .booktable {
            width=100%;
          }
          .bookheader {
          }
        </style>

  </head>
  <body>
        <div class="titlebar" id="titlebar" name="titlebar">
                Griff's BookShop
        </div>

        <div class="mainarea" id="booklist" name="booklist">

<?php
$servername = "localhost";
$username = "xxxxxxxx";
$password = "xxxxxxxx";
$dbname = "griffbookshop";

// GET variables

$book=$_GET['book'];
$author=$_GET['author'];

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

$sql = "SELECT * FROM books";

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

echo "<form><table><tr><td><select>";

if ($result->num_rows > 0) {
//     output data of each row
       while($row = $result->fetch_assoc()) {
        echo "<option value='". $row[Title] . "'>". $row[Title] . "</option>";
    }
} else {
    echo "<option value='0 results'></option>";
}
echo "</select></td>";

echo "<td><select>";

$sql = "SELECT * FROM authors";

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

if ($result->num_rows > 0) {
//     output data of each row
       while($row = $result->fetch_assoc()) {
        echo "<option value='". $row[Author] . "'>". $row[Author] . "</option>";
    }
} else {
    echo "<option value='0 results'></option>";
}
echo "</select></td></tr></table></form>";

if ($book != '') {
echo "Book Selected - " . $book;
$sql = "SELECT b.BookID,b.Title,a.Author,g.Genre,f.Fictional,p.Publisher FROM books b JOIN authors a ON a.AuthorId=b.BookId JOIN genre g ON g.GenreId=b.GenreID JOIN fictional f ON f.FictionalID=b.FictionalID JOIN publisher p on p.PublisherID=b.PublisherID";
} elseif ($author != '') {
echo "Author Selected - " . $author;
$sql = "SELECT b.BookID,b.Title,a.Author,g.Genre,f.Fictional,p.Publisher FROM books b JOIN authors a ON a.AuthorId=b.BookId JOIN genre g ON g.GenreId=b.GenreID JOIN fictional f ON f.FictionalID=b.FictionalID JOIN publisher p on p.PublisherID=b.PublisherID WHERE a.Author='" . str_replace('_',' ',$author) . "'";
} else {
echo "Nothing selected!";
$sql = "SELECT b.BookID,b.Title,a.Author,g.Genre,f.Fictional,p.Publisher FROM books b JOIN authors a ON a.AuthorId=b.BookId JOIN genre g ON g.GenreId=b.GenreID JOIN fictional f ON f.FictionalID=b.FictionalID JOIN publisher p on p.PublisherID=b.PublisherID";
}

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


echo "<table class='booktable' id='booktable'><tr class='bookheader' id='bookheader'><td><b>Title</b></td><td><b>Author</b></td></tr>";

if ($result->num_rows > 0) {
//     output data of each row
       while($row = $result->fetch_assoc()) {
        echo "

<tr><td><a href=index.php?book=" . str_replace(' ','_',$row['Title']) . ">" . $row["Title"] . "</a></td>
<td><a href=index.php?author=" . str_replace(' ','_',$row['Author']) . ">" . $row["Author"] . "</a></td></tr>";

    }
} else {
    echo "0 results";
}

//$echo "</table>";

$conn->close();
?>

        </div>
  </body>
</html>