Phone book with database

Question

I have a phone book with the form already ready and now I need that when the user type in the field search a name or sector, this value should be compared with values of the database and be returned a value that corresponds to his search.

Follow my PHP code so far;

$bdServidor = '';
$bdUsuario = '';
$bdsenha = '';
$bdBanco = 'lista_telefonica';

$conexao = mysqli_connect($bdServidor, $bdUsuario, $bdsenha,$bdBanco);

if(mysqli_connect_errno($conexao))
{
    echo"problemas para conectar no banco.Verifique os dados!";
    die();
}

// Variavel que contem o valor do campo BUSCA;
$valor = $_POST['busca'];

Answer 1

To do this you will need to do a survey (SELECT) in the Database and use the LIKE to check if there is a word in that field.

$sql = "SELECT id, name FROM lista_telefonica WHERE nome LIKE '%$valor%' OR setor LIKE '%$valor%"; 

if ($result = query($conexao, $sql)) 
{
    while($obj = $result->fetch_object())
    {
        $line =$obj->id;
        $line.=$obj->name;
    }
}
$result->close();
unset($obj);
unset($sql);
unset($query); 

PS: Don’t forget to use Prepared Statements because of the SQL INJECTION

Answer 2

You should use a query SELECT something like that:

<?php
 $consulta=$ pdo->query("SELECT nome, usuario FROM login;");

 while ($linha = $consulta->fetch(PDO::FETCH_ASSOC)) 
{ echo "Nome: {$linha['nome']}
 - Usuário: {$linha['usuario']}
<br />"; } ?>

Look for more on CRUD, it’s something simple to do that yours SELECT. How much to compare you should use in SELECT a verifier, such as a '%LIKE' of SQL.

Here is an example about CRUD

Ah remembering that in your form you have to get the variable.

Follow the steps of this tutorial above and find out about the LIKE.