ankapix/phalcon-datatables

A DataTables adapter for Phalcon Framework.

dev-master 2020-09-16 15:00 UTC

Requires

• php: >=7.0
• ext-phalcon: >=3.0.0

MIT

• Yasin Köse

README

This is a Phalcon Framework adapter for DataTables.

Support

Currently supported

• QueryBuilder interface
• ResultSet interface
• Pagination
• Raw query interface(*new)
• Global search (by value)
• Ordering
• Multiple column ordering
• Column-based search
• Caching

Installation

Installation via Composer

• Install a composer
• Create composer.json file inside your project directory
• Paste into it

  {
  "require": {
  	"ankapix/phalcon-datatables": "dev-master"
  }
  }
  

• Run composer update

Example usage

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.

Controller (using QueryBuilder):

<?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();
		}
	}
}