How can I put an if in this mysql search when it returns no results?

Question

How can I put an if in this mysql search when it returns no results?

Navigation

#1 by (1 votes)

1

How to put an if and else in this code for when the search in the database returns no value?

include_once("conexao.php");
$sql= "SELECT FROM tb_nome WHERE nome LIKE '$pesquisar%'";
$salvar = mysqli_query($conexao,$sql);
while ($linhas = mysqli_fetch_array($salvar){
    echo "Nome: ".$linhas['nome']."<br>";
    echo "Nome: ".$linhas['telefone']."<br>";
}

php mysql mysqli

asked by anonymous 11.06.2018 / 01:54

1 answer

print variable Java script inside HTML Textfield JavaFX with dynamic mask for monetary values

score 1 · Accepted Answer

Try this:

if(mysqli_num_rows($salvar) > 0){
    while ($linhas = mysqli_fetch_array($salvar){
        echo "Nome: ".$linhas['nome']."<br>";
        echo "Nome: ".$linhas['telefone']."<br>";
    }
}else{
    echo "Nenhum resultado foi encontrado.";
}