skrrrr

<?php
        $servername = "localhost";
        $username = "root";
        $password = "";
        $dbname = "firsttest";


        if(isset($_POST['Searchh'])) {

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

        $sql = "SELECT ISBN, Title, Author FROM books where Author = '$searchword'";
        $result = $conn->query($sql);
        } else {

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

        $sql = "SELECT ISBN, Title, Author FROM books";
        $result = $conn->query($sql);
        }
        ?>

<!DOCTYPE HTML>
<HTML>
   <HEAD>
   <style>
    table, th, td {
    border: 1px solid black;
    }
</style>
      <TITLE>My first HTML document</TITLE>
   </HEAD>
   <BODY>
   </table>
            <form action="test.php" method = "POST">
                Search by Author: <input type="text" name="Searchh"><br>
            <input type="submit" value="Submit">
            </form>


            <table style="width:100%">
            <tr>
                <td>ISBN</td>
                <td>Title</td>
                <td>Author</td>
            </tr>

        <?php
        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                //echo "ISBN: " . $row["ISBN"]. " - Title: " . $row["Title"]. " - Author: " . $row["Author"]. "<br>";
                echo "<tr>";
                echo "<td>".$row['ISBN']."</td>";
                echo "<td>".$row['Title']."</td>";
                echo "<td>".$row['Author']."</td>";
                echo "</tr>";
            }
        } else {
            echo "0 results";
        }
        $conn->close();
        ?>

   </BODY>
</HTML>