使用Yii在Datatables中进行服务器端处理

Question

I want to implement Datatables in my Yii project. I set up everything by the manual. Here is my jQuery for init:

$(document).ready(function() {
        $('#drugs').DataTable({
            serverSide: true,
            ajax: {
                url: '/products/retrievedata',
                type: 'POST'
            }
        });
    } );

And I can't come up with code in Yii for getting the data. My main objective is to make an ajax live search in my mysql DB,

Answer 1

Why don't you use CGridView if you are processing Data tables on server side.