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