@@ -29,22 +29,22 @@ discard block |
||
29 | 29 | // parameter represents the DataTables column identifier. In this case simple |
30 | 30 | // indexes |
31 | 31 | $columns = array( |
32 | - array( 'db' => 'first_name', 'dt' => 0 ), |
|
33 | - array( 'db' => 'last_name', 'dt' => 1 ), |
|
34 | - array( 'db' => 'position', 'dt' => 2 ), |
|
35 | - array( 'db' => 'office', 'dt' => 3 ), |
|
32 | + array('db' => 'first_name', 'dt' => 0), |
|
33 | + array('db' => 'last_name', 'dt' => 1), |
|
34 | + array('db' => 'position', 'dt' => 2), |
|
35 | + array('db' => 'office', 'dt' => 3), |
|
36 | 36 | array( |
37 | 37 | 'db' => 'start_date', |
38 | 38 | 'dt' => 4, |
39 | - 'formatter' => function( $d, $row ) { |
|
40 | - return date( 'jS M y', strtotime($d)); |
|
39 | + 'formatter' => function($d, $row) { |
|
40 | + return date('jS M y', strtotime($d)); |
|
41 | 41 | } |
42 | 42 | ), |
43 | 43 | array( |
44 | 44 | 'db' => 'salary', |
45 | 45 | 'dt' => 5, |
46 | - 'formatter' => function( $d, $row ) { |
|
47 | - return '$'.number_format($d); |
|
46 | + 'formatter' => function($d, $row) { |
|
47 | + return '$' . number_format($d); |
|
48 | 48 | } |
49 | 49 | ) |
50 | 50 | ); |
@@ -61,16 +61,15 @@ discard block |
||
61 | 61 | * If you just want to use the basic configuration for DataTables with PHP |
62 | 62 | * server-side, there is no need to edit below this line. |
63 | 63 | */ |
64 | -require( 'ssp.class.php' ); |
|
64 | +require('ssp.class.php'); |
|
65 | 65 | |
66 | 66 | // Validate the JSONP to make use it is an okay Javascript function to execute |
67 | 67 | $jsonp = preg_match('/^[$A-Z_][0-9A-Z_$]*$/i', $_GET['callback']) ? |
68 | - $_GET['callback'] : |
|
69 | - false; |
|
68 | + $_GET['callback'] : false; |
|
70 | 69 | |
71 | -if ( $jsonp ) { |
|
72 | - echo $jsonp.'('.json_encode( |
|
73 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
74 | - ).');'; |
|
70 | +if ($jsonp) { |
|
71 | + echo $jsonp . '(' . json_encode( |
|
72 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
73 | + ) . ');'; |
|
75 | 74 | } |
76 | 75 |
@@ -32,29 +32,29 @@ discard block |
||
32 | 32 | array( |
33 | 33 | 'db' => 'id', |
34 | 34 | 'dt' => 'DT_RowId', |
35 | - 'formatter' => function( $d, $row ) { |
|
35 | + 'formatter' => function($d, $row) { |
|
36 | 36 | // Technically a DOM id cannot start with an integer, so we prefix |
37 | 37 | // a string. This can also be useful if you have multiple tables |
38 | 38 | // to ensure that the id is unique with a different prefix |
39 | - return 'row_'.$d; |
|
39 | + return 'row_' . $d; |
|
40 | 40 | } |
41 | 41 | ), |
42 | - array( 'db' => 'first_name', 'dt' => 0 ), |
|
43 | - array( 'db' => 'last_name', 'dt' => 1 ), |
|
44 | - array( 'db' => 'position', 'dt' => 2 ), |
|
45 | - array( 'db' => 'office', 'dt' => 3 ), |
|
42 | + array('db' => 'first_name', 'dt' => 0), |
|
43 | + array('db' => 'last_name', 'dt' => 1), |
|
44 | + array('db' => 'position', 'dt' => 2), |
|
45 | + array('db' => 'office', 'dt' => 3), |
|
46 | 46 | array( |
47 | 47 | 'db' => 'start_date', |
48 | 48 | 'dt' => 4, |
49 | - 'formatter' => function( $d, $row ) { |
|
50 | - return date( 'jS M y', strtotime($d)); |
|
49 | + 'formatter' => function($d, $row) { |
|
50 | + return date('jS M y', strtotime($d)); |
|
51 | 51 | } |
52 | 52 | ), |
53 | 53 | array( |
54 | 54 | 'db' => 'salary', |
55 | 55 | 'dt' => 5, |
56 | - 'formatter' => function( $d, $row ) { |
|
57 | - return '$'.number_format($d); |
|
56 | + 'formatter' => function($d, $row) { |
|
57 | + return '$' . number_format($d); |
|
58 | 58 | } |
59 | 59 | ) |
60 | 60 | ); |
@@ -73,9 +73,9 @@ discard block |
||
73 | 73 | * server-side, there is no need to edit below this line. |
74 | 74 | */ |
75 | 75 | |
76 | -require( 'ssp.class.php' ); |
|
76 | +require('ssp.class.php'); |
|
77 | 77 | |
78 | 78 | echo json_encode( |
79 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
79 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
80 | 80 | ); |
81 | 81 |
@@ -29,22 +29,22 @@ discard block |
||
29 | 29 | // parameter represents the DataTables column identifier. In this case object |
30 | 30 | // parameter names |
31 | 31 | $columns = array( |
32 | - array( 'db' => 'first_name', 'dt' => 'first_name' ), |
|
33 | - array( 'db' => 'last_name', 'dt' => 'last_name' ), |
|
34 | - array( 'db' => 'position', 'dt' => 'position' ), |
|
35 | - array( 'db' => 'office', 'dt' => 'office' ), |
|
32 | + array('db' => 'first_name', 'dt' => 'first_name'), |
|
33 | + array('db' => 'last_name', 'dt' => 'last_name'), |
|
34 | + array('db' => 'position', 'dt' => 'position'), |
|
35 | + array('db' => 'office', 'dt' => 'office'), |
|
36 | 36 | array( |
37 | 37 | 'db' => 'start_date', |
38 | 38 | 'dt' => 'start_date', |
39 | - 'formatter' => function( $d, $row ) { |
|
40 | - return date( 'jS M y', strtotime($d)); |
|
39 | + 'formatter' => function($d, $row) { |
|
40 | + return date('jS M y', strtotime($d)); |
|
41 | 41 | } |
42 | 42 | ), |
43 | 43 | array( |
44 | 44 | 'db' => 'salary', |
45 | 45 | 'dt' => 'salary', |
46 | - 'formatter' => function( $d, $row ) { |
|
47 | - return '$'.number_format($d); |
|
46 | + 'formatter' => function($d, $row) { |
|
47 | + return '$' . number_format($d); |
|
48 | 48 | } |
49 | 49 | ) |
50 | 50 | ); |
@@ -63,9 +63,9 @@ discard block |
||
63 | 63 | * server-side, there is no need to edit below this line. |
64 | 64 | */ |
65 | 65 | |
66 | -require( 'ssp.class.php' ); |
|
66 | +require('ssp.class.php'); |
|
67 | 67 | |
68 | 68 | echo json_encode( |
69 | - SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns ) |
|
69 | + SSP::simple($_POST, $sql_details, $table, $primaryKey, $columns) |
|
70 | 70 | ); |
71 | 71 |
@@ -29,22 +29,22 @@ discard block |
||
29 | 29 | // parameter represents the DataTables column identifier. In this case simple |
30 | 30 | // indexes |
31 | 31 | $columns = array( |
32 | - array( 'db' => 'first_name', 'dt' => 0 ), |
|
33 | - array( 'db' => 'last_name', 'dt' => 1 ), |
|
34 | - array( 'db' => 'position', 'dt' => 2 ), |
|
35 | - array( 'db' => 'office', 'dt' => 3 ), |
|
32 | + array('db' => 'first_name', 'dt' => 0), |
|
33 | + array('db' => 'last_name', 'dt' => 1), |
|
34 | + array('db' => 'position', 'dt' => 2), |
|
35 | + array('db' => 'office', 'dt' => 3), |
|
36 | 36 | array( |
37 | 37 | 'db' => 'start_date', |
38 | 38 | 'dt' => 4, |
39 | - 'formatter' => function( $d, $row ) { |
|
40 | - return date( 'jS M y', strtotime($d)); |
|
39 | + 'formatter' => function($d, $row) { |
|
40 | + return date('jS M y', strtotime($d)); |
|
41 | 41 | } |
42 | 42 | ), |
43 | 43 | array( |
44 | 44 | 'db' => 'salary', |
45 | 45 | 'dt' => 5, |
46 | - 'formatter' => function( $d, $row ) { |
|
47 | - return '$'.number_format($d); |
|
46 | + 'formatter' => function($d, $row) { |
|
47 | + return '$' . number_format($d); |
|
48 | 48 | } |
49 | 49 | ) |
50 | 50 | ); |
@@ -63,10 +63,10 @@ discard block |
||
63 | 63 | * server-side, there is no need to edit below this line. |
64 | 64 | */ |
65 | 65 | |
66 | -require( 'ssp.class.php' ); |
|
66 | +require('ssp.class.php'); |
|
67 | 67 | |
68 | 68 | echo json_encode( |
69 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
69 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
70 | 70 | ); |
71 | 71 | |
72 | 72 |
@@ -17,9 +17,9 @@ discard block |
||
17 | 17 | |
18 | 18 | |
19 | 19 | // REMOVE THIS BLOCK - used for DataTables test environment only! |
20 | -$file = $_SERVER['DOCUMENT_ROOT'].'/datatables/mysql.php'; |
|
21 | -if ( is_file( $file ) ) { |
|
22 | - include( $file ); |
|
20 | +$file = $_SERVER['DOCUMENT_ROOT'] . '/datatables/mysql.php'; |
|
21 | +if (is_file($file)) { |
|
22 | + include($file); |
|
23 | 23 | } |
24 | 24 | |
25 | 25 | |
@@ -31,22 +31,22 @@ discard block |
||
31 | 31 | * @param array $data Data from the SQL get |
32 | 32 | * @return array Formatted data in a row based format |
33 | 33 | */ |
34 | - static function data_output ( $columns, $data ) |
|
34 | + static function data_output($columns, $data) |
|
35 | 35 | { |
36 | 36 | $out = array(); |
37 | 37 | |
38 | - for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) { |
|
38 | + for ($i = 0, $ien = count($data); $i < $ien; $i++) { |
|
39 | 39 | $row = array(); |
40 | 40 | |
41 | - for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) { |
|
41 | + for ($j = 0, $jen = count($columns); $j < $jen; $j++) { |
|
42 | 42 | $column = $columns[$j]; |
43 | 43 | |
44 | 44 | // Is there a formatter? |
45 | - if ( isset( $column['formatter'] ) ) { |
|
46 | - $row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] ); |
|
45 | + if (isset($column['formatter'])) { |
|
46 | + $row[$column['dt']] = $column['formatter']($data[$i][$column['db']], $data[$i]); |
|
47 | 47 | } |
48 | 48 | else { |
49 | - $row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ]; |
|
49 | + $row[$column['dt']] = $data[$i][$columns[$j]['db']]; |
|
50 | 50 | } |
51 | 51 | } |
52 | 52 | |
@@ -70,10 +70,10 @@ discard block |
||
70 | 70 | * * pass - user password |
71 | 71 | * @return resource PDO connection |
72 | 72 | */ |
73 | - static function db ( $conn ) |
|
73 | + static function db($conn) |
|
74 | 74 | { |
75 | - if ( is_array( $conn ) ) { |
|
76 | - return self::sql_connect( $conn ); |
|
75 | + if (is_array($conn)) { |
|
76 | + return self::sql_connect($conn); |
|
77 | 77 | } |
78 | 78 | |
79 | 79 | return $conn; |
@@ -89,12 +89,12 @@ discard block |
||
89 | 89 | * @param array $columns Column information array |
90 | 90 | * @return string SQL limit clause |
91 | 91 | */ |
92 | - static function limit ( $request, $columns ) |
|
92 | + static function limit($request, $columns) |
|
93 | 93 | { |
94 | 94 | $limit = ''; |
95 | 95 | |
96 | - if ( isset($request['start']) && $request['length'] != -1 ) { |
|
97 | - $limit = "LIMIT ".intval($request['start']).", ".intval($request['length']); |
|
96 | + if (isset($request['start']) && $request['length'] != -1) { |
|
97 | + $limit = "LIMIT " . intval($request['start']) . ", " . intval($request['length']); |
|
98 | 98 | } |
99 | 99 | |
100 | 100 | return $limit; |
@@ -110,32 +110,31 @@ discard block |
||
110 | 110 | * @param array $columns Column information array |
111 | 111 | * @return string SQL order by clause |
112 | 112 | */ |
113 | - static function order ( $request, $columns ) |
|
113 | + static function order($request, $columns) |
|
114 | 114 | { |
115 | 115 | $order = ''; |
116 | 116 | |
117 | - if ( isset($request['order']) && count($request['order']) ) { |
|
117 | + if (isset($request['order']) && count($request['order'])) { |
|
118 | 118 | $orderBy = array(); |
119 | - $dtColumns = self::pluck( $columns, 'dt' ); |
|
119 | + $dtColumns = self::pluck($columns, 'dt'); |
|
120 | 120 | |
121 | - for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) { |
|
121 | + for ($i = 0, $ien = count($request['order']); $i < $ien; $i++) { |
|
122 | 122 | // Convert the column index into the column data property |
123 | 123 | $columnIdx = intval($request['order'][$i]['column']); |
124 | 124 | $requestColumn = $request['columns'][$columnIdx]; |
125 | 125 | |
126 | - $columnIdx = array_search( $requestColumn['data'], $dtColumns ); |
|
127 | - $column = $columns[ $columnIdx ]; |
|
126 | + $columnIdx = array_search($requestColumn['data'], $dtColumns); |
|
127 | + $column = $columns[$columnIdx]; |
|
128 | 128 | |
129 | - if ( $requestColumn['orderable'] == 'true' ) { |
|
129 | + if ($requestColumn['orderable'] == 'true') { |
|
130 | 130 | $dir = $request['order'][$i]['dir'] === 'asc' ? |
131 | - 'ASC' : |
|
132 | - 'DESC'; |
|
131 | + 'ASC' : 'DESC'; |
|
133 | 132 | |
134 | - $orderBy[] = '`'.$column['db'].'` '.$dir; |
|
133 | + $orderBy[] = '`' . $column['db'] . '` ' . $dir; |
|
135 | 134 | } |
136 | 135 | } |
137 | 136 | |
138 | - $order = 'ORDER BY '.implode(', ', $orderBy); |
|
137 | + $order = 'ORDER BY ' . implode(', ', $orderBy); |
|
139 | 138 | } |
140 | 139 | |
141 | 140 | return $order; |
@@ -157,57 +156,56 @@ discard block |
||
157 | 156 | * sql_exec() function |
158 | 157 | * @return string SQL where clause |
159 | 158 | */ |
160 | - static function filter ( $request, $columns, &$bindings ) |
|
159 | + static function filter($request, $columns, &$bindings) |
|
161 | 160 | { |
162 | 161 | $globalSearch = array(); |
163 | 162 | $columnSearch = array(); |
164 | - $dtColumns = self::pluck( $columns, 'dt' ); |
|
163 | + $dtColumns = self::pluck($columns, 'dt'); |
|
165 | 164 | |
166 | - if ( isset($request['search']) && $request['search']['value'] != '' ) { |
|
165 | + if (isset($request['search']) && $request['search']['value'] != '') { |
|
167 | 166 | $str = $request['search']['value']; |
168 | 167 | |
169 | - for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) { |
|
168 | + for ($i = 0, $ien = count($request['columns']); $i < $ien; $i++) { |
|
170 | 169 | $requestColumn = $request['columns'][$i]; |
171 | - $columnIdx = array_search( $requestColumn['data'], $dtColumns ); |
|
172 | - $column = $columns[ $columnIdx ]; |
|
170 | + $columnIdx = array_search($requestColumn['data'], $dtColumns); |
|
171 | + $column = $columns[$columnIdx]; |
|
173 | 172 | |
174 | - if ( $requestColumn['searchable'] == 'true' ) { |
|
175 | - $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR ); |
|
176 | - $globalSearch[] = "`".$column['db']."` LIKE ".$binding; |
|
173 | + if ($requestColumn['searchable'] == 'true') { |
|
174 | + $binding = self::bind($bindings, '%' . $str . '%', PDO::PARAM_STR); |
|
175 | + $globalSearch[] = "`" . $column['db'] . "` LIKE " . $binding; |
|
177 | 176 | } |
178 | 177 | } |
179 | 178 | } |
180 | 179 | |
181 | 180 | // Individual column filtering |
182 | - for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) { |
|
181 | + for ($i = 0, $ien = count($request['columns']); $i < $ien; $i++) { |
|
183 | 182 | $requestColumn = $request['columns'][$i]; |
184 | - $columnIdx = array_search( $requestColumn['data'], $dtColumns ); |
|
185 | - $column = $columns[ $columnIdx ]; |
|
183 | + $columnIdx = array_search($requestColumn['data'], $dtColumns); |
|
184 | + $column = $columns[$columnIdx]; |
|
186 | 185 | |
187 | 186 | $str = $requestColumn['search']['value']; |
188 | 187 | |
189 | - if ( $requestColumn['searchable'] == 'true' && |
|
190 | - $str != '' ) { |
|
191 | - $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR ); |
|
192 | - $columnSearch[] = "`".$column['db']."` LIKE ".$binding; |
|
188 | + if ($requestColumn['searchable'] == 'true' && |
|
189 | + $str != '') { |
|
190 | + $binding = self::bind($bindings, '%' . $str . '%', PDO::PARAM_STR); |
|
191 | + $columnSearch[] = "`" . $column['db'] . "` LIKE " . $binding; |
|
193 | 192 | } |
194 | 193 | } |
195 | 194 | |
196 | 195 | // Combine the filters into a single string |
197 | 196 | $where = ''; |
198 | 197 | |
199 | - if ( count( $globalSearch ) ) { |
|
200 | - $where = '('.implode(' OR ', $globalSearch).')'; |
|
198 | + if (count($globalSearch)) { |
|
199 | + $where = '(' . implode(' OR ', $globalSearch) . ')'; |
|
201 | 200 | } |
202 | 201 | |
203 | - if ( count( $columnSearch ) ) { |
|
202 | + if (count($columnSearch)) { |
|
204 | 203 | $where = $where === '' ? |
205 | - implode(' AND ', $columnSearch) : |
|
206 | - $where .' AND '. implode(' AND ', $columnSearch); |
|
204 | + implode(' AND ', $columnSearch) : $where . ' AND ' . implode(' AND ', $columnSearch); |
|
207 | 205 | } |
208 | 206 | |
209 | - if ( $where !== '' ) { |
|
210 | - $where = 'WHERE '.$where; |
|
207 | + if ($where !== '') { |
|
208 | + $where = 'WHERE ' . $where; |
|
211 | 209 | } |
212 | 210 | |
213 | 211 | return $where; |
@@ -228,19 +226,19 @@ discard block |
||
228 | 226 | * @param array $columns Column information array |
229 | 227 | * @return array Server-side processing response array |
230 | 228 | */ |
231 | - static function simple ( $request, $conn, $table, $primaryKey, $columns ) |
|
229 | + static function simple($request, $conn, $table, $primaryKey, $columns) |
|
232 | 230 | { |
233 | 231 | $bindings = array(); |
234 | - $db = self::db( $conn ); |
|
232 | + $db = self::db($conn); |
|
235 | 233 | |
236 | 234 | // Build the SQL query string from the request |
237 | - $limit = self::limit( $request, $columns ); |
|
238 | - $order = self::order( $request, $columns ); |
|
239 | - $where = self::filter( $request, $columns, $bindings ); |
|
235 | + $limit = self::limit($request, $columns); |
|
236 | + $order = self::order($request, $columns); |
|
237 | + $where = self::filter($request, $columns, $bindings); |
|
240 | 238 | |
241 | 239 | // Main query to actually get the data |
242 | - $data = self::sql_exec( $db, $bindings, |
|
243 | - "SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."` |
|
240 | + $data = self::sql_exec($db, $bindings, |
|
241 | + "SELECT SQL_CALC_FOUND_ROWS `" . implode("`, `", self::pluck($columns, 'db')) . "` |
|
244 | 242 | FROM `$table` |
245 | 243 | $where |
246 | 244 | $order |
@@ -248,13 +246,13 @@ discard block |
||
248 | 246 | ); |
249 | 247 | |
250 | 248 | // Data set length after filtering |
251 | - $resFilterLength = self::sql_exec( $db, |
|
249 | + $resFilterLength = self::sql_exec($db, |
|
252 | 250 | "SELECT FOUND_ROWS()" |
253 | 251 | ); |
254 | 252 | $recordsFiltered = $resFilterLength[0][0]; |
255 | 253 | |
256 | 254 | // Total data set length |
257 | - $resTotalLength = self::sql_exec( $db, |
|
255 | + $resTotalLength = self::sql_exec($db, |
|
258 | 256 | "SELECT COUNT(`{$primaryKey}`) |
259 | 257 | FROM `$table`" |
260 | 258 | ); |
@@ -265,10 +263,10 @@ discard block |
||
265 | 263 | * Output |
266 | 264 | */ |
267 | 265 | return array( |
268 | - "draw" => intval( $request['draw'] ), |
|
269 | - "recordsTotal" => intval( $recordsTotal ), |
|
270 | - "recordsFiltered" => intval( $recordsFiltered ), |
|
271 | - "data" => self::data_output( $columns, $data ) |
|
266 | + "draw" => intval($request['draw']), |
|
267 | + "recordsTotal" => intval($recordsTotal), |
|
268 | + "recordsFiltered" => intval($recordsFiltered), |
|
269 | + "data" => self::data_output($columns, $data) |
|
272 | 270 | ); |
273 | 271 | } |
274 | 272 | |
@@ -296,39 +294,37 @@ discard block |
||
296 | 294 | * @param string $whereAll WHERE condition to apply to all queries |
297 | 295 | * @return array Server-side processing response array |
298 | 296 | */ |
299 | - static function complex ( $request, $conn, $table, $primaryKey, $columns, $whereResult=null, $whereAll=null ) |
|
297 | + static function complex($request, $conn, $table, $primaryKey, $columns, $whereResult = null, $whereAll = null) |
|
300 | 298 | { |
301 | 299 | $bindings = array(); |
302 | - $db = self::db( $conn ); |
|
300 | + $db = self::db($conn); |
|
303 | 301 | $localWhereResult = array(); |
304 | 302 | $localWhereAll = array(); |
305 | 303 | $whereAllSql = ''; |
306 | 304 | |
307 | 305 | // Build the SQL query string from the request |
308 | - $limit = self::limit( $request, $columns ); |
|
309 | - $order = self::order( $request, $columns ); |
|
310 | - $where = self::filter( $request, $columns, $bindings ); |
|
306 | + $limit = self::limit($request, $columns); |
|
307 | + $order = self::order($request, $columns); |
|
308 | + $where = self::filter($request, $columns, $bindings); |
|
311 | 309 | |
312 | - $whereResult = self::_flatten( $whereResult ); |
|
313 | - $whereAll = self::_flatten( $whereAll ); |
|
310 | + $whereResult = self::_flatten($whereResult); |
|
311 | + $whereAll = self::_flatten($whereAll); |
|
314 | 312 | |
315 | - if ( $whereResult ) { |
|
313 | + if ($whereResult) { |
|
316 | 314 | $where = $where ? |
317 | - $where .' AND '.$whereResult : |
|
318 | - 'WHERE '.$whereResult; |
|
315 | + $where . ' AND ' . $whereResult : 'WHERE ' . $whereResult; |
|
319 | 316 | } |
320 | 317 | |
321 | - if ( $whereAll ) { |
|
318 | + if ($whereAll) { |
|
322 | 319 | $where = $where ? |
323 | - $where .' AND '.$whereAll : |
|
324 | - 'WHERE '.$whereAll; |
|
320 | + $where . ' AND ' . $whereAll : 'WHERE ' . $whereAll; |
|
325 | 321 | |
326 | - $whereAllSql = 'WHERE '.$whereAll; |
|
322 | + $whereAllSql = 'WHERE ' . $whereAll; |
|
327 | 323 | } |
328 | 324 | |
329 | 325 | // Main query to actually get the data |
330 | - $data = self::sql_exec( $db, $bindings, |
|
331 | - "SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."` |
|
326 | + $data = self::sql_exec($db, $bindings, |
|
327 | + "SELECT SQL_CALC_FOUND_ROWS `" . implode("`, `", self::pluck($columns, 'db')) . "` |
|
332 | 328 | FROM `$table` |
333 | 329 | $where |
334 | 330 | $order |
@@ -336,15 +332,15 @@ discard block |
||
336 | 332 | ); |
337 | 333 | |
338 | 334 | // Data set length after filtering |
339 | - $resFilterLength = self::sql_exec( $db, |
|
335 | + $resFilterLength = self::sql_exec($db, |
|
340 | 336 | "SELECT FOUND_ROWS()" |
341 | 337 | ); |
342 | 338 | $recordsFiltered = $resFilterLength[0][0]; |
343 | 339 | |
344 | 340 | // Total data set length |
345 | - $resTotalLength = self::sql_exec( $db, $bindings, |
|
341 | + $resTotalLength = self::sql_exec($db, $bindings, |
|
346 | 342 | "SELECT COUNT(`{$primaryKey}`) |
347 | - FROM `$table` ". |
|
343 | + FROM `$table` " . |
|
348 | 344 | $whereAllSql |
349 | 345 | ); |
350 | 346 | $recordsTotal = $resTotalLength[0][0]; |
@@ -353,10 +349,10 @@ discard block |
||
353 | 349 | * Output |
354 | 350 | */ |
355 | 351 | return array( |
356 | - "draw" => intval( $request['draw'] ), |
|
357 | - "recordsTotal" => intval( $recordsTotal ), |
|
358 | - "recordsFiltered" => intval( $recordsFiltered ), |
|
359 | - "data" => self::data_output( $columns, $data ) |
|
352 | + "draw" => intval($request['draw']), |
|
353 | + "recordsTotal" => intval($recordsTotal), |
|
354 | + "recordsFiltered" => intval($recordsFiltered), |
|
355 | + "data" => self::data_output($columns, $data) |
|
360 | 356 | ); |
361 | 357 | } |
362 | 358 | |
@@ -372,20 +368,20 @@ discard block |
||
372 | 368 | * * pass - user password |
373 | 369 | * @return resource Database connection handle |
374 | 370 | */ |
375 | - static function sql_connect ( $sql_details ) |
|
371 | + static function sql_connect($sql_details) |
|
376 | 372 | { |
377 | 373 | try { |
378 | 374 | $db = @new PDO( |
379 | 375 | "mysql:host={$sql_details['host']};dbname={$sql_details['db']}", |
380 | 376 | $sql_details['user'], |
381 | 377 | $sql_details['pass'], |
382 | - array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ) |
|
378 | + array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION) |
|
383 | 379 | ); |
384 | 380 | } |
385 | 381 | catch (PDOException $e) { |
386 | 382 | self::fatal( |
387 | - "An error occurred while connecting to the database. ". |
|
388 | - "The error reported by the server was: ".$e->getMessage() |
|
383 | + "An error occurred while connecting to the database. " . |
|
384 | + "The error reported by the server was: " . $e->getMessage() |
|
389 | 385 | ); |
390 | 386 | } |
391 | 387 | |
@@ -403,21 +399,21 @@ discard block |
||
403 | 399 | * @param string $sql SQL query to execute. |
404 | 400 | * @return array Result from the query (all rows) |
405 | 401 | */ |
406 | - static function sql_exec ( $db, $bindings, $sql=null ) |
|
402 | + static function sql_exec($db, $bindings, $sql = null) |
|
407 | 403 | { |
408 | 404 | // Argument shifting |
409 | - if ( $sql === null ) { |
|
405 | + if ($sql === null) { |
|
410 | 406 | $sql = $bindings; |
411 | 407 | } |
412 | 408 | |
413 | - $stmt = $db->prepare( $sql ); |
|
409 | + $stmt = $db->prepare($sql); |
|
414 | 410 | //echo $sql; |
415 | 411 | |
416 | 412 | // Bind parameters |
417 | - if ( is_array( $bindings ) ) { |
|
418 | - for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) { |
|
413 | + if (is_array($bindings)) { |
|
414 | + for ($i = 0, $ien = count($bindings); $i < $ien; $i++) { |
|
419 | 415 | $binding = $bindings[$i]; |
420 | - $stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] ); |
|
416 | + $stmt->bindValue($binding['key'], $binding['val'], $binding['type']); |
|
421 | 417 | } |
422 | 418 | } |
423 | 419 | |
@@ -426,7 +422,7 @@ discard block |
||
426 | 422 | $stmt->execute(); |
427 | 423 | } |
428 | 424 | catch (PDOException $e) { |
429 | - self::fatal( "An SQL error occurred: ".$e->getMessage() ); |
|
425 | + self::fatal("An SQL error occurred: " . $e->getMessage()); |
|
430 | 426 | } |
431 | 427 | |
432 | 428 | // Return all |
@@ -446,11 +442,11 @@ discard block |
||
446 | 442 | * |
447 | 443 | * @param string $msg Message to send to the client |
448 | 444 | */ |
449 | - static function fatal ( $msg ) |
|
445 | + static function fatal($msg) |
|
450 | 446 | { |
451 | - echo json_encode( array( |
|
447 | + echo json_encode(array( |
|
452 | 448 | "error" => $msg |
453 | - ) ); |
|
449 | + )); |
|
454 | 450 | |
455 | 451 | exit(0); |
456 | 452 | } |
@@ -465,9 +461,9 @@ discard block |
||
465 | 461 | * @return string Bound key to be used in the SQL where this parameter |
466 | 462 | * would be used. |
467 | 463 | */ |
468 | - static function bind ( &$a, $val, $type ) |
|
464 | + static function bind(&$a, $val, $type) |
|
469 | 465 | { |
470 | - $key = ':binding_'.count( $a ); |
|
466 | + $key = ':binding_' . count($a); |
|
471 | 467 | |
472 | 468 | $a[] = array( |
473 | 469 | 'key' => $key, |
@@ -487,11 +483,11 @@ discard block |
||
487 | 483 | * @param string $prop Property to read |
488 | 484 | * @return array Array of property values |
489 | 485 | */ |
490 | - static function pluck ( $a, $prop ) |
|
486 | + static function pluck($a, $prop) |
|
491 | 487 | { |
492 | 488 | $out = array(); |
493 | 489 | |
494 | - for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) { |
|
490 | + for ($i = 0, $len = count($a); $i < $len; $i++) { |
|
495 | 491 | $out[] = $a[$i][$prop]; |
496 | 492 | } |
497 | 493 | |
@@ -506,13 +502,13 @@ discard block |
||
506 | 502 | * @param string $join Glue for the concatenation |
507 | 503 | * @return string Joined string |
508 | 504 | */ |
509 | - static function _flatten ( $a, $join = ' AND ' ) |
|
505 | + static function _flatten($a, $join = ' AND ') |
|
510 | 506 | { |
511 | - if ( ! $a ) { |
|
507 | + if (!$a) { |
|
512 | 508 | return ''; |
513 | 509 | } |
514 | - else if ( $a && is_array($a) ) { |
|
515 | - return implode( $join, $a ); |
|
510 | + else if ($a && is_array($a)) { |
|
511 | + return implode($join, $a); |
|
516 | 512 | } |
517 | 513 | return $a; |
518 | 514 | } |
@@ -15,22 +15,22 @@ discard block |
||
15 | 15 | // parameter represents the DataTables column identifier. In this case object |
16 | 16 | // parameter names |
17 | 17 | $columns = array( |
18 | - array( 'db' => 'first_name', 'dt' => 'first_name' ), |
|
19 | - array( 'db' => 'last_name', 'dt' => 'last_name' ), |
|
20 | - array( 'db' => 'position', 'dt' => 'position' ), |
|
21 | - array( 'db' => 'office', 'dt' => 'office' ), |
|
18 | + array('db' => 'first_name', 'dt' => 'first_name'), |
|
19 | + array('db' => 'last_name', 'dt' => 'last_name'), |
|
20 | + array('db' => 'position', 'dt' => 'position'), |
|
21 | + array('db' => 'office', 'dt' => 'office'), |
|
22 | 22 | array( |
23 | 23 | 'db' => 'start_date', |
24 | 24 | 'dt' => 'start_date', |
25 | - 'formatter' => function( $d, $row ) { |
|
26 | - return date( 'jS M y', strtotime($d)); |
|
25 | + 'formatter' => function($d, $row) { |
|
26 | + return date('jS M y', strtotime($d)); |
|
27 | 27 | } |
28 | 28 | ), |
29 | 29 | array( |
30 | 30 | 'db' => 'salary', |
31 | 31 | 'dt' => 'salary', |
32 | - 'formatter' => function( $d, $row ) { |
|
33 | - return '$'.number_format($d); |
|
32 | + 'formatter' => function($d, $row) { |
|
33 | + return '$' . number_format($d); |
|
34 | 34 | } |
35 | 35 | ) |
36 | 36 | ); |
@@ -49,9 +49,9 @@ discard block |
||
49 | 49 | * server-side, there is no need to edit below this line. |
50 | 50 | */ |
51 | 51 | |
52 | -require( 'ssp.class.php' ); |
|
52 | +require('ssp.class.php'); |
|
53 | 53 | |
54 | 54 | echo json_encode( |
55 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
55 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
56 | 56 | ); |
57 | 57 |
@@ -32,29 +32,29 @@ discard block |
||
32 | 32 | array( |
33 | 33 | 'db' => 'id', |
34 | 34 | 'dt' => 'DT_RowId', |
35 | - 'formatter' => function( $d, $row ) { |
|
35 | + 'formatter' => function($d, $row) { |
|
36 | 36 | // Technically a DOM id cannot start with an integer, so we prefix |
37 | 37 | // a string. This can also be useful if you have multiple tables |
38 | 38 | // to ensure that the id is unique with a different prefix |
39 | - return 'row_'.$d; |
|
39 | + return 'row_' . $d; |
|
40 | 40 | } |
41 | 41 | ), |
42 | - array( 'db' => 'first_name', 'dt' => 'first_name' ), |
|
43 | - array( 'db' => 'last_name', 'dt' => 'last_name' ), |
|
44 | - array( 'db' => 'position', 'dt' => 'position' ), |
|
45 | - array( 'db' => 'office', 'dt' => 'office' ), |
|
42 | + array('db' => 'first_name', 'dt' => 'first_name'), |
|
43 | + array('db' => 'last_name', 'dt' => 'last_name'), |
|
44 | + array('db' => 'position', 'dt' => 'position'), |
|
45 | + array('db' => 'office', 'dt' => 'office'), |
|
46 | 46 | array( |
47 | 47 | 'db' => 'start_date', |
48 | 48 | 'dt' => 'start_date', |
49 | - 'formatter' => function( $d, $row ) { |
|
50 | - return date( 'jS M y', strtotime($d)); |
|
49 | + 'formatter' => function($d, $row) { |
|
50 | + return date('jS M y', strtotime($d)); |
|
51 | 51 | } |
52 | 52 | ), |
53 | 53 | array( |
54 | 54 | 'db' => 'salary', |
55 | 55 | 'dt' => 'salary', |
56 | - 'formatter' => function( $d, $row ) { |
|
57 | - return '$'.number_format($d); |
|
56 | + 'formatter' => function($d, $row) { |
|
57 | + return '$' . number_format($d); |
|
58 | 58 | } |
59 | 59 | ) |
60 | 60 | ); |
@@ -72,9 +72,9 @@ discard block |
||
72 | 72 | * server-side, there is no need to edit below this line. |
73 | 73 | */ |
74 | 74 | |
75 | -require( 'ssp.class.php' ); |
|
75 | +require('ssp.class.php'); |
|
76 | 76 | |
77 | 77 | echo json_encode( |
78 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
78 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
79 | 79 | ); |
80 | 80 |
@@ -1,7 +1,7 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if ( isset( $_POST['src'] ) && preg_match( '/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src'] ) !== 0 ) { |
|
4 | - echo htmlspecialchars( file_get_contents( '../server_side/'.$_POST['src'] ) ); |
|
3 | +if (isset($_POST['src']) && preg_match('/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src']) !== 0) { |
|
4 | + echo htmlspecialchars(file_get_contents('../server_side/' . $_POST['src'])); |
|
5 | 5 | } |
6 | 6 | else { |
7 | 7 | echo ''; |
@@ -29,11 +29,11 @@ discard block |
||
29 | 29 | // parameter represents the DataTables column identifier. In this case simple |
30 | 30 | // indexes |
31 | 31 | $columns = array( |
32 | - array( 'db' => 'id', 'dt' => 0 ), |
|
33 | - array( 'db' => 'firstname', 'dt' => 1 ), |
|
34 | - array( 'db' => 'surname', 'dt' => 2 ), |
|
35 | - array( 'db' => 'zip', 'dt' => 3 ), |
|
36 | - array( 'db' => 'country', 'dt' => 4 ) |
|
32 | + array('db' => 'id', 'dt' => 0), |
|
33 | + array('db' => 'firstname', 'dt' => 1), |
|
34 | + array('db' => 'surname', 'dt' => 2), |
|
35 | + array('db' => 'zip', 'dt' => 3), |
|
36 | + array('db' => 'country', 'dt' => 4) |
|
37 | 37 | ); |
38 | 38 | |
39 | 39 | // SQL server connection information |
@@ -50,9 +50,9 @@ discard block |
||
50 | 50 | * server-side, there is no need to edit below this line. |
51 | 51 | */ |
52 | 52 | |
53 | -require( '../../../../examples/server_side/scripts/ssp.class.php' ); |
|
53 | +require('../../../../examples/server_side/scripts/ssp.class.php'); |
|
54 | 54 | |
55 | 55 | echo json_encode( |
56 | - SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) |
|
56 | + SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns) |
|
57 | 57 | ); |
58 | 58 |