Can't select suggestions when I click on them

Question

I can't select any suggestions when I click on them.

I want the suggestions can be clicked, selected and changed color when I hover on them.

How can I do this?

This is my current code:

<?php
    include 'connect.php'; //connect with database
    $query = $_GET["q"];
    if($query != "")
    {
        $safequery = mysqli_real_escape_string($con,$query);
        $stmt = "SELECT * FROM searchengine WHERE title LIKE '%" . $safequery . "%' OR keywords LIKE '%" . $safequery . "%' OR link LIKE '%" . $safequery . "%' LIMIT 4";
        $result = mysqli_query($con,$stmt) or die(mysqli_error($con));

        $number_of_result = mysqli_num_rows($result);
        if ($number_of_result > 0)
        {
            //results found here and display them
            while ($row = \mysqli_fetch_assoc($result))
            { //show first 10 results
                //add $title to an array which you will call json_encode(arr) on.
                $title = $row["title"];
                echo "<div id='sugg-search-result'>";
                echo "<div id='sugg-title'>" . $title . "</div>";
                echo "</div>";
            }
        }
    }
?>

Answer 1

You can try like below:

<?php

include 'connect.php'; //connect with database

$query = isset($_GET["q"]) ? $_GET : '' ;

if($query != "")
{
    $safequery = mysqli_real_escape_string($con,$query);

    $stmt = "SELECT * FROM searchengine WHERE title LIKE '%" . $safequery . "%' OR keywords LIKE '%" . $safequery . "%' OR link LIKE '%" . $safequery . "%' LIMIT 4";

    $result = mysqli_query($con,$stmt) or die(mysqli_error($con));

    $number_of_result = mysqli_num_rows($result);

    if ($number_of_result > 0) {
        //results found here and display them
        while ($row = \mysqli_fetch_assoc($result)) { //show first 10 results
            //add $title to an array which you will call json_encode(arr) on.
            $title = $row["title"];
            echo "<div id='sugg-search-result'>";
            echo "<div class='suggestion' id='sugg-title'>" . $title . "</div>";
            echo "</div>";

        }

    }
}
?>

CSS:

<style>
    .suggestion:hover {
        color:orange;
    }
</style>

Javascript:

<!-- jQuery -->

<script>
    $(document).on('click','.suggestion',function(){
        // write your necessary javascript code
    });
</script>