Beispiel #1
0
 public function dataTable($cache)
 {
     /*
      * DataTables example server-side processing script.
      *
      * Please note that this script is intentionally extremely simply to show how
      * server-side processing can be implemented, and probably shouldn't be used as
      * the basis for a large complex system. It is suitable for simple use cases as
      * for learning.
      */
     // DB table to use
     $table = self::TABLENAME;
     // Table's primary key
     $primaryKey = 'id';
     // Array of database columns which should be read and sent back to DataTables.
     // The `db` parameter represents the column name in the database, while the `dt`
     // parameter represents the DataTables column identifier. In this case simple
     // indexes
     $columns = array(array('db' => 'id', 'dt' => 0, 'formatter' => function ($d, $row) {
         return "<input type='radio' value='{$d}' class='i-grey' name='id' checked>";
     }), array('db' => 'name', 'dt' => 1), array('db' => 'status', 'dt' => 2, 'formatter' => function ($d, $row) {
         return self::getStringStatus($d);
     }), array('db' => 'address', 'dt' => 3), array('db' => 'phone', 'dt' => 4), array('db' => 'username', 'dt' => 5));
     require 'DataTable.php';
     echo json_encode(DataTable::simple($_POST, $table, $primaryKey, $columns, $cache));
 }