How do I do a NAME search filter in PHP ?

Question

I have tried several ways, but all of the problem in the query...

Exemplo :
<form class="form-inline my-2 my-lg-0" method="post" action="home.php">
 <input class="form-control mr-sm-2" type="text" name="palavra" 
 placeholder="Pesquisar" aria-label="Search"> <button class="btn btn- 
 outline- 
 danger my-2 my-sm-0" type="submit">Pesquisar</button>
 </form>

  <?php 
  if(isset($_POST['palavra']) != '')
  {
    $palavra = $_POST['palavra'];
    $pesquisa = "where nome like '%palavra%' ";
  } 
  else
   {
    $pesquisa = '';
   }

    $querySelect = $link->query("select * from alunos $pesquisa");
    $linhas = mysqli_num_rows($querySelect);
    echo "Foram encontrados $linhas registros";
    echo '<br>';

   ?>

Answer 1

Try to adjust the following

1º - if condition:

if(isset($_POST['palavra']) != '')

for:

if(isset($_POST['palavra']))

2º - Inside the if:

$pesquisa = "where nome like '%palavra%' ";

for:

$pesquisa = "where nome like '%$palavra%' ";

Answer 2

Use only: isset($_POST['palavra']) and try to change the query for:

select * from alunos .$pesquisa

If it doesn’t work describe the error obtained.