Untitled

<!DOCTYPE HTML>
<head>
  <title>
    assignment
  </title>
  <style type="text/css">
    table,td{
      border:1px solid black;
    }
  </style>

</head>

<body>
  <h1 align="center">Enter Data below</h1>
  <br>
  <br>
  <br>
  <form method = "post" action="" >
    <table align = "center">
<tr>
<td><input type = "test" name = "fname" placeholder="first name"></td>
</tr>
<tr>
<td><input type = "text" name = "lastname" placeholder="last name"></td>
</tr>
<tr>
<td align="right"><input type = "submit" value = "submit"></td>
    </table>
</form>
</body>


<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "1st_database";
$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error)
{
  die("connection failed".$conn->connect_error);
}
$fname = $_POST['fname'];
$lname = $_POST['lastname'];
if(empty($_POST['fname']) && empty($_POST['lastname']))
{
  echo "please enter name first";
}
  elseif($query = "SELECT First_Name FROM sample_table WHERE First_Name =
'$fname'")

  if(mysqli_query($conn,$query) === true)
    {
      echo "this name already exists";
    }
    else {
      $sql = "INSERT INTO sample_table (First_Name,Last_Name)
      VALUES ('$fname','$lname')";
      if(!$conn->query($sql) === true)
      {
        echo "Error: " . $sql . "<br>" . $conn->error;
      }
      echo "<br>";
      echo "<br>";
      echo "<br>";
      echo "<br>";
      echo "<br>";
      echo "<br>";

      $sql = "SELECT * FROM sample_table";
      $result = $conn->query($sql);
      echo "<table>";

      while($row = $result->fetch_assoc()) {
              echo "<tr><td><b>First Name: </b> " ."<td>".
$row["First_Name"]."</td>". "</td><td><b>Last Name: </b>" ."<td>".
$row["Last_Name"]."</td>". "</td></tr>";
          }

      echo "</table>";

    }


 $conn->close();
  ?>