<form action="result.php" method="POST">
    <h1>Search</h1>
    <input type="text" name="q"></input><br /><br />
    <input type="submit" id="submit" value="Search"></input>
  </form>

<?php
$servername = "localhost";
$username = "myusername";
$password = "mypassword";
$dbname = "mydb";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$mysqli->set_charset("utf8");
if (isset($_REQUEST['q'])){
$target= $_REQUEST['q'];
$sql = " SELECT *
         FROM TABLE1
         WHERE name
         LIKE '%$target%'";

  $result = $mysqli->query($sql)
  or die($mysqli->error . "<pre>$sql</pre>");
  while ($row = $result->fetch_assoc()){
    echo $row["number"] . " " . $row["name"]. " " . $row["hp"] . "<br>";
    }
}
else {
    echo "0 results";
}
?>