Skip to content


Subversion checkout URL

You can clone with
Download ZIP
CakePHP Component for interoperability between CakePHP 2.x and jQuery DataTables plugin.
JavaScript PHP CSS ActionScript Shell
Branch: master
Failed to load latest commit information.
Controller/Component reverted due to bugs
test/app reverted due to bugs
.gitignore git ignore release notes


Provides server-side interoperability between CakePHP 2.x and jQuery DataTables plugin.


  • Takes paginated data and converts into json response compatible with datatables
  • Accepts dataTables ORDER BY requests
  • Accepts dataTables WHERE conditions
  • Accepts dataTables pagination
  • Works with LinkableBehavior and to a lesser extent Containable


  • PHP 5.x
  • CakePHP 2.x
  • LinkableBehavior is recommended but not required


You can either clone the project, download the project, or just copy & paste DataTableComponent.php into your projects Controller/Component directory


You can setup the demo locally with the following steps:

  1. Download demo application and move it into your webroot.
  2. Configure hosts and sites-enabled in apache to point at the location of demo application and setup the local hostname (ie datatables.local)
  3. Create a database (call this datatables)
  4. Configure database.php
  5. From the shell run Console/cake schema create
  6. Import app/Config/Schema/schema.sql into your database
  7. Ensure your app/tmp directory and app/tmp sub directories are writable

The demo application is designed for CakePHP 2.3 and was built on Ubuntu 12.10 running Apache2 with PHP 5.4. It does not have the full Cake framework in it, so you'll need to have cakephp in your php include paths or create a symbolic link to cake in test.


I'm in the process of enhancing documentation and moving it out of the README and into the wiki.

Ordering and conditions supplied via DataTables work "automagically" and nothing else is needed. Deep relations using the ContainableBehavior will break the response due to the way conditions work within that behavior. To get around this it is recommended that the LinkableBehavior be used instead. The Component respects many of the options you can define within jQuery DataTables settings such as bSearchable and bSortable on a per field basis.

With ContainableBehavior:

    $this->paginate = array(
        'fields' => array('Field.A','Field.B', 'Field.C','AssocatiatedModal.D'),
        'conditions' => array(
        'contain' => array('AssocatiatedModal')
    $this->set('response', $this->DataTable->getResponse());

Using models from other controllers. Sometimes the case may be that you are in a CustomersController and you have a method within that wants to display data from another model such as an Order model. This can be accomplished with the following parameters:



Code is licensed under the MIT License.

Something went wrong with that request. Please try again.