$dealer = Dealer::with('getState', 'getCity', 'getCityLocation')->select(['vehicle_dealer.id as dealer_connection_id','vehicle_dealer.*'])->leftJoin('dealer_connection', 'vehicle_dealer.id', '=', 'dealer_connection.dealer_id')->whereNull('dealer_connection.dealer_id')->get();

$(document).ready(function(){ $('#country').keyup(function(){ var query = $(this).val(); if(query != '') { $.ajax({ url:"search.php", method:"POST", data:{query:query}, success:function(data) { $('#countryList').fadeIn(); $('#countryList').html(data); } }); } }); $(document).on('click', 'li', function(){ $('#country').val($(this).text()); $('#countryList').fadeOut(); }); });

'; if(mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_array($result)) { $output .= '

'.$row["contact_no"]." ".$row["fname"]." ".$row["lname"].'

'; } } else { $output .= '

Match Not Found

'; } $output .= ''; echo $output; } ?>