Error in search filtering (PHP)

The message says Call to undefined function mysqli_result in [...]filtro.php:15 . In other words, the mysqli_result function does not exist.

This occurred because there is not even the mysql_result function. In fact, the return of the mysqli_query function is a object of type mysqli_result (only in cases of SELECT, SHOW, EXPLAIN and DESCRIBE queries). To fix the problem, simply change your code to:

$querySelect = mysqli_query($conn,$query);
$rows = $querySelect->fetch_assoc();

if(count($rows) > 0){

For more details, read the documentation:

• PHP Documentation: mysqli_query
• PHP Documentation: mysqli_result

PS: I recommend using a library that eases the connection to the database, there is one that I have written, but feel free to search for another:

• ConnectionMSi

It may be a bit out of date, as I stopped using MySQLi and started using PDO ( ConnectionPDO ) / p>     

The MySQLi library does not have the mysqli_result function. In fact, it is a class that is returned by the mysqli_query or by the mysqli_stmt::get_result (when using a prepared statement ).

Mysqli_query return value :

  

Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query () will return a mysqli_result object . For other successful queries mysqli_query () will return TRUE.

Mysqli_stmt :: get_result :

  

Returns a resultset for successful SELECT queries , or FALSE for other DML queries or on failure. The mysqli_errno () function can be used to distinguish between the two types of failure.

What you are doing is to fall into the error of transcribing a script by using mysql_* functions for the mysqli library. They are similar, but not 1: 1.

What you can do is to use the immediate return of mysqli_query , which returns a mysqli_result object, and iterate over the result using some fetch function, such as mysqli_result::fetch_assoc .

Object-oriented version:

$querySelect = mysqli_query($conn,$query);
while($row = $querySelect->fetch_assoc())
{
    //iteração de cada resultado
}

Procedural version:

$querySelect = mysqli_query($conn,$query);
while($row = mysqli_fetch_assoc($querySelect))
{
    //iteração de cada resultado
}

$ _REQUEST, by default, contains the contents of $ _GET, $ _POST and $ _COOKIE.

But it's just a pattern, which depends on variables_order; and I do not know if you want to work with cookies.

If I had to choose, I probably would not use $ _REQUEST and would choose $ _GET or $ _POST, depending on what I wanted my application to do (ie, one or the other but not both).

That said, you should use:

• $ _GET when someone is requesting data from your application and should use
• $ _POST when someone is pushing (inserting or updating or deleting) data for your application.

Anyway, there will not be much difference in performance: the difference will be insignificant compared to what the rest of the script will do.

<?php

include "config/conexao.php";

if (isset($_GET['filtro'])) {

    $inicio = $_GET["inicio"];
    $fim =$_GET["fim"];

    $query = "SELECT * from api_teste WHERE DTAENTORC BETWEEN date('$inicio') AND date('$fim')";


    $querySelect = mysqli_query($conn,$query);

    if(mysqli_result($querySelect) == true){
      $mensagem = "<div class='alert alert-danger'>Há!</div>";
      printf ($mensagem);
    }else {
      $mensagem = "<div class='alert alert-danger'>Por favor coloque uma data válida!</div>";
      printf ($mensagem);
  }
}

 ?>