想要为网站创建搜索栏，但在使用“或”时我收到了错误 [英] Want to create a search bar for website but when using "or" I got error

问题描述

我收到错误，因为mysqli_fetch_assoc（）期望参数1为mysqli_result，boolean来自以下代码
 
 $ search = strtolower（$ _ GET ['searchbox']）; 
 $ search = mysqli_real_escape_string（$ con1，$ search）; 
 
 $ search_exploded = explode（，$ search）; 
 $ construct =''; 
 foreach（$ search_exploded as $ search_each）{
 $ construct。=OR title LIKE'％$ search_each％'; 
} 
 
 
 $ construct =SELECT * FROM vdo WHERE $ construct; 
 $ query = mysqli_query（$ con1，$ construct）; 
 while（$ row = mysqli_fetch_assoc（$ query））{
 echo $ title = $ row ['title']; 
} 

我的尝试：



i想要将搜索结果与satabase中的任何一个或两个或所有搜索词进行匹配，这可以使用OR布尔来完成，但它会给我错误，所以我可以更改或发布回复代码

解决方案

search = strtolower（

_GET ['searchbox']）;

search = mysqli_real_escape_string （

i got error as mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean from below code

     $search = strtolower($_GET['searchbox']);
      $search =mysqli_real_escape_string($con1,$search);

              $search_exploded = explode ( " ", $search );
                    $construct = '';
                     foreach( $search_exploded as $search_each ) {
                         $construct .= " OR title LIKE '%$search_each%'";
                    }


    $construct="SELECT * FROM vdo WHERE $construct ";
    $query=mysqli_query($con1,$construct);
    while($row=mysqli_fetch_assoc($query)){
	    echo $title=$row['title'];
    }

What I have tried:

i want to match search result with any one or two or all of searched words with satabase ,this can be done using OR Boolean but it gives me error so what can i change or please post answeared code

解决方案

search = strtolower(

_GET['searchbox']);

search =mysqli_real_escape_string(

这篇关于想要为网站创建搜索栏，但在使用“或”时我收到了错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！