~NAXC~

File Content: `ajax_search_destination.php`

<?php

include("config.php");

if(isset($_GET['keyword']) && $_GET['keyword']!="") :

    $data = mysqli_real_escape_string($db,$_GET['keyword']);

    $keyword =  trim(preg_replace('/\s+/',' ',$data));

    $sql=$db->query("SELECT distinct tour_id,main_category,category,sub_category FROM `using_tour_tb` WHERE (tour_id LIKE '%$keyword%' || main_category LIKE '%$keyword%' || category LIKE '%$keyword%' || sub_category LIKE '%$keyword%') && main_category='Destination' limit 10");

    $count=mysqli_num_rows($sql);

    if($count!=0) :

        $json_data=array();

        foreach ($sql as $key => $value):

            $json_data[] = $value['tour_id'];

            $json_data[] = $value['main_category'];

            $json_data[] = $value['category'];

            $json_data[] = $value['sub_category'];

        endforeach;

        echo json_encode($json_data);

    else :

        echo 0;

    endif;

endif;

?>

File Content: ajax_search_destination.php

File Content: `ajax_search_destination.php`