lundi 23 mars 2020

WarningWarning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]

I'm getting this error when I upload my website online but on my local machine it's working just fine. The search also works fine when I don't use 'UNION ALL'/'UNION' on the tables since it is searching through several tables, but when I use them I get that WARNING. Can you guys please help

if (isset($_GET['search'])) {
$searcher = $connect->escape_string($_GET['search']);

$query = $connect->query(
  "SELECT * from `blogging` WHERE website_name LIKE '%{$searcher}%'
    UNION ALL
    SELECT * from `books` WHERE website_name LIKE '%{$searcher}%'
    UNION ALL
    SELECT * from `browsers` WHERE website_name LIKE '%{$searcher}%'
    UNION ALL
    SELECT * from `career_portal` WHERE website_name LIKE '%{$searcher}%'"
);

?>

<p class="">
  <h3 class="text-center text-light">Found <?php echo $quer->num_rows; ?> website(s).</h3>
</p>

<?php
if (mysqli_num_rows($query) > 0) {
  while ($row = mysqli_fetch_array($query)) {
?>
    <div class='container'>
      <div class='col-md-6'>
        <div class='alert alert-info'>
          <?php echo "<a href='{$row['website_url']}'> {$row['websites']}</a><br>\n"; ?>
        </div>
      </div>
    </div>



Aucun commentaire:

Enregistrer un commentaire