Untitled

<!doctype html>

<!--credit to Joshua McCann for troubleshooting and
    helping me with developing my php page-->

<html lang="en">
  <head>
    <title>Inisope Online Directory</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
    <style type="text/css">
      div{ min-width: 10em;
      }
    </style>
  </head>

  <body style="background:gainsboro;">
    <?php
    $servername = "localhost";
    $username = "jmelander";
    $password = "jmelander";
    $dbname = "hr_employees";

    $conn = new mysqli($servername, $username, $password, $dbname);

    $sql = "SELECT * FROM employees WHERE LAST_NAME LIKE '%" . $_POST['l_name'] . "%'";
    $result = $conn->query($sql);

   function displayText($results){
      if ($results->num_rows > 0){
        while ($row = $results->fetch_assoc()){

           printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td><a href='mailto:%s'>%s</a></td></tr>", $row["LAST_NAME"], $row["FIRST_NAME"], $row["PHONE_NUMBER"], $row["EMAIL"], $row["EMAIL"]);
        }
      }
    else{
      echo "0 results <br>";
    }
    }
    ?>

    <div class="container">
      <div class="jumbotron text-center" style="background:grey; color:white;">
        <center><img src="images/logo.jpg" class="img-rounded img-responsive"  alt="Inisope_logo"></center>
        <h1>Inisope Inc. Employee Directory</h1>
        <p> It's no longer raining cats and dogs!</p>
      </div>
      <div class="row">
        <div class="col-md-12">
          <form action="php_directory.php" method="post">
            <div class="table-responsive">
              <table class="table text-left" style="border-color:transparent;">
                <tr>
                  <td><label for="l_name"> Search Employee's Last Name:</label></td>
                  <td><input type="text" name="l_name"></td>
                </tr>
                <tr>
                 <td colspan='2' class="text-center">
                    <button type="submit">Submit</button>
                 </td>
                </tr>
              </table>
            </div>
          </form>
        </div>
      </div>
     <div class="row" style="padding-top:1em;">
       <div class="col-md-12">
         <div class="table-responsive">
           <table class="table text:left" style="border-color:black;">
             <tr>
              <th><strong>Last Name</strong></th>
              <th><strong>First Name</strong></th>
              <th><strong>Phone Number</strong></th>
              <th><strong>Email</strong></th>
            </tr>
              <?php displayText($result);?>
           </table>
         </div>
       </div>
      </div>
   </div>
  </body>
</html>