Level 54
Oct 18, 2016
2
Level 1
How to show pagination in listing record
Can you please guide me how can i show pagination in listing view.
Route: Route::get('business/products',['as' => 'product-list', 'uses' => 'ProductController@productList']);
Controller: public function productList(Request $request) {
Session::put('product_field', Input::has('field') ? Input::get('field') : (Session::has('product_field') ? Session::get('product_field') : 'title'));
Session::put('product_sort', Input::has('sort') ? Input::get('sort') : (Session::has('product_sort') ? Session::get('product_sort') : 'asc'));
$product = DB::table('tbl_businessproducts')->where('status', '1')->orderBy(Session::get('product_field'), Session::get('product_sort'))->paginate(4);
if(Input::get('field')==""){
return View::make('business.pages.products')->with('product', $product);
}else{
echo "1";
}
}
View:
@foreach($product as $item)
<tr>
<td>{{ $item->title }}</td>
<td>{{ $item->new_price }}</td>
<td>{{ $item->stock }}</td>
<td>{{ $item->total_orders }}</td>
<td class="textalign-left">
<a class="view-item" href="view-product.html"><i class="fa fa-eye" aria-hidden="true" style="font-size:20px;"></i></a>
<a class="edit-item " href="#"><i class="fa fa-pencil" style="font-size:20px;margin:0 10px;"></i></a>
<a class="remove-item" href="#"><i class="fa fa-trash-o"></i></a>
</td>
</tr>
@endforeach
Please or to participate in this conversation.