Untitled

<!DOCTYPE html>

<html lang="en">

<head>
    <title>PHP Data Connection Test</title>
</head>

<body>
    <?php
$servername = "localhost";
$username = "********";
$password = "********";
$dbname = "dbtest";

$FNAME = (isset($_POST['FNAME']) ? $_POST['FNAME'] :'');
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT FNAME,LNAME FROM `accounts` where FNAME = `FNAME`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    //output data of each row
    while ($row = $result->fetch_assoc()) {
        printf ("%s, %s<br>", $row["LNAME"], $row["FNAME"]);
    }


}

  // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    echo "</br>Connected successfully";
?>
</body>

</html>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Document</title>
</head>
<body>
  <form action="php_dbtest.php" method="POST" id="FNAME">
    Search: <input type="text" name="name" /><br />
    <input type="submit" name="find" value="Search" id="add" />
  </form>
</body>
</html>