Yii2: Get selected rows data from gridView checkbox columns into controller

Question

I've view page(index.php) in my Yii2 project, and I'm using Kartik gridView for showing the data

This the view from index.php:

On the right side of view, I've a checkbox column. And I've an Export button. I want to export the selected name (selected by checkbox) into name.txt file.

I've finally make the export function, but I don't know how to get the selected data from view into controller.

I've try suggestions that I got from many forums, for example:

I put this javascript code in my view index.php:

<script>
function getRows(){
    var keys = $('#grid').yiiGridView('getSelectedRows');
    $.post({
        url: FakturOutController / exportAction,
        dataType: 'json',
        data: {keylist: keys},
        success: function(data) {
            alert('I did it! Processed checked rows.')
        },
    });
}

and set the export button like this:

<p>
    <button type="button" onclick="getRows()" class="btn btn-success">Export</button>
</p>

But I got nothing, the button didn't showed any action/reaction when clicked.

This is the gridView code in index.php:

`<?php Pjax::begin(); ?>
<?=
GridView::widget([
    'dataProvider' => $dataProvider,
    'tableOptions' => ['class' => 'table table-hover'],
    'columns' => [
        ['class' => 'yii\grid\SerialColumn',
            'header' => 'No',
        ],
        [
            'label' => 'Name',
            'value' => function($data) {
            return $data->name;
    }
        ],
        ['class' => '\kartik\grid\CheckboxColumn'],
    ],
    'toolbar' => [
        ['content' =>
            Html::a('<i class="glyphicon glyphicon-repeat"></i>', ['index'], ['data-pjax' => false, 'class' => 'btn btn-default', 'title' => 'Reset Grid'])
        ],
        '{export}',
        '{toggleData}'
    ],
    'panel' => [
        'heading' => '<i class="glyphicon glyphicon-align-left"></i>&nbsp;&nbsp;<b>Data</b>',
        'before' => '', //IMPORTANT
    ],
]);
?>
<?php Pjax::end(); ?>

<?=
    Html::a('<i class=" glyphicon glyphicon-export"></i> Export', ['export', 'userId' => $userId], ['class' => 'btn btn-success']);
?>`

Any help would be appreciated. Thanks

May be onclick="getRows()" instead of onclick="displayResult()" will work. — Insane Skull
– Insane Skull, Commented Jan 4, 2017 at 12:27
@InsaneSkull Sorry that was a mistake, I've copy wrong button code, but I've update the code on the question, thanks :) — Blackjack
– Blackjack, Commented Jan 4, 2017 at 12:54
@InsaneSkull the code for gridView has been added, check it out :) — Blackjack
– Blackjack, Commented Jan 4, 2017 at 16:03

Yasin Patel · Accepted Answer · 2017-01-04 19:01:40Z

2

By inspect element on checkbox column you can find name of row ( checkbox name ). it contain id as value.

from that you can find how many rows are selected.

in my case i get 'selection[]' in checkbox name.

ex.

<input type="checkbox" class="kv-row-checkbox" name="selection[]" value="1">

i write jquery code to get selected rows below.

<script>

    function getRows()
    {
        var strvalue = "";
        $('input[name="selection[]"]:checked').each(function() {
            if(strvalue!="")
                strvalue = strvalue + ","+this.value;
            else
                strvalue = this.value;
        });
     // strvalue contain selected row by comma separated      
    $.post({
        url: FakturOutController / exportAction,
        dataType: 'json',
        data: {keylist: keys},
        success: function(data) {
            alert('I did it! Processed checked rows.')
        },


       });
    }
    </script>

answered Jan 4, 2017 at 19:01

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

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

3 Comments

Blackjack Over a year ago

Thanks, when I comment the code inside $.post({}), and add alert(strvalue), it's work add printout the value. But when I uncomment the $.post({}), the button didn't work. And I also edit the url: FakturOutController / exportAction, url: 'faktur-out/export', but it also didn't work.

Blackjack Over a year ago

thanks :) The case has been solved and I've been update the question :)

Nivetha Jaishankar Over a year ago

How to call getRows() from view? Can anyone explain.

Collectives™ on Stack Overflow

Yii2: Get selected rows data from gridView checkbox columns into controller

This the view from index.php:

This is the gridView code in index.php:

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

This the view from index.php:

This is the gridView code in index.php:

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related