1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
| <?php
|
| /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
| * Easy set variables
| */
|
| // DB table to use
| $table = 'datatables_demo';
|
| // 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 object
| // parameter names
| $columns = array(
| array( 'db' => 'first_name', 'dt' => 'first_name' ),
| array( 'db' => 'last_name', 'dt' => 'last_name' ),
| array( 'db' => 'position', 'dt' => 'position' ),
| array( 'db' => 'office', 'dt' => 'office' ),
| array(
| 'db' => 'start_date',
| 'dt' => 'start_date',
| 'formatter' => function( $d, $row ) {
| return date( 'jS M y', strtotime($d));
| }
| ),
| array(
| 'db' => 'salary',
| 'dt' => 'salary',
| 'formatter' => function( $d, $row ) {
| return '$'.number_format($d);
| }
| )
| );
|
| // SQL server connection information
| $sql_details = array(
| 'user' => '',
| 'pass' => '',
| 'db' => '',
| 'host' => ''
| );
|
|
| /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
| * If you just want to use the basic configuration for DataTables with PHP
| * server-side, there is no need to edit below this line.
| */
|
| require( 'ssp.class.php' );
|
| echo json_encode(
| SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
| );
|
|
