dongzhong8834 2016-01-29 10:39
浏览 45
已采纳

laravel 5分页问题5

I'm trying to build a website with laravel and I'm using pagination to show the result of searching. when I click on search button , it works but when I click on the next page of the pagination ,all values ​​of search form disappear and there is no result in searching is there anyone to help؟

route.php

Route::get('search', 'searchController@index');//return search view
Route::post('misearch', 'searchController@search');// return result 
Route::resource('misearch', 'searchController@search');// for pagination

searchController.php

$results =  Mod_ads::where(function($query){
$ins_brand = Input::has('ins_brand')? Input::get('ins_brand'):null;
$min_price = Input::has('min_price')? Input::get('min_price'):null;
$max_price = Input::has('max_price')? Input::get('max_price'):null;
$ins_color = Input::has('ins_color')? Input::get('ins_color'):null;


if (isset($min_price) && isset($max_price)) {
    $query -> where('ads_fie_insprice', '>=', $min_price)->
        where('ads_fie_insprice', '<=', $max_price);
    }


    if ($ins_brand == '0') {
        unset($ins_brand);
    }else{
        $query->where('ads_fie_insbrand', '=', $ins_brand);
    }


    if (isset($ins_color)) {
        $query->where('ads_fie_inscolor', 'LIKE', '%'.$ins_color.'%');
    }


        })->paginate(2);
        $link = str_replace('/?', '?', $results->render());
        return View::make('search', compact('results', 'link'));

search.blade.php

@if(isset($results))
  @foreach($results->getCollection()->all() as $result) 
      {{ $result->ads_fie_insbrand }}
      {{ $result->ads_fie_insprice }}
      {{ $result->ads_fie_inscolor }}
  @endforeach 
@endif 

                @if(isset($results))
                 {!! $link !!} 
                @endif

Anyone can guide me? Many many thanks.

  • 写回答

1条回答 默认 最新

  • dongmei2351 2016-01-30 11:53
    关注

    Here is my answere

    searchController.php

    public function search(Request $Request)
      {
    
        $results =  Mod_ads::where(function($query){
    
          $ins_brand = Input::has('ins_brand')? Input::get('ins_brand'):null;
          $min_price = Input::has('min_price')? Input::get('min_price'):null;
          $max_price = Input::has('max_price')? Input::get('max_price'):null;
          $ins_color = Input::has('ins_color')? Input::get('ins_color'):null;
    
    
    
          if (isset($min_price) && isset($max_price)) {
            $query -> where('ads_fie_insprice', '>=', $min_price)->
                 where('ads_fie_insprice', '<=', $max_price);
          }
    
          if ($ins_brand == '0') {
            unset($ins_brand);
          }else{
            $query->where('ads_fie_insbrand', '=', $ins_brand);
          }
    
          if (isset($ins_color)) {
            $query->where('ads_fie_inscolor', 'LIKE', '%'.$ins_color.'%');
          }
    
    
        })->paginate(2);
    
          Session::flash('_old_input',Input::all());
    
    
    
    
      $link = str_replace('/?', '?', $results->appends($Request->input())->render());
      return view('search', compact('results', 'link'));
    
      }
    

    search.blade.php

    @if(isset($results))
      @foreach($results->getCollection()->all() as $result)  
        {{ $result->ads_fie_brand }}
        {{ $result->ads_fie_insprice }}
        {{ $result->ads_fie_inscolor }}
      @endforeach 
    @endif 
    @if(isset($link))
      {!! $link !!}//pagination 
    @endif
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
  • ¥20 西门子S7-Graph,S7-300,梯形图
  • ¥50 用易语言http 访问不了网页
  • ¥50 safari浏览器fetch提交数据后数据丢失问题
  • ¥15 matlab不知道怎么改,求解答!!
  • ¥15 永磁直线电机的电流环pi调不出来
  • ¥15 用stata实现聚类的代码
  • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效