Select (Sum) totals

dblackw

Is there example code of using datatables to do sum totals or other SQL selects in php, I realise the example php code is only a sample - but I'm not sure how to go about adding to it eg SELECT name, SUM(daily_typing_pages)
-> FROM employee_tbl GROUP BY name;

allan

Where it creates the JSON you can add the extra data in there. For example:

$data = SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns );
$data['count'] = $myCount;
echo json_encode( $data );

Then use ajax.json() to access the JSON object on the client-side. You might use:

footerCallback: function () {
  var json = this.api().ajax.json();
  var count = json.count;
  ...
}

Allan