How to sort data from database in laravel html

Question

I am trying sort specific row in the table. But i stuck middle of it. I m using Kyslik\ColumnSortable\Sortable; in the model file. But no actual effect. Any idea for this?

class estates extends Model
{
use Sortable;

protected $fillable = [ 'Entry', 'Price' ];

protected $table="estates";

public $Sortable = ['Entry', 'Price']; 
}

My Controller;

public function sumos()
{
  $data['este'] = estates::all();
  return view('pages.sumo', $data);

  return view('pages.sumo',['este' => estates::sortable()->get()]);

}

and in html;

<table align="center">
<tr>
    <td colspan="11" id="header"><h1>物件概要<h1></td>
</tr>
    <tr>
        <th width="340px">会社名</th>
        <th width="80px">物件名</th>
        <th width="135px">所在地</th>
        <th width="135px">総戸数</th>
        <th width="80px">間取り</th>
        <th width="100px">専有面積</th>
        <th width="80px">バルコニー面積</th>
        <th width="100px">竣工年月日</th>
        <th width="100px">@sortablelink('Entry', '入居年月日')</th>
        <th width="100px">@sortablelink('Price', '価格')</th>
        <th width="100px">販売会社名</th>
    </tr>
<table>


@foreach($este as $row) 
<table align="center">
    <tr>
        <td width="340px">Company Name</td>
        <td width="80px">{{ $row->Building_Names }}</td>
        <td width="135px">{{ $row->Addresses }}</td>
        <td width="135px">{{ $row->HouseHolds }}</td>
        <td width="80px">{{ $row->Rooms }}</td>
        <td width="100px">{{ $row->Balconys }}</td>
        <td width="80px">{{ $row->Extents }}</td>
        <td width="100px">{{ $row->Constrution }}</td>
        <td width="100px">{{ $row->Entry }}</td>
        <td width="100px">{{ $row->Price }}</td>
        <td width="100px">{{ $row->Company }}</td> 
    </tr>
</table>
@endforeach

Any idea for how to solve(how to sort) specific data? Thank you

Jahid Mahmud · Accepted Answer · 2018-09-26 08:50:19Z

1

You should write this. Hopefully this will solve your problem

<table align="center">
    <tr>
        <td colspan="11" id="header"><h1>物件概要<h1></td>
    </tr>
        <tr>
            <th width="340px">会社名</th>
            <th width="80px">物件名</th>
            <th width="135px">所在地</th>
            <th width="135px">総戸数</th>
            <th width="80px">間取り</th>
            <th width="100px">専有面積</th>
            <th width="80px">バルコニー面積</th>
            <th width="100px">竣工年月日</th>
            <th width="100px">@sortablelink('Entry', '入居年月日')</th>
            <th width="100px">@sortablelink('Price', '価格')</th>
            <th width="100px">販売会社名</th>
        </tr>

@foreach($este as $row) 
        <tr>
            <td width="340px">Company Name</td>
            <td width="80px">{{ $row->Building_Names }}</td>
            <td width="135px">{{ $row->Addresses }}</td>
            <td width="135px">{{ $row->HouseHolds }}</td>
            <td width="80px">{{ $row->Rooms }}</td>
            <td width="100px">{{ $row->Balconys }}</td>
            <td width="80px">{{ $row->Extents }}</td>
            <td width="100px">{{ $row->Constrution }}</td>
            <td width="100px">{{ $row->Entry }}</td>
            <td width="100px">{{ $row->Price }}</td>
            <td width="100px">{{ $row->Company }}</td> 
        </tr>
 @endforeach
 </table>

Also add use Kyslik\ColumnSortable\Sortable; at the top of our model

In your controller modify this

public function sumos()
{
  $este= estates::sortable(['Price' => 'desc'])->get();
  return view('pages.sumo', compact('este'));
}

edited Sep 26, 2018 at 8:50

answered Sep 26, 2018 at 8:04

Jahid Mahmud

1,1361 gold badge12 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Jahid Mahmud Over a year ago

@KubilayTurgut I have updated my answer. Plz check this

firefly Over a year ago

I can click the price th but no effects under the row. also url changing when I click the th like this Price&direction=desc

Jahid Mahmud Over a year ago

Plz write the full url after clicking the price th

firefly Over a year ago

http://localhost/sumo?sort=Price&direction=asc when I clicked it changes "desc" or "asc"

Jahid Mahmud Over a year ago

I have updated my answer. I am currently merging your two table into one. Plz take a look.

|

Mateusz Czerwiński · Accepted Answer · 2018-09-26 07:52:33Z

1

One of the easiest solutions is to use datatables

answered Sep 26, 2018 at 7:52

Mateusz Czerwiński

636 bronze badges

2 Comments

Sydgren Over a year ago

I want to agree with this one, but it only works until a certain point. When sorting with datatables, you'll need all rows, so backend pagination would mess it up.

Mateusz Czerwiński Over a year ago

You can find everything in the documentation. You can use ajax uploading and redo the controller with the received request.

Jignesh Joisar · Accepted Answer · 2018-09-26 07:54:13Z

1

use laravel built in method for sorting by using two ways to do..

by query and by collection

try this one

estates::orderBy('Entry')->orderBy('Price')->get()

answered Sep 26, 2018 at 7:54

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

1 Comment

firefly Over a year ago

no effect, I changed <th width="100px">@sortablelink('価格')</th> like this. do i need to change in for each column too? Also I update my controller up inside the question

Sydgren · Accepted Answer · 2018-09-26 08:04:01Z

1

I took a quick look at the documentation of the package you're using.

https://github.com/Kyslik/column-sortable

You have to add @sortablelink('field', 'Field') to the table headers.

Also, looking at the controller method, your sorting will never be reached.

public function sumos()
{
  return view('pages.sumo',['este' => estates::sortable()->get()]);
}

Hope this helps

answered Sep 26, 2018 at 8:04

Sydgren

1016 bronze badges

3 Comments

firefly Over a year ago

no effects, just clicking the th and nothing changes

Sydgren Over a year ago

<tr><th>@sortablelink('Price', 'Price')</td></tr>

firefly Over a year ago

yep, done that but nothing changes.I just can click the th only. Update the codes up in the question.

Collectives™ on Stack Overflow

How to sort data from database in laravel html

4 Answers 4

9 Comments

2 Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

9 Comments

2 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related