Integrate jQuery DataTables with Symfony 2 and more.

jquery-datatables-bundle eases the use of jQuery DataTables to display rich DataTables in your Symfony application by providing Twig extensions and PHP objects to do the heavy lifting. The bundle include the excellent JS library jQuery DataTables and this plug-ins.

Dry out your DataTables code by writing it all in PHP !

Includes :

• DataTables 1.10.20
• DataTables AutoFill 2.3.4 (DataTables plugin)
• DataTables Buttons 1.6.0 (DataTables plugin)
• DataTables JSZip 2.5.0
• DataTables pdfmake 0.1.36
• DataTables ColReorder 1.5.2 (DataTables plugin)
• DataTables FixedColumns 3.3.0 (DataTables plugin)
• DataTables FixedHeader 3.1.6 (DataTables plugin)
• DataTables KeyTable 2.5.1 (DataTables plugin)
• DataTables Responsive 2.2.3 (DataTables plugin)
• DataTables RowGroup 1.1.1 (DataTables plugin)
• DataTables RowReorder 1.2.6 (DataTables plugin)
• DataTables Scroller 2.0.1 (DataTables plugin)
• DataTables Select 1.3.1 (DataTables plugin)
• editableTable

Provides :

• a "wbw_jquery_datatables_delete" route to delete a managed entity by a DataTable
• a "wbw_jquery_datatables_edit" route to edit all columns provided by a DataTable
• a "wbw_jquery_datatables_export" route to export all managed entities by a DataTable
• a "wbw_jquery_datatables_index" route to display a DataTable (main and columns searches is also provide with a generic implementation)
• a "wbw_jquery_datatables_options" route to retrieve with an XML HTTP request the options of a DataTable
• a "wbw_jquery_datatables_render" route to retrieve with an XML HTTP request the HTML rendering of a DataTable
• a "wbw_jquery_datatables_serialize" route to retrieve with an XML HTTP request a managed entity by a DataTable into JSON format

If you like this package, pay me a beer (or a coffee)

Open a command console, enter your project directory and execute the following command to download the latest stable version of this package:

$ composer require webeweb/jquery-datatables-bundle

This command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation.

Then, enable the bundle by adding it to the list of registered bundles in the app/AppKernel.php file of your project:

    public function registerBundles() {
        $bundles = [
            // ...
            new WBW\Bundle\CoreBundle\WBWCoreBundle(),
            new WBW\Bundle\BootstrapBundle\WBWBootstrapBundle(),
            new WBW\Bundle\JQuery\DataTablesBundle\WBWJQueryDataTablesBundle(),
        ];

        // ...

        return $bundles;
    }

Once the bundle is added then do:

$ php bin/console wbw:core:unzip-assets
$ php bin/console assets:install

Add the bundle assets in the app/config/config.yml file of your project:

# ...
# Core configuration
wbw_core:
    plugins:
        - "jquery"

# Bootstrap configuration
wbw_bootstrap:
    version: 3

# jQuery DataTables configuration
wbw_jquery_datatables:
    theme: "bootstrap"
    plugins:
        - "responsive"

IMPORTANT NOTICE: For use with Bootstrap 4, replace '3' by '4' into wbw_bootstrap.version and 'bootstrap' by 'bootstrap4' into wbw_jquery_datatables.theme.

Add the bundle routing in the app/config/routing.yml file of your project:

# ...
wbw_jquery_datatables:
    prefix:   "/"
    resource: "@WBWJQueryDataTablesBundle/Resources/config/routing.yml"

Read the documentation.

To test the package, is better to clone this repository on your computer. Open a command console and execute the following commands to download the latest stable version of this package:

$ git clone https://github.com/webeweb/jquery-datatables-bundle.git
$ cd jquery-datatables-bundle
$ composer install

Once all required libraries are installed then do:

$ vendor/bin/phpunit

jquery-datatables-bundle is released under the MIT License. See the bundled LICENSE file for details.

If you like this work, please consider donating at