Hi, have a qustion please

[gildas-Milandou]

Here is a message error that I got after trying to get a data from a database by pressing search button:

 

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given inC:\xampp\htdocs\E-commerce-website\functions\common_function.phpon line237

 

Here is the code it is a function call search_product:

function search_product(){

    global $con;

    if(isset($_GET['search_data_product'])) {

      $search_data_value=$_GET['search_data'];

        $search_query="select * from `products` where

        product_keywords like `%search_data_value%`";

        $result_query=mysqli_query($con,$search_query);

        while($row=mysqli_fetch_assoc($result_query)) {

            $product_id=$row['product_id'];

            $product_title=$row['product_title'];

            $product_description=$row['product_description'];

            $product_image1=$row['product_image1'];

            $product_image2=$row['product_image2'];

            $product_image3=$row['product_image3'];

            $product_price  =$row['product_price'];

            $category_id=$row['category_id'];

            $brand_id=$row['brand_id'];

 

            echo "   "          

[Barand]

If $result_query is boolean, then the query failed and returned "false".

For future reference, call this line of code before you connect to your database so any mysql errors get reported...

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

 

[ginerjm]

You probably need a dollar sign in this line:

product_keywords like `%search_data_value%`";

if you are trying to match the contents of that variable.  And that is why the query failed to execute

[Barand]

I didn't notice before (because you didn't use a code block) but you have used backticks around `%search_data_value%`. Those will force SQL to treat it as a column name. Use single quotes around strings.