I can’t see the error (PHP and HTML)

Question

I wanted to show the names of the employees and the teams that they are part of so that if the user enters a name, it will filter all the teams that that person is part of. It’s coming in white.

   try{

                        $pdo = Conexao::getInstance();

                      $consulta = $pdo->prepare("SELECT id_equipe,nome_equipe,GROUP_CONCAT(nome_eletricista) as equipes FROM quadro WHERE id_agencia=:id AND status=1 GROUP BY nome_equipe ORDER BY nome_equipe ASC");

                        $consulta->bindParam(':id',$id_agencia, PDO::PARAM_INT);

                         if($consulta->execute()){

                          if($consulta->rowCount() > 0){

                          while($dados = $consulta->fetch(PDO::FETCH_OBJ)){

                                      $id_equipe= $dados['id_equipe'];
                                      $nome= $dados['nome_equipe'];
                                      $equipe= $dados->nome_equipe;
                                      $equipes=$dados->equipes;


                                      echo'<option value="'.$id_equipe.'">'.$nome.' - '.$equipes.'</option>';

                                          }
                                    }       
                                  }
                    }catch(PDOexception $e){

                        echo "ERROR: " . $e->getMessage();
                      }

                ?>
                              </select>
                              <br>

Answer 1

disabling the sql_mode.

Do it like this:

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FUL_GROUP_BY',''));

Answer 2

The server Mysql can operate in different modes SQL and can apply these modes differently to different clients, depending on the value of the variable sql_mode of the system.

The mistake only_full_group_by is generated when you use a non-aggregated value in a query who owns GROUP BY.

There are two ways to correct:

• Using ANY_VALUE

$consulta = $pdo->prepare("SELECT ANY_VALUE(id_equipe), nome_equipe, ANY_VALUE(GROUP_CONCAT(nome_eletricista)) AS equipes FROM quadro WHERE id_agencia=:id AND status=1 GROUP BY nome_equipe ORDER BY nome_equipe ASC");

• Disabling ONLY_FULL_GROUP_BY when instantiating the PDO object.

$pdo = new PDO("mysql:dbname=testdb;host=127.0.0.1", "root", "123456", [
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET sql_mode=(SELECT REPLACE(@@sql_mode,"ONLY_FULL_GROUP_BY",""));'
]);