Warning: mysqli_fetch_object() expects Parameter 1 to be mysqli_result, Boolean Given in /home/omeganim/public_html/index.php on line 39

Question

I am in need of help to resolve this error!!!

Warning: mysqli_fetch_object() expects Parameter 1 to be mysqli_result, Boolean Given in /home/omeganim/public_html/index.php on line 39

The code is this:

 $pagCorrente = 1;
 if(isset($_GET['pag'])){
     $pagCorrente = (int)$_GET['pag'];
 }
 $mostrar = 10;


 $pagCorrente = $pagCorrente * $mostrar - $mostrar;



 $sql = "SELECT count(id) as total FROM listas";     
 $ex = $conexao->query($sql);    
 $total = mysqli_fetch_object($ex);  
 $total = $total->total;

 $quantPages = ceil($total / $mostrar);




 $sql = "SELECT * FROM listas ORDER BY id desc LIMIT $pagCorrente,$mostrar";
 $wx = $conexao->query($sql);





 while($linha = mysqli_fetch_object($wx)){


 ?>
 <div class="engloba1">
  <div>


    <a href="<?php echo SITE . 'nomes.php?id='.$linha->id; ?>">
    <img src='<?php echo SITE . 'php/upload/' . $linha->imagen;?>' />

    <div class='box'>
     <p>
      <br><?php echo $linha->titulo;?> </br>
      </a>
      <a href="<?php echo SITE . 'nomes.php?id='.$linha->id; ?>">
      <br><?php echo $linha->nome;?> </br>
      <br><?php echo $linha->epi;?> </br>
      </a>
     </p>
     </div>
     </div>
   </div>

   <?php } ?>

Thank you in advance!!

Answer 1

Usually this error happens when the query executed in the database shows some error.

Soon after the execution of $conexao->query print the last error that happened in the database with $conexao->error. Thus remaining:

 /* ... ... */
 $sql = "SELECT count(id) as total FROM listas";     
 $ex = $conexao->query($sql);   

 echo $conexao->error;

 $total = mysqli_fetch_object($ex);  
 $total = $total->total;

 $quantPages = ceil($total / $mostrar);

 $sql = "SELECT * FROM listas ORDER BY id desc LIMIT $pagCorrente,$mostrar";
 $wx = $conexao->query($sql);

 echo $conexao->error;
 exit; //opcional, para poder visualizar melhor a saida de erro
 while($linha = mysqli_fetch_object($wx)){

 /* ... ... */

There is an error in your sql query (it may be a misspelled column name, etc) not to guess.

I noticed an important detail. Your variable $conexao is an instance of the mysqli class? In other words, you made a $conexao = new mysqli(...)? The above method will only work if it is done that way. Also you can simply call fecth_object straight from the resultset. Something like this: $conexao->fetch_object();