This is a Phalcon Framework adapter for DataTables.
- QueryBuilder interface
- ResultSet interface
- Pagination
- Global search (by value)
- Ordering
- Multiple column ordering
- Column-based search
- Install a composer
- Create
composer.jsonfile inside your project directory - Paste into it
{ "require": { "m1ome/phalcon-datatables": "1.*" } }- Run
composer update
It uses Phalcon QueryBuilder for pagination in DataTables.
In example we have a stantart MVC application, with database enabled. Don't need to provide a normal bootstrap PHP file, for Phalcon documentation, visit official site.
<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $builder = $this->modelsManager->createBuilder() ->columns('id, name, email, balance') ->from('Example\Models\User'); $dataTables = new DataTable(); $dataTables->fromBuilder($builder)->sendResponse(); } } }<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $resultset = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User") ->execute(); $dataTables = new DataTable(); $dataTables->fromResultSet($resultset)->sendResponse(); } } }<?php use \DataTables\DataTable; class TestController extends \Phalcon\Mvc\Controller { public function indexAction() { if ($this->request->isAjax()) { $array = $this->modelsManager->createQuery("SELECT * FROM \Example\Models\User") ->execute()->toArray(); $dataTables = new DataTable(); $dataTables->fromArray($array)->sendResponse(); } } }<?php /** * @property integer id * @property string name * @property string email * @property float balance */ class User extends \Phalcon\Mvc\Model { }<html> <head> <title>Simple DataTables Application</title> <script type="text/javascript" language="javascript" src="//code.jquery.com/jquery-1.11.1.min.js"></script> <script type="text/javascript" language="javascript" src="//cdn.datatables.net/1.10.4/js/jquery.dataTables.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#example').DataTable({ serverSide: true, ajax: { url: '/test/index', method: 'POST' }, columns: [ {data: "id", searchable: false}, {data: "name"}, {data: "email"}, {data: "balance", searchable: false} ] }); }); </script> </head> <body> <table id="example"> <thead> <th>ID</th> <th>Username</th> <th>Email</th> <th>Balance</th> </thead> <tbody> </tbody> </table> </body> </html>For more examples please search in site directory. It contains basic Phalcon bootstrap page to show all Phalcon-DataTables functionality.