Filter search does not work

Question

I have a form that passes the query data and an external PHP file called busca.php

My problem is that I don’t get any php error to know the problem of it not finding the filter search. When I use the normal search it returns me all the values of the database.

What’s going on? Follow the code of the program, where q is to receive the text field consulta file consulta.php:

if(isset($_POST['buscar'])){
    $q = $con->real_escape_string($_POST['consulta']);
    $query_Busca = "SELECT * FROM equipamento WHERE tombamento LIKE '%$q%'";
    $Busca = mysqli_query($con,$query_Busca) or die($con->error);
    // Check results
    if($Busca){
        //Se for um sucesso!
        $row_Busca = mysqli_fetch_assoc($Busca);
        $totalRows_Busca = $Busca->num_rows;
    }

In this else the function is working normal giving all the database data as wish the problem is even in the code above where I want to find the equipment only by the tipping number that is in "query" however it does not think and returns me error.

} else {
    $query = "SELECT * FROM equipamento";
    $Busca = $con->query($query) or die($con->error);
    $row_Busca = mysqli_fetch_assoc($Busca);
    $totalRows_Busca = $Busca->num_rows;
}

Answer 1

try to standardize your code, because in one part you use mysqli_ functions and in another use objects, and these details end up causing headache and difficulties in finding the problems.

copying from the working block would look like this:

(Obs.: if the tipping field is int, use (int) to convert to integer instead of like.)

if(isset($_POST['buscar'])){
    $q = $con->real_escape_string($_POST['consulta']);
    $query = "SELECT * FROM equipamento WHERE tombamento = '" . (int)$q . "'";
    $Busca = $con->query($query) or die($con->error);
    // Check results
    if($Busca){
        //Se for um sucesso!
        $row_Busca = mysqli_fetch_assoc($Busca);
        $totalRows_Busca = $Busca->num_rows;
    }