在Laravel中使用AJAX搜索数据

Question

This is my ajax code. I want to type something in a textbox, and the result from database should show at the table.

<script type="text/javascript">
  function retrieve(){
    var country = $('#country_name').val();
    $.ajax({
      type: "POST",
      url: '{{route('dataAjax-country')}}',
      data: {country:country},
      success: function(result){
        $('#ajaxtable').html(result);
      }
    });
  }
</script>

But the data is not changing when I type on my textbox. I have a textbox and a table like this:

{!! Form::text('country_name', '', array('id'=>'country_name', 'onkeyup'=>'retrieve()')) !!}

<tbody id="ajaxtable">
  @foreach($results as $result)
    <tr>
      <td>{{$result->id}}</td>
      <td>{{$result->country_name}}</td>
    </tr>
  @endforeach
</tbody>

And this is my route code, maybe I lack at my route?:

Route::get('asd', array(
        'as' => 'dataAjax-country', 'uses' => 'CompaniesController@dataAjaxCountry'));

And my controller that contain AJAX script that will show at the table:

public function dataAjaxCountry()
{
    echo "<tr><td>asdsad</td></tr>";
}

Answer 1

You are sending a post request but you are using get on your route, you need to change your type to get, it's also useful to log any errors, try:

<script type="text/javascript">
  function retrieve(){
    var country = $('#country_name').val();
    $.ajax({
      type: "get",
      url: '{{route('dataAjax-country')}}',
      data: {country:country},
      success: function(result){
        $('#ajaxtable').html(result);
      },
      error: function(result){
        console.log(result);
      }
    });
  }
</script>