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
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 软件自定义无线电该怎样使用
  • ¥15 R语言mediation包做中介分析,直接效应和间接效应都很小,为什么?
  • ¥15 Jenkins+k8s部署slave节点offline
  • ¥15 微信小游戏反编译后,出现找不到分包的情况
  • ¥15 如何实现从tello无人机上获取实时传输的视频流,然后将获取的视频通过yolov5进行检测
  • ¥15 WPF使用Canvas绘制矢量图问题
  • ¥15 用三极管设计一个单管共射放大电路
  • ¥15 孟德尔随机化r语言运行问题
  • ¥15 pyinstaller编译的时候出现No module named 'imp'
  • ¥15 nirs_kit中打码怎么看(打码文件是csv格式)