Argthtjtr

I am working on search option. When user select their desired city, it gives me a array. I merge that array and passed it to view.

This is my code -

public function boatSort(Request $request){

        $city   = $request->city;//dd($city);

        $min    = $request->min;

        $max    = $request->max;



        $current_page = LengthAwarePaginator::resolveCurrentPage();



        $boat_list = new Boats;

        $boat_y = array();

        $boat_t = array();

        $boat_c = array();



        $boat_city = DB::select("SELECT c.name FROM `boats` AS b, `city` AS c WHERE b.city = c.id");



        if(count($city)>0){

            for($i=0; $i<count($city); $i++){



                $boat_city[$i] = DB::select("SELECT * FROM `boats` WHERE city = ".$city[$i]);

                $boat_c = array_merge($boat_c, $boat_city[$i]);//dd($boat);



            }

            $current_page_orders = array_slice($boat_c, ($current_page - 1) * 5, 5);

            $boat = new LengthAwarePaginator($current_page_orders, count($boat_c), 5);

            return view('user-interface/sort_by', compact('boat', 'boat_city'));

        }



    }

Now, the problem is whenever I click on second page, I am getting data fetched from db query. But, whenever I click on 1st page it gives all data(Not sorted data). It is not holding a search values.

This is how I am using pagination

{!! str_replace('/?', '?', $boat->render()) !!}

Can you please help me to resolve this? Also, if their is any alternative way for pagination then please let me know.

Thanks in advance to share a knowledge and solution.