How to display data on datatables using laravel 5?

Question

I am using laravel 5 and I want to show field in jenis_surat column in database to my table using datatables. I want to using JSON, do you know how to show the number depends on the entries of the data.
here is my controller (It's just shows data in jenis_surat):

public function jenissurat()
{return view('jenissurat');}

  public function datajenissurat()
{
    $jenissurat = new JenisSurat();
    $jenissurats = $jenissurat->select('jenis_surat')->get();   
    return $jenissurats;
}

And how to display it on datatables? example:

No. Jenis Surat. .Action
1. . .A . . . . . . . . . Edit | Delete
2. . .B . . . . . . . . . Edit | Delete
3. . .F . . . . . . . . . Edit | Delete

<table id="jenissurat" class="table table-bordered table-striped" cellspacing="0" widht="100%">
          <thead>
            <tr>
              <th width="4%">No.</th>
              <th width="80%">Jenis Surat</th>
              <th width="16%">Action</th>
            </tr>
          </thead>
        </table>
        <script type="text/javascript">

          $(document).ready(function(){
            $('#publish').DataTable({
              'columns' : [
                {'data' : 'jenis_surat'}
              ]
            });
          });

        </script>

Here is my route:

Route::get('/jenissurat', [
'uses' => 'SuratController@jenissurat',
'as' => 'jenissurat'
]); Route::get('/datajenissurat', [
'uses' => 'SuratController@datajenissurat',
'as' => 'datajenissurat'
]);here

VipindasKS · Accepted Answer · 2016-04-28 05:38:33Z

1

Try this, I am not sure this is a best solution from the performance point of view.

public function jenissurat()
 {
    $returnValue = $this->datajenissurat();
    return view('jenissurat', compact('returnValue'));
 }

 public function datajenissurat()
 {
    $jenissurat = new JenisSurat();
    DB::statement(DB::raw('set @rownum=0'));

    $jenissurats = $jenissurat->select([DB::raw('@rownum  := @rownum  + 1 AS rownum'), 'jenis_surat'])->get();   
    return $jenissurats;
 }

And regarding to the Datatables you can add something like this.

  <script>

    $(function() {

       var oTable = $('#publish').DataTable({
           bProcessing    : true,
           serverSide     : true,
           /* sDom           : 'p', */
           dom            : 'Bfrtip',
           ajax: {
           url: '{!! route("datajenissurat") !!}',
           data: function (d) {

           }
        },        
      columns: [
        { data: 'rownum', name: 'rownum' ,orderable: false, searchable:  false },
        { data: 'jenis_surat', name: 'jenis_surat' },
        { data: 'action', name: 'action', orderable: false, searchable:  false }
        ]
     });
   });
  </script>

I see a edit/delete column that can be used by the action column. So, the ajax call to your controller function datajenissurat() will return a json array, which can be parsed using the datatable script.

edited Apr 28, 2016 at 5:38

answered Apr 28, 2016 at 3:14

VipindasKS

4817 silver badges15 bronze badges

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

16 Comments

hendraspt Over a year ago

I've got an error "Class 'App\Http\Controllers\DB' not found"

VipindasKS Over a year ago

add 'Use DB; ` at top of your controller OR use \DB in your query.

hendraspt Over a year ago

yeah it works, thanks. And do you know how to display the json data on the datatables?

VipindasKS Over a year ago

Can you show the code you have done so far, with integrating datatables

hendraspt Over a year ago

<table id="publish" class="table table-bordered table-striped" cellspacing="0" widht="100%"> <thead> <tr> <th>No.</th> <th>Publish</th> <th>Action</th> </tr> </thead> </table> <script type="text/javascript"> $(document).ready(function(){ $('#publish').DataTable({ 'columns' : [ {'data' : 'publish'} ] }); }); </script>

|

abhayendra · Accepted Answer · 2016-04-28 02:37:15Z

0

public function datajenissurat()
{
    $jenissurats = $jenissurat->select('jenis_surat')->get();   
    return view('view.show', compact('jenissurats '));
}

and also make view

answered Apr 28, 2016 at 2:37

abhayendra

1976 bronze badges

1 Comment

hendraspt Over a year ago

it's not working. I'm type the link for show the json but got an error. My function was already working but I want to show the number column no, which is not in database.

Collectives™ on Stack Overflow

How to display data on datatables using laravel 5?

2 Answers 2

16 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

16 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related