Home
DataTable Example

Ignited Datatables - Individual Column Filtering [Multi Filtering]

Order Number	Order Date	Status	Customer No
loading...

From to

$datatables->connect($config);
$datatables
->select('orderNumber, orderDate, status, customerNumber')
->from('Orders');
if(isset($_POST['from_date']) && $_POST['from_date'] != '')
 $datatables->filter('orderDate >=', preg_replace("/([0-9]{1,2})\/([0-9]{1,2})\/([0-9]{4})/i", "$3-$2-$1", $_POST['from_date']));
if(isset($_POST['to_date']) && $_POST['to_date'] != '')
 $datatables->filter('orderDate <=', preg_replace("/([0-9]{1,2})\/([0-9]{1,2})\/([0-9]{4})/i", "$3-$2-$1", $_POST['to_date']));
echo $datatables->generate();