abterphp / propeller-admin

resources/rawassets/components/data-table/examples/server_side/scripts/jsonp.php

Indentation +27 added lines, -27 removed lines

@@ -29,31 +29,31 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
-	array(
-		'db'        => 'start_date',
-		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
-		}
-	),
-	array(
-		'db'        => 'salary',
-		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
-		}
-	)
+    array( 'db' => 'first_name', 'dt' => 0 ),
+    array( 'db' => 'last_name',  'dt' => 1 ),
+    array( 'db' => 'position',   'dt' => 2 ),
+    array( 'db' => 'office',     'dt' => 3 ),
+    array(
+        'db'        => 'start_date',
+        'dt'        => 4,
+        'formatter' => function( $d, $row ) {
+            return date( 'jS M y', strtotime($d));
+        }
+    ),
+    array(
+        'db'        => 'salary',
+        'dt'        => 5,
+        'formatter' => function( $d, $row ) {
+            return '$'.number_format($d);
+        }
+    )
 );
 
 $sql_details = array(
-	'user' => '',
-	'pass' => '',
-	'db'   => '',
-	'host' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -65,12 +65,12 @@ 
 
 // Validate the JSONP to make use it is an okay Javascript function to execute
 $jsonp = preg_match('/^[$A-Z_][0-9A-Z_$]*$/i', $_GET['callback']) ?
-	$_GET['callback'] :
-	false;
+    $_GET['callback'] :
+    false;
 
 if ( $jsonp ) {
-	echo $jsonp.'('.json_encode(
-		SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
-	).');';
+    echo $jsonp.'('.json_encode(
+        SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    ).');';
 }
 

Spacing +14 added lines, -15 removed lines

@@ -29,22 +29,22 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
+	array('db' => 'first_name', 'dt' => 0),
+	array('db' => 'last_name', 'dt' => 1),
+	array('db' => 'position', 'dt' => 2),
+	array('db' => 'office', 'dt' => 3),
 	array(
 		'db'        => 'start_date',
 		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -61,16 +61,15 @@ 
  * 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' );
+require('ssp.class.php');
 
 // Validate the JSONP to make use it is an okay Javascript function to execute
 $jsonp = preg_match('/^[$A-Z_][0-9A-Z_$]*$/i', $_GET['callback']) ?
-	$_GET['callback'] :
-	false;
+	$_GET['callback'] : false;
 
-if ( $jsonp ) {
-	echo $jsonp.'('.json_encode(
-		SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
-	).');';
+if ($jsonp) {
+	echo $jsonp . '(' . json_encode(
+		SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
+	) . ');';
 }
 

resources/rawassets/components/data-table/examples/server_side/scripts/ids-arrays.php

Indentation +33 added lines, -33 removed lines

@@ -29,42 +29,42 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes + the primary key column for the id
 $columns = array(
-	array(
-		'db' => 'id',
-		'dt' => 'DT_RowId',
-		'formatter' => function( $d, $row ) {
-			// Technically a DOM id cannot start with an integer, so we prefix
-			// a string. This can also be useful if you have multiple tables
-			// to ensure that the id is unique with a different prefix
-			return 'row_'.$d;
-		}
-	),
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
-	array(
-		'db'        => 'start_date',
-		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
-		}
-	),
-	array(
-		'db'        => 'salary',
-		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
-		}
-	)
+    array(
+        'db' => 'id',
+        'dt' => 'DT_RowId',
+        'formatter' => function( $d, $row ) {
+            // Technically a DOM id cannot start with an integer, so we prefix
+            // a string. This can also be useful if you have multiple tables
+            // to ensure that the id is unique with a different prefix
+            return 'row_'.$d;
+        }
+    ),
+    array( 'db' => 'first_name', 'dt' => 0 ),
+    array( 'db' => 'last_name',  'dt' => 1 ),
+    array( 'db' => 'position',   'dt' => 2 ),
+    array( 'db' => 'office',     'dt' => 3 ),
+    array(
+        'db'        => 'start_date',
+        'dt'        => 4,
+        'formatter' => function( $d, $row ) {
+            return date( 'jS M y', strtotime($d));
+        }
+    ),
+    array(
+        'db'        => 'salary',
+        'dt'        => 5,
+        'formatter' => function( $d, $row ) {
+            return '$'.number_format($d);
+        }
+    )
 );
 
 // SQL server connection information
 $sql_details = array(
-	'user' => '',
-	'pass' => '',
-	'db'   => '',
-	'host' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -76,6 +76,6 @@ 
 require( 'ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
 );
 

Spacing +12 added lines, -12 removed lines

@@ -32,29 +32,29 @@ 
 	array(
 		'db' => 'id',
 		'dt' => 'DT_RowId',
-		'formatter' => function( $d, $row ) {
+		'formatter' => function($d, $row) {
 			// Technically a DOM id cannot start with an integer, so we prefix
 			// a string. This can also be useful if you have multiple tables
 			// to ensure that the id is unique with a different prefix
-			return 'row_'.$d;
+			return 'row_' . $d;
 		}
 	),
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
+	array('db' => 'first_name', 'dt' => 0),
+	array('db' => 'last_name', 'dt' => 1),
+	array('db' => 'position', 'dt' => 2),
+	array('db' => 'office', 'dt' => 3),
 	array(
 		'db'        => 'start_date',
 		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -73,9 +73,9 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( 'ssp.class.php' );
+require('ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
 );
 

resources/rawassets/components/data-table/examples/server_side/scripts/post.php

Indentation +23 added lines, -23 removed lines

@@ -29,32 +29,32 @@ 
 // 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);
-		}
-	)
+    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' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -66,6 +66,6 @@ 
 require( 'ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns )
 );
 

Spacing +10 added lines, -10 removed lines

@@ -29,22 +29,22 @@ 
 // 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' => '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));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 'salary',
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -63,9 +63,9 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( 'ssp.class.php' );
+require('ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_POST, $sql_details, $table, $primaryKey, $columns)
 );
 

resources/rawassets/components/data-table/examples/server_side/scripts/server_processing.php

Indentation +23 added lines, -23 removed lines

@@ -29,32 +29,32 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
-	array(
-		'db'        => 'start_date',
-		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
-		}
-	),
-	array(
-		'db'        => 'salary',
-		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
-		}
-	)
+    array( 'db' => 'first_name', 'dt' => 0 ),
+    array( 'db' => 'last_name',  'dt' => 1 ),
+    array( 'db' => 'position',   'dt' => 2 ),
+    array( 'db' => 'office',     'dt' => 3 ),
+    array(
+        'db'        => 'start_date',
+        'dt'        => 4,
+        'formatter' => function( $d, $row ) {
+            return date( 'jS M y', strtotime($d));
+        }
+    ),
+    array(
+        'db'        => 'salary',
+        'dt'        => 5,
+        'formatter' => function( $d, $row ) {
+            return '$'.number_format($d);
+        }
+    )
 );
 
 // SQL server connection information
 $sql_details = array(
-	'user' => '',
-	'pass' => '',
-	'db'   => '',
-	'host' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -66,7 +66,7 @@ 
 require( 'ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
 );
 
 

Spacing +10 added lines, -10 removed lines

@@ -29,22 +29,22 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'first_name', 'dt' => 0 ),
-	array( 'db' => 'last_name',  'dt' => 1 ),
-	array( 'db' => 'position',   'dt' => 2 ),
-	array( 'db' => 'office',     'dt' => 3 ),
+	array('db' => 'first_name', 'dt' => 0),
+	array('db' => 'last_name', 'dt' => 1),
+	array('db' => 'position', 'dt' => 2),
+	array('db' => 'office', 'dt' => 3),
 	array(
 		'db'        => 'start_date',
 		'dt'        => 4,
-		'formatter' => function( $d, $row ) {
-			return date( 'jS M y', strtotime($d));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 5,
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -63,10 +63,10 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( 'ssp.class.php' );
+require('ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
 );
 
 

resources/rawassets/components/data-table/examples/server_side/scripts/ssp.class.php

Indentation +469 added lines, -469 removed lines

@@ -19,502 +19,502 @@
 // REMOVE THIS BLOCK - used for DataTables test environment only!
 $file = $_SERVER['DOCUMENT_ROOT'].'/datatables/mysql.php';
 if ( is_file( $file ) ) {
-	include( $file );
+    include( $file );
 }
 
 
 class SSP {
-	/**
-	 * Create the data output array for the DataTables rows
-	 *
-	 *  @param  array $columns Column information array
-	 *  @param  array $data    Data from the SQL get
-	 *  @return array          Formatted data in a row based format
-	 */
-	static function data_output ( $columns, $data )
-	{
-		$out = array();
-
-		for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {
-			$row = array();
-
-			for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) {
-				$column = $columns[$j];
-
-				// Is there a formatter?
-				if ( isset( $column['formatter'] ) ) {
-					$row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );
-				}
-				else {
-					$row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];
-				}
-			}
-
-			$out[] = $row;
-		}
-
-		return $out;
-	}
-
-
-	/**
-	 * Database connection
-	 *
-	 * Obtain an PHP PDO connection from a connection details array
-	 *
-	 *  @param  array $conn SQL connection details. The array should have
-	 *    the following properties
-	 *     * host - host name
-	 *     * db   - database name
-	 *     * user - user name
-	 *     * pass - user password
-	 *  @return resource PDO connection
-	 */
-	static function db ( $conn )
-	{
-		if ( is_array( $conn ) ) {
-			return self::sql_connect( $conn );
-		}
-
-		return $conn;
-	}
-
-
-	/**
-	 * Paging
-	 *
-	 * Construct the LIMIT clause for server-side processing SQL query
-	 *
-	 *  @param  array $request Data sent to server by DataTables
-	 *  @param  array $columns Column information array
-	 *  @return string SQL limit clause
-	 */
-	static function limit ( $request, $columns )
-	{
-		$limit = '';
-
-		if ( isset($request['start']) && $request['length'] != -1 ) {
-			$limit = "LIMIT ".intval($request['start']).", ".intval($request['length']);
-		}
-
-		return $limit;
-	}
-
-
-	/**
-	 * Ordering
-	 *
-	 * Construct the ORDER BY clause for server-side processing SQL query
-	 *
-	 *  @param  array $request Data sent to server by DataTables
-	 *  @param  array $columns Column information array
-	 *  @return string SQL order by clause
-	 */
-	static function order ( $request, $columns )
-	{
-		$order = '';
-
-		if ( isset($request['order']) && count($request['order']) ) {
-			$orderBy = array();
-			$dtColumns = self::pluck( $columns, 'dt' );
-
-			for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) {
-				// Convert the column index into the column data property
-				$columnIdx = intval($request['order'][$i]['column']);
-				$requestColumn = $request['columns'][$columnIdx];
-
-				$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-				$column = $columns[ $columnIdx ];
-
-				if ( $requestColumn['orderable'] == 'true' ) {
-					$dir = $request['order'][$i]['dir'] === 'asc' ?
-						'ASC' :
-						'DESC';
-
-					$orderBy[] = '`'.$column['db'].'` '.$dir;
-				}
-			}
-
-			$order = 'ORDER BY '.implode(', ', $orderBy);
-		}
-
-		return $order;
-	}
-
-
-	/**
-	 * Searching / Filtering
-	 *
-	 * Construct the WHERE clause for server-side processing SQL query.
-	 *
-	 * NOTE this does not match the built-in DataTables filtering which does it
-	 * word by word on any field. It's possible to do here performance on large
-	 * databases would be very poor
-	 *
-	 *  @param  array $request Data sent to server by DataTables
-	 *  @param  array $columns Column information array
-	 *  @param  array $bindings Array of values for PDO bindings, used in the
-	 *    sql_exec() function
-	 *  @return string SQL where clause
-	 */
-	static function filter ( $request, $columns, &$bindings )
-	{
-		$globalSearch = array();
-		$columnSearch = array();
-		$dtColumns = self::pluck( $columns, 'dt' );
-
-		if ( isset($request['search']) && $request['search']['value'] != '' ) {
-			$str = $request['search']['value'];
-
-			for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
-				$requestColumn = $request['columns'][$i];
-				$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-				$column = $columns[ $columnIdx ];
-
-				if ( $requestColumn['searchable'] == 'true' ) {
-					$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
-					$globalSearch[] = "`".$column['db']."` LIKE ".$binding;
-				}
-			}
-		}
-
-		// Individual column filtering
-		for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
-			$requestColumn = $request['columns'][$i];
-			$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-			$column = $columns[ $columnIdx ];
-
-			$str = $requestColumn['search']['value'];
-
-			if ( $requestColumn['searchable'] == 'true' &&
-			 $str != '' ) {
-				$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
-				$columnSearch[] = "`".$column['db']."` LIKE ".$binding;
-			}
-		}
-
-		// Combine the filters into a single string
-		$where = '';
-
-		if ( count( $globalSearch ) ) {
-			$where = '('.implode(' OR ', $globalSearch).')';
-		}
-
-		if ( count( $columnSearch ) ) {
-			$where = $where === '' ?
-				implode(' AND ', $columnSearch) :
-				$where .' AND '. implode(' AND ', $columnSearch);
-		}
-
-		if ( $where !== '' ) {
-			$where = 'WHERE '.$where;
-		}
-
-		return $where;
-	}
-
-
-	/**
-	 * Perform the SQL queries needed for an server-side processing requested,
-	 * utilising the helper functions of this class, limit(), order() and
-	 * filter() among others. The returned array is ready to be encoded as JSON
-	 * in response to an SSP request, or can be modified if needed before
-	 * sending back to the client.
-	 *
-	 *  @param  array $request Data sent to server by DataTables
-	 *  @param  array|PDO $conn PDO connection resource or connection parameters array
-	 *  @param  string $table SQL table to query
-	 *  @param  string $primaryKey Primary key of the table
-	 *  @param  array $columns Column information array
-	 *  @return array          Server-side processing response array
-	 */
-	static function simple ( $request, $conn, $table, $primaryKey, $columns )
-	{
-		$bindings = array();
-		$db = self::db( $conn );
-
-		// Build the SQL query string from the request
-		$limit = self::limit( $request, $columns );
-		$order = self::order( $request, $columns );
-		$where = self::filter( $request, $columns, $bindings );
-
-		// Main query to actually get the data
-		$data = self::sql_exec( $db, $bindings,
-			"SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
+    /**
+     * Create the data output array for the DataTables rows
+     *
+     *  @param  array $columns Column information array
+     *  @param  array $data    Data from the SQL get
+     *  @return array          Formatted data in a row based format
+     */
+    static function data_output ( $columns, $data )
+    {
+        $out = array();
+
+        for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {
+            $row = array();
+
+            for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) {
+                $column = $columns[$j];
+
+                // Is there a formatter?
+                if ( isset( $column['formatter'] ) ) {
+                    $row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );
+                }
+                else {
+                    $row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];
+                }
+            }
+
+            $out[] = $row;
+        }
+
+        return $out;
+    }
+
+
+    /**
+     * Database connection
+     *
+     * Obtain an PHP PDO connection from a connection details array
+     *
+     *  @param  array $conn SQL connection details. The array should have
+     *    the following properties
+     *     * host - host name
+     *     * db   - database name
+     *     * user - user name
+     *     * pass - user password
+     *  @return resource PDO connection
+     */
+    static function db ( $conn )
+    {
+        if ( is_array( $conn ) ) {
+            return self::sql_connect( $conn );
+        }
+
+        return $conn;
+    }
+
+
+    /**
+     * Paging
+     *
+     * Construct the LIMIT clause for server-side processing SQL query
+     *
+     *  @param  array $request Data sent to server by DataTables
+     *  @param  array $columns Column information array
+     *  @return string SQL limit clause
+     */
+    static function limit ( $request, $columns )
+    {
+        $limit = '';
+
+        if ( isset($request['start']) && $request['length'] != -1 ) {
+            $limit = "LIMIT ".intval($request['start']).", ".intval($request['length']);
+        }
+
+        return $limit;
+    }
+
+
+    /**
+     * Ordering
+     *
+     * Construct the ORDER BY clause for server-side processing SQL query
+     *
+     *  @param  array $request Data sent to server by DataTables
+     *  @param  array $columns Column information array
+     *  @return string SQL order by clause
+     */
+    static function order ( $request, $columns )
+    {
+        $order = '';
+
+        if ( isset($request['order']) && count($request['order']) ) {
+            $orderBy = array();
+            $dtColumns = self::pluck( $columns, 'dt' );
+
+            for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) {
+                // Convert the column index into the column data property
+                $columnIdx = intval($request['order'][$i]['column']);
+                $requestColumn = $request['columns'][$columnIdx];
+
+                $columnIdx = array_search( $requestColumn['data'], $dtColumns );
+                $column = $columns[ $columnIdx ];
+
+                if ( $requestColumn['orderable'] == 'true' ) {
+                    $dir = $request['order'][$i]['dir'] === 'asc' ?
+                        'ASC' :
+                        'DESC';
+
+                    $orderBy[] = '`'.$column['db'].'` '.$dir;
+                }
+            }
+
+            $order = 'ORDER BY '.implode(', ', $orderBy);
+        }
+
+        return $order;
+    }
+
+
+    /**
+     * Searching / Filtering
+     *
+     * Construct the WHERE clause for server-side processing SQL query.
+     *
+     * NOTE this does not match the built-in DataTables filtering which does it
+     * word by word on any field. It's possible to do here performance on large
+     * databases would be very poor
+     *
+     *  @param  array $request Data sent to server by DataTables
+     *  @param  array $columns Column information array
+     *  @param  array $bindings Array of values for PDO bindings, used in the
+     *    sql_exec() function
+     *  @return string SQL where clause
+     */
+    static function filter ( $request, $columns, &$bindings )
+    {
+        $globalSearch = array();
+        $columnSearch = array();
+        $dtColumns = self::pluck( $columns, 'dt' );
+
+        if ( isset($request['search']) && $request['search']['value'] != '' ) {
+            $str = $request['search']['value'];
+
+            for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
+                $requestColumn = $request['columns'][$i];
+                $columnIdx = array_search( $requestColumn['data'], $dtColumns );
+                $column = $columns[ $columnIdx ];
+
+                if ( $requestColumn['searchable'] == 'true' ) {
+                    $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
+                    $globalSearch[] = "`".$column['db']."` LIKE ".$binding;
+                }
+            }
+        }
+
+        // Individual column filtering
+        for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
+            $requestColumn = $request['columns'][$i];
+            $columnIdx = array_search( $requestColumn['data'], $dtColumns );
+            $column = $columns[ $columnIdx ];
+
+            $str = $requestColumn['search']['value'];
+
+            if ( $requestColumn['searchable'] == 'true' &&
+             $str != '' ) {
+                $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
+                $columnSearch[] = "`".$column['db']."` LIKE ".$binding;
+            }
+        }
+
+        // Combine the filters into a single string
+        $where = '';
+
+        if ( count( $globalSearch ) ) {
+            $where = '('.implode(' OR ', $globalSearch).')';
+        }
+
+        if ( count( $columnSearch ) ) {
+            $where = $where === '' ?
+                implode(' AND ', $columnSearch) :
+                $where .' AND '. implode(' AND ', $columnSearch);
+        }
+
+        if ( $where !== '' ) {
+            $where = 'WHERE '.$where;
+        }
+
+        return $where;
+    }
+
+
+    /**
+     * Perform the SQL queries needed for an server-side processing requested,
+     * utilising the helper functions of this class, limit(), order() and
+     * filter() among others. The returned array is ready to be encoded as JSON
+     * in response to an SSP request, or can be modified if needed before
+     * sending back to the client.
+     *
+     *  @param  array $request Data sent to server by DataTables
+     *  @param  array|PDO $conn PDO connection resource or connection parameters array
+     *  @param  string $table SQL table to query
+     *  @param  string $primaryKey Primary key of the table
+     *  @param  array $columns Column information array
+     *  @return array          Server-side processing response array
+     */
+    static function simple ( $request, $conn, $table, $primaryKey, $columns )
+    {
+        $bindings = array();
+        $db = self::db( $conn );
+
+        // Build the SQL query string from the request
+        $limit = self::limit( $request, $columns );
+        $order = self::order( $request, $columns );
+        $where = self::filter( $request, $columns, $bindings );
+
+        // Main query to actually get the data
+        $data = self::sql_exec( $db, $bindings,
+            "SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
 			 FROM `$table`
 			 $where
 			 $order
 			 $limit"
-		);
+        );
 
-		// Data set length after filtering
-		$resFilterLength = self::sql_exec( $db,
-			"SELECT FOUND_ROWS()"
-		);
-		$recordsFiltered = $resFilterLength[0][0];
+        // Data set length after filtering
+        $resFilterLength = self::sql_exec( $db,
+            "SELECT FOUND_ROWS()"
+        );
+        $recordsFiltered = $resFilterLength[0][0];
 
-		// Total data set length
-		$resTotalLength = self::sql_exec( $db,
-			"SELECT COUNT(`{$primaryKey}`)
+        // Total data set length
+        $resTotalLength = self::sql_exec( $db,
+            "SELECT COUNT(`{$primaryKey}`)
 			 FROM   `$table`"
-		);
-		$recordsTotal = $resTotalLength[0][0];
+        );
+        $recordsTotal = $resTotalLength[0][0];
 
 
-		/*
+        /*
 		 * Output
 		 */
-		return array(
-			"draw"            => intval( $request['draw'] ),
-			"recordsTotal"    => intval( $recordsTotal ),
-			"recordsFiltered" => intval( $recordsFiltered ),
-			"data"            => self::data_output( $columns, $data )
-		);
-	}
-
-
-	/**
-	 * The difference between this method and the `simple` one, is that you can
-	 * apply additional `where` conditions to the SQL queries. These can be in
-	 * one of two forms:
-	 *
-	 * * 'Result condition' - This is applied to the result set, but not the
-	 *   overall paging information query - i.e. it will not effect the number
-	 *   of records that a user sees they can have access to. This should be
-	 *   used when you want apply a filtering condition that the user has sent.
-	 * * 'All condition' - This is applied to all queries that are made and
-	 *   reduces the number of records that the user can access. This should be
-	 *   used in conditions where you don't want the user to ever have access to
-	 *   particular records (for example, restricting by a login id).
-	 *
-	 *  @param  array $request Data sent to server by DataTables
-	 *  @param  array|PDO $conn PDO connection resource or connection parameters array
-	 *  @param  string $table SQL table to query
-	 *  @param  string $primaryKey Primary key of the table
-	 *  @param  array $columns Column information array
-	 *  @param  string $whereResult WHERE condition to apply to the result set
-	 *  @param  string $whereAll WHERE condition to apply to all queries
-	 *  @return array          Server-side processing response array
-	 */
-	static function complex ( $request, $conn, $table, $primaryKey, $columns, $whereResult=null, $whereAll=null )
-	{
-		$bindings = array();
-		$db = self::db( $conn );
-		$localWhereResult = array();
-		$localWhereAll = array();
-		$whereAllSql = '';
-
-		// Build the SQL query string from the request
-		$limit = self::limit( $request, $columns );
-		$order = self::order( $request, $columns );
-		$where = self::filter( $request, $columns, $bindings );
-
-		$whereResult = self::_flatten( $whereResult );
-		$whereAll = self::_flatten( $whereAll );
-
-		if ( $whereResult ) {
-			$where = $where ?
-				$where .' AND '.$whereResult :
-				'WHERE '.$whereResult;
-		}
-
-		if ( $whereAll ) {
-			$where = $where ?
-				$where .' AND '.$whereAll :
-				'WHERE '.$whereAll;
-
-			$whereAllSql = 'WHERE '.$whereAll;
-		}
-
-		// Main query to actually get the data
-		$data = self::sql_exec( $db, $bindings,
-			"SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
+        return array(
+            "draw"            => intval( $request['draw'] ),
+            "recordsTotal"    => intval( $recordsTotal ),
+            "recordsFiltered" => intval( $recordsFiltered ),
+            "data"            => self::data_output( $columns, $data )
+        );
+    }
+
+
+    /**
+     * The difference between this method and the `simple` one, is that you can
+     * apply additional `where` conditions to the SQL queries. These can be in
+     * one of two forms:
+     *
+     * * 'Result condition' - This is applied to the result set, but not the
+     *   overall paging information query - i.e. it will not effect the number
+     *   of records that a user sees they can have access to. This should be
+     *   used when you want apply a filtering condition that the user has sent.
+     * * 'All condition' - This is applied to all queries that are made and
+     *   reduces the number of records that the user can access. This should be
+     *   used in conditions where you don't want the user to ever have access to
+     *   particular records (for example, restricting by a login id).
+     *
+     *  @param  array $request Data sent to server by DataTables
+     *  @param  array|PDO $conn PDO connection resource or connection parameters array
+     *  @param  string $table SQL table to query
+     *  @param  string $primaryKey Primary key of the table
+     *  @param  array $columns Column information array
+     *  @param  string $whereResult WHERE condition to apply to the result set
+     *  @param  string $whereAll WHERE condition to apply to all queries
+     *  @return array          Server-side processing response array
+     */
+    static function complex ( $request, $conn, $table, $primaryKey, $columns, $whereResult=null, $whereAll=null )
+    {
+        $bindings = array();
+        $db = self::db( $conn );
+        $localWhereResult = array();
+        $localWhereAll = array();
+        $whereAllSql = '';
+
+        // Build the SQL query string from the request
+        $limit = self::limit( $request, $columns );
+        $order = self::order( $request, $columns );
+        $where = self::filter( $request, $columns, $bindings );
+
+        $whereResult = self::_flatten( $whereResult );
+        $whereAll = self::_flatten( $whereAll );
+
+        if ( $whereResult ) {
+            $where = $where ?
+                $where .' AND '.$whereResult :
+                'WHERE '.$whereResult;
+        }
+
+        if ( $whereAll ) {
+            $where = $where ?
+                $where .' AND '.$whereAll :
+                'WHERE '.$whereAll;
+
+            $whereAllSql = 'WHERE '.$whereAll;
+        }
+
+        // Main query to actually get the data
+        $data = self::sql_exec( $db, $bindings,
+            "SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
 			 FROM `$table`
 			 $where
 			 $order
 			 $limit"
-		);
+        );
 
-		// Data set length after filtering
-		$resFilterLength = self::sql_exec( $db,
-			"SELECT FOUND_ROWS()"
-		);
-		$recordsFiltered = $resFilterLength[0][0];
+        // Data set length after filtering
+        $resFilterLength = self::sql_exec( $db,
+            "SELECT FOUND_ROWS()"
+        );
+        $recordsFiltered = $resFilterLength[0][0];
 
-		// Total data set length
-		$resTotalLength = self::sql_exec( $db, $bindings,
-			"SELECT COUNT(`{$primaryKey}`)
+        // Total data set length
+        $resTotalLength = self::sql_exec( $db, $bindings,
+            "SELECT COUNT(`{$primaryKey}`)
 			 FROM   `$table` ".
-			$whereAllSql
-		);
-		$recordsTotal = $resTotalLength[0][0];
+            $whereAllSql
+        );
+        $recordsTotal = $resTotalLength[0][0];
 
-		/*
+        /*
 		 * Output
 		 */
-		return array(
-			"draw"            => intval( $request['draw'] ),
-			"recordsTotal"    => intval( $recordsTotal ),
-			"recordsFiltered" => intval( $recordsFiltered ),
-			"data"            => self::data_output( $columns, $data )
-		);
-	}
-
-
-	/**
-	 * Connect to the database
-	 *
-	 * @param  array $sql_details SQL server connection details array, with the
-	 *   properties:
-	 *     * host - host name
-	 *     * db   - database name
-	 *     * user - user name
-	 *     * pass - user password
-	 * @return resource Database connection handle
-	 */
-	static function sql_connect ( $sql_details )
-	{
-		try {
-			$db = @new PDO(
-				"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
-				$sql_details['user'],
-				$sql_details['pass'],
-				array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
-			);
-		}
-		catch (PDOException $e) {
-			self::fatal(
-				"An error occurred while connecting to the database. ".
-				"The error reported by the server was: ".$e->getMessage()
-			);
-		}
-
-		return $db;
-	}
-
-
-	/**
-	 * Execute an SQL query on the database
-	 *
-	 * @param  resource $db  Database handler
-	 * @param  array    $bindings Array of PDO binding values from bind() to be
-	 *   used for safely escaping strings. Note that this can be given as the
-	 *   SQL query string if no bindings are required.
-	 * @param  string   $sql SQL query to execute.
-	 * @return array         Result from the query (all rows)
-	 */
-	static function sql_exec ( $db, $bindings, $sql=null )
-	{
-		// Argument shifting
-		if ( $sql === null ) {
-			$sql = $bindings;
-		}
-
-		$stmt = $db->prepare( $sql );
-		//echo $sql;
-
-		// Bind parameters
-		if ( is_array( $bindings ) ) {
-			for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) {
-				$binding = $bindings[$i];
-				$stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] );
-			}
-		}
-
-		// Execute
-		try {
-			$stmt->execute();
-		}
-		catch (PDOException $e) {
-			self::fatal( "An SQL error occurred: ".$e->getMessage() );
-		}
-
-		// Return all
-		return $stmt->fetchAll();
-	}
-
-
-	/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
+        return array(
+            "draw"            => intval( $request['draw'] ),
+            "recordsTotal"    => intval( $recordsTotal ),
+            "recordsFiltered" => intval( $recordsFiltered ),
+            "data"            => self::data_output( $columns, $data )
+        );
+    }
+
+
+    /**
+     * Connect to the database
+     *
+     * @param  array $sql_details SQL server connection details array, with the
+     *   properties:
+     *     * host - host name
+     *     * db   - database name
+     *     * user - user name
+     *     * pass - user password
+     * @return resource Database connection handle
+     */
+    static function sql_connect ( $sql_details )
+    {
+        try {
+            $db = @new PDO(
+                "mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
+                $sql_details['user'],
+                $sql_details['pass'],
+                array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
+            );
+        }
+        catch (PDOException $e) {
+            self::fatal(
+                "An error occurred while connecting to the database. ".
+                "The error reported by the server was: ".$e->getMessage()
+            );
+        }
+
+        return $db;
+    }
+
+
+    /**
+     * Execute an SQL query on the database
+     *
+     * @param  resource $db  Database handler
+     * @param  array    $bindings Array of PDO binding values from bind() to be
+     *   used for safely escaping strings. Note that this can be given as the
+     *   SQL query string if no bindings are required.
+     * @param  string   $sql SQL query to execute.
+     * @return array         Result from the query (all rows)
+     */
+    static function sql_exec ( $db, $bindings, $sql=null )
+    {
+        // Argument shifting
+        if ( $sql === null ) {
+            $sql = $bindings;
+        }
+
+        $stmt = $db->prepare( $sql );
+        //echo $sql;
+
+        // Bind parameters
+        if ( is_array( $bindings ) ) {
+            for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) {
+                $binding = $bindings[$i];
+                $stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] );
+            }
+        }
+
+        // Execute
+        try {
+            $stmt->execute();
+        }
+        catch (PDOException $e) {
+            self::fatal( "An SQL error occurred: ".$e->getMessage() );
+        }
+
+        // Return all
+        return $stmt->fetchAll();
+    }
+
+
+    /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 	 * Internal methods
 	 */
 
-	/**
-	 * Throw a fatal error.
-	 *
-	 * This writes out an error message in a JSON string which DataTables will
-	 * see and show to the user in the browser.
-	 *
-	 * @param  string $msg Message to send to the client
-	 */
-	static function fatal ( $msg )
-	{
-		echo json_encode( array( 
-			"error" => $msg
-		) );
-
-		exit(0);
-	}
-
-	/**
-	 * Create a PDO binding key which can be used for escaping variables safely
-	 * when executing a query with sql_exec()
-	 *
-	 * @param  array &$a    Array of bindings
-	 * @param  *      $val  Value to bind
-	 * @param  int    $type PDO field type
-	 * @return string       Bound key to be used in the SQL where this parameter
-	 *   would be used.
-	 */
-	static function bind ( &$a, $val, $type )
-	{
-		$key = ':binding_'.count( $a );
-
-		$a[] = array(
-			'key' => $key,
-			'val' => $val,
-			'type' => $type
-		);
-
-		return $key;
-	}
-
-
-	/**
-	 * Pull a particular property from each assoc. array in a numeric array, 
-	 * returning and array of the property values from each item.
-	 *
-	 *  @param  array  $a    Array to get data from
-	 *  @param  string $prop Property to read
-	 *  @return array        Array of property values
-	 */
-	static function pluck ( $a, $prop )
-	{
-		$out = array();
-
-		for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) {
-			$out[] = $a[$i][$prop];
-		}
-
-		return $out;
-	}
-
-
-	/**
-	 * Return a string from an array or a string
-	 *
-	 * @param  array|string $a Array to join
-	 * @param  string $join Glue for the concatenation
-	 * @return string Joined string
-	 */
-	static function _flatten ( $a, $join = ' AND ' )
-	{
-		if ( ! $a ) {
-			return '';
-		}
-		else if ( $a && is_array($a) ) {
-			return implode( $join, $a );
-		}
-		return $a;
-	}
+    /**
+     * Throw a fatal error.
+     *
+     * This writes out an error message in a JSON string which DataTables will
+     * see and show to the user in the browser.
+     *
+     * @param  string $msg Message to send to the client
+     */
+    static function fatal ( $msg )
+    {
+        echo json_encode( array( 
+            "error" => $msg
+        ) );
+
+        exit(0);
+    }
+
+    /**
+     * Create a PDO binding key which can be used for escaping variables safely
+     * when executing a query with sql_exec()
+     *
+     * @param  array &$a    Array of bindings
+     * @param  *      $val  Value to bind
+     * @param  int    $type PDO field type
+     * @return string       Bound key to be used in the SQL where this parameter
+     *   would be used.
+     */
+    static function bind ( &$a, $val, $type )
+    {
+        $key = ':binding_'.count( $a );
+
+        $a[] = array(
+            'key' => $key,
+            'val' => $val,
+            'type' => $type
+        );
+
+        return $key;
+    }
+
+
+    /**
+     * Pull a particular property from each assoc. array in a numeric array, 
+     * returning and array of the property values from each item.
+     *
+     *  @param  array  $a    Array to get data from
+     *  @param  string $prop Property to read
+     *  @return array        Array of property values
+     */
+    static function pluck ( $a, $prop )
+    {
+        $out = array();
+
+        for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) {
+            $out[] = $a[$i][$prop];
+        }
+
+        return $out;
+    }
+
+
+    /**
+     * Return a string from an array or a string
+     *
+     * @param  array|string $a Array to join
+     * @param  string $join Glue for the concatenation
+     * @return string Joined string
+     */
+    static function _flatten ( $a, $join = ' AND ' )
+    {
+        if ( ! $a ) {
+            return '';
+        }
+        else if ( $a && is_array($a) ) {
+            return implode( $join, $a );
+        }
+        return $a;
+    }
 }
 

Spacing +103 added lines, -107 removed lines

@@ -17,9 +17,9 @@ 
 
 
 // REMOVE THIS BLOCK - used for DataTables test environment only!
-$file = $_SERVER['DOCUMENT_ROOT'].'/datatables/mysql.php';
-if ( is_file( $file ) ) {
-	include( $file );
+$file = $_SERVER['DOCUMENT_ROOT'] . '/datatables/mysql.php';
+if (is_file($file)) {
+	include($file);
 }
 
 
@@ -31,22 +31,22 @@ 
 	 *  @param  array $data    Data from the SQL get
 	 *  @return array          Formatted data in a row based format
 	 */
-	static function data_output ( $columns, $data )
+	static function data_output($columns, $data)
 	{
 		$out = array();
 
-		for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {
+		for ($i = 0, $ien = count($data); $i < $ien; $i++) {
 			$row = array();
 
-			for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) {
+			for ($j = 0, $jen = count($columns); $j < $jen; $j++) {
 				$column = $columns[$j];
 
 				// Is there a formatter?
-				if ( isset( $column['formatter'] ) ) {
-					$row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );
+				if (isset($column['formatter'])) {
+					$row[$column['dt']] = $column['formatter']($data[$i][$column['db']], $data[$i]);
 				}
 				else {
-					$row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];
+					$row[$column['dt']] = $data[$i][$columns[$j]['db']];
 				}
 			}
 
@@ -70,10 +70,10 @@ 
 	 *     * pass - user password
 	 *  @return resource PDO connection
 	 */
-	static function db ( $conn )
+	static function db($conn)
 	{
-		if ( is_array( $conn ) ) {
-			return self::sql_connect( $conn );
+		if (is_array($conn)) {
+			return self::sql_connect($conn);
 		}
 
 		return $conn;
@@ -89,12 +89,12 @@ 
 	 *  @param  array $columns Column information array
 	 *  @return string SQL limit clause
 	 */
-	static function limit ( $request, $columns )
+	static function limit($request, $columns)
 	{
 		$limit = '';
 
-		if ( isset($request['start']) && $request['length'] != -1 ) {
-			$limit = "LIMIT ".intval($request['start']).", ".intval($request['length']);
+		if (isset($request['start']) && $request['length'] != -1) {
+			$limit = "LIMIT " . intval($request['start']) . ", " . intval($request['length']);
 		}
 
 		return $limit;
@@ -110,32 +110,31 @@ 
 	 *  @param  array $columns Column information array
 	 *  @return string SQL order by clause
 	 */
-	static function order ( $request, $columns )
+	static function order($request, $columns)
 	{
 		$order = '';
 
-		if ( isset($request['order']) && count($request['order']) ) {
+		if (isset($request['order']) && count($request['order'])) {
 			$orderBy = array();
-			$dtColumns = self::pluck( $columns, 'dt' );
+			$dtColumns = self::pluck($columns, 'dt');
 
-			for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) {
+			for ($i = 0, $ien = count($request['order']); $i < $ien; $i++) {
 				// Convert the column index into the column data property
 				$columnIdx = intval($request['order'][$i]['column']);
 				$requestColumn = $request['columns'][$columnIdx];
 
-				$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-				$column = $columns[ $columnIdx ];
+				$columnIdx = array_search($requestColumn['data'], $dtColumns);
+				$column = $columns[$columnIdx];
 
-				if ( $requestColumn['orderable'] == 'true' ) {
+				if ($requestColumn['orderable'] == 'true') {
 					$dir = $request['order'][$i]['dir'] === 'asc' ?
-						'ASC' :
-						'DESC';
+						'ASC' : 'DESC';
 
-					$orderBy[] = '`'.$column['db'].'` '.$dir;
+					$orderBy[] = '`' . $column['db'] . '` ' . $dir;
 				}
 			}
 
-			$order = 'ORDER BY '.implode(', ', $orderBy);
+			$order = 'ORDER BY ' . implode(', ', $orderBy);
 		}
 
 		return $order;
@@ -157,57 +156,56 @@ 
 	 *    sql_exec() function
 	 *  @return string SQL where clause
 	 */
-	static function filter ( $request, $columns, &$bindings )
+	static function filter($request, $columns, &$bindings)
 	{
 		$globalSearch = array();
 		$columnSearch = array();
-		$dtColumns = self::pluck( $columns, 'dt' );
+		$dtColumns = self::pluck($columns, 'dt');
 
-		if ( isset($request['search']) && $request['search']['value'] != '' ) {
+		if (isset($request['search']) && $request['search']['value'] != '') {
 			$str = $request['search']['value'];
 
-			for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
+			for ($i = 0, $ien = count($request['columns']); $i < $ien; $i++) {
 				$requestColumn = $request['columns'][$i];
-				$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-				$column = $columns[ $columnIdx ];
+				$columnIdx = array_search($requestColumn['data'], $dtColumns);
+				$column = $columns[$columnIdx];
 
-				if ( $requestColumn['searchable'] == 'true' ) {
-					$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
-					$globalSearch[] = "`".$column['db']."` LIKE ".$binding;
+				if ($requestColumn['searchable'] == 'true') {
+					$binding = self::bind($bindings, '%' . $str . '%', PDO::PARAM_STR);
+					$globalSearch[] = "`" . $column['db'] . "` LIKE " . $binding;
 				}
 			}
 		}
 
 		// Individual column filtering
-		for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {
+		for ($i = 0, $ien = count($request['columns']); $i < $ien; $i++) {
 			$requestColumn = $request['columns'][$i];
-			$columnIdx = array_search( $requestColumn['data'], $dtColumns );
-			$column = $columns[ $columnIdx ];
+			$columnIdx = array_search($requestColumn['data'], $dtColumns);
+			$column = $columns[$columnIdx];
 
 			$str = $requestColumn['search']['value'];
 
-			if ( $requestColumn['searchable'] == 'true' &&
-			 $str != '' ) {
-				$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
-				$columnSearch[] = "`".$column['db']."` LIKE ".$binding;
+			if ($requestColumn['searchable'] == 'true' &&
+			 $str != '') {
+				$binding = self::bind($bindings, '%' . $str . '%', PDO::PARAM_STR);
+				$columnSearch[] = "`" . $column['db'] . "` LIKE " . $binding;
 			}
 		}
 
 		// Combine the filters into a single string
 		$where = '';
 
-		if ( count( $globalSearch ) ) {
-			$where = '('.implode(' OR ', $globalSearch).')';
+		if (count($globalSearch)) {
+			$where = '(' . implode(' OR ', $globalSearch) . ')';
 		}
 
-		if ( count( $columnSearch ) ) {
+		if (count($columnSearch)) {
 			$where = $where === '' ?
-				implode(' AND ', $columnSearch) :
-				$where .' AND '. implode(' AND ', $columnSearch);
+				implode(' AND ', $columnSearch) : $where . ' AND ' . implode(' AND ', $columnSearch);
 		}
 
-		if ( $where !== '' ) {
-			$where = 'WHERE '.$where;
+		if ($where !== '') {
+			$where = 'WHERE ' . $where;
 		}
 
 		return $where;
@@ -228,19 +226,19 @@ 
 	 *  @param  array $columns Column information array
 	 *  @return array          Server-side processing response array
 	 */
-	static function simple ( $request, $conn, $table, $primaryKey, $columns )
+	static function simple($request, $conn, $table, $primaryKey, $columns)
 	{
 		$bindings = array();
-		$db = self::db( $conn );
+		$db = self::db($conn);
 
 		// Build the SQL query string from the request
-		$limit = self::limit( $request, $columns );
-		$order = self::order( $request, $columns );
-		$where = self::filter( $request, $columns, $bindings );
+		$limit = self::limit($request, $columns);
+		$order = self::order($request, $columns);
+		$where = self::filter($request, $columns, $bindings);
 
 		// Main query to actually get the data
-		$data = self::sql_exec( $db, $bindings,
-			"SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
+		$data = self::sql_exec($db, $bindings,
+			"SELECT SQL_CALC_FOUND_ROWS `" . implode("`, `", self::pluck($columns, 'db')) . "`
 			 FROM `$table`
 			 $where
 			 $order
@@ -248,13 +246,13 @@ 
 		);
 
 		// Data set length after filtering
-		$resFilterLength = self::sql_exec( $db,
+		$resFilterLength = self::sql_exec($db,
 			"SELECT FOUND_ROWS()"
 		);
 		$recordsFiltered = $resFilterLength[0][0];
 
 		// Total data set length
-		$resTotalLength = self::sql_exec( $db,
+		$resTotalLength = self::sql_exec($db,
 			"SELECT COUNT(`{$primaryKey}`)
 			 FROM   `$table`"
 		);
@@ -265,10 +263,10 @@ 
 		 * Output
 		 */
 		return array(
-			"draw"            => intval( $request['draw'] ),
-			"recordsTotal"    => intval( $recordsTotal ),
-			"recordsFiltered" => intval( $recordsFiltered ),
-			"data"            => self::data_output( $columns, $data )
+			"draw"            => intval($request['draw']),
+			"recordsTotal"    => intval($recordsTotal),
+			"recordsFiltered" => intval($recordsFiltered),
+			"data"            => self::data_output($columns, $data)
 		);
 	}
 
@@ -296,39 +294,37 @@ 
 	 *  @param  string $whereAll WHERE condition to apply to all queries
 	 *  @return array          Server-side processing response array
 	 */
-	static function complex ( $request, $conn, $table, $primaryKey, $columns, $whereResult=null, $whereAll=null )
+	static function complex($request, $conn, $table, $primaryKey, $columns, $whereResult = null, $whereAll = null)
 	{
 		$bindings = array();
-		$db = self::db( $conn );
+		$db = self::db($conn);
 		$localWhereResult = array();
 		$localWhereAll = array();
 		$whereAllSql = '';
 
 		// Build the SQL query string from the request
-		$limit = self::limit( $request, $columns );
-		$order = self::order( $request, $columns );
-		$where = self::filter( $request, $columns, $bindings );
+		$limit = self::limit($request, $columns);
+		$order = self::order($request, $columns);
+		$where = self::filter($request, $columns, $bindings);
 
-		$whereResult = self::_flatten( $whereResult );
-		$whereAll = self::_flatten( $whereAll );
+		$whereResult = self::_flatten($whereResult);
+		$whereAll = self::_flatten($whereAll);
 
-		if ( $whereResult ) {
+		if ($whereResult) {
 			$where = $where ?
-				$where .' AND '.$whereResult :
-				'WHERE '.$whereResult;
+				$where . ' AND ' . $whereResult : 'WHERE ' . $whereResult;
 		}
 
-		if ( $whereAll ) {
+		if ($whereAll) {
 			$where = $where ?
-				$where .' AND '.$whereAll :
-				'WHERE '.$whereAll;
+				$where . ' AND ' . $whereAll : 'WHERE ' . $whereAll;
 
-			$whereAllSql = 'WHERE '.$whereAll;
+			$whereAllSql = 'WHERE ' . $whereAll;
 		}
 
 		// Main query to actually get the data
-		$data = self::sql_exec( $db, $bindings,
-			"SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
+		$data = self::sql_exec($db, $bindings,
+			"SELECT SQL_CALC_FOUND_ROWS `" . implode("`, `", self::pluck($columns, 'db')) . "`
 			 FROM `$table`
 			 $where
 			 $order
@@ -336,15 +332,15 @@ 
 		);
 
 		// Data set length after filtering
-		$resFilterLength = self::sql_exec( $db,
+		$resFilterLength = self::sql_exec($db,
 			"SELECT FOUND_ROWS()"
 		);
 		$recordsFiltered = $resFilterLength[0][0];
 
 		// Total data set length
-		$resTotalLength = self::sql_exec( $db, $bindings,
+		$resTotalLength = self::sql_exec($db, $bindings,
 			"SELECT COUNT(`{$primaryKey}`)
-			 FROM   `$table` ".
+			 FROM   `$table` " .
 			$whereAllSql
 		);
 		$recordsTotal = $resTotalLength[0][0];
@@ -353,10 +349,10 @@ 
 		 * Output
 		 */
 		return array(
-			"draw"            => intval( $request['draw'] ),
-			"recordsTotal"    => intval( $recordsTotal ),
-			"recordsFiltered" => intval( $recordsFiltered ),
-			"data"            => self::data_output( $columns, $data )
+			"draw"            => intval($request['draw']),
+			"recordsTotal"    => intval($recordsTotal),
+			"recordsFiltered" => intval($recordsFiltered),
+			"data"            => self::data_output($columns, $data)
 		);
 	}
 
@@ -372,20 +368,20 @@ 
 	 *     * pass - user password
 	 * @return resource Database connection handle
 	 */
-	static function sql_connect ( $sql_details )
+	static function sql_connect($sql_details)
 	{
 		try {
 			$db = @new PDO(
 				"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
 				$sql_details['user'],
 				$sql_details['pass'],
-				array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
+				array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
 			);
 		}
 		catch (PDOException $e) {
 			self::fatal(
-				"An error occurred while connecting to the database. ".
-				"The error reported by the server was: ".$e->getMessage()
+				"An error occurred while connecting to the database. " .
+				"The error reported by the server was: " . $e->getMessage()
 			);
 		}
 
@@ -403,21 +399,21 @@ 
 	 * @param  string   $sql SQL query to execute.
 	 * @return array         Result from the query (all rows)
 	 */
-	static function sql_exec ( $db, $bindings, $sql=null )
+	static function sql_exec($db, $bindings, $sql = null)
 	{
 		// Argument shifting
-		if ( $sql === null ) {
+		if ($sql === null) {
 			$sql = $bindings;
 		}
 
-		$stmt = $db->prepare( $sql );
+		$stmt = $db->prepare($sql);
 		//echo $sql;
 
 		// Bind parameters
-		if ( is_array( $bindings ) ) {
-			for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) {
+		if (is_array($bindings)) {
+			for ($i = 0, $ien = count($bindings); $i < $ien; $i++) {
 				$binding = $bindings[$i];
-				$stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] );
+				$stmt->bindValue($binding['key'], $binding['val'], $binding['type']);
 			}
 		}
 
@@ -426,7 +422,7 @@ 
 			$stmt->execute();
 		}
 		catch (PDOException $e) {
-			self::fatal( "An SQL error occurred: ".$e->getMessage() );
+			self::fatal("An SQL error occurred: " . $e->getMessage());
 		}
 
 		// Return all
@@ -446,11 +442,11 @@ 
 	 *
 	 * @param  string $msg Message to send to the client
 	 */
-	static function fatal ( $msg )
+	static function fatal($msg)
 	{
-		echo json_encode( array( 
+		echo json_encode(array( 
 			"error" => $msg
-		) );
+		));
 
 		exit(0);
 	}
@@ -465,9 +461,9 @@ 
 	 * @return string       Bound key to be used in the SQL where this parameter
 	 *   would be used.
 	 */
-	static function bind ( &$a, $val, $type )
+	static function bind(&$a, $val, $type)
 	{
-		$key = ':binding_'.count( $a );
+		$key = ':binding_' . count($a);
 
 		$a[] = array(
 			'key' => $key,
@@ -487,11 +483,11 @@ 
 	 *  @param  string $prop Property to read
 	 *  @return array        Array of property values
 	 */
-	static function pluck ( $a, $prop )
+	static function pluck($a, $prop)
 	{
 		$out = array();
 
-		for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) {
+		for ($i = 0, $len = count($a); $i < $len; $i++) {
 			$out[] = $a[$i][$prop];
 		}
 
@@ -506,13 +502,13 @@ 
 	 * @param  string $join Glue for the concatenation
 	 * @return string Joined string
 	 */
-	static function _flatten ( $a, $join = ' AND ' )
+	static function _flatten($a, $join = ' AND ')
 	{
-		if ( ! $a ) {
+		if (!$a) {
 			return '';
 		}
-		else if ( $a && is_array($a) ) {
-			return implode( $join, $a );
+		else if ($a && is_array($a)) {
+			return implode($join, $a);
 		}
 		return $a;
 	}

Braces +4 added lines, -8 removed lines

@@ -44,8 +44,7 @@ 
 				// Is there a formatter?
 				if ( isset( $column['formatter'] ) ) {
 					$row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );
-				}
-				else {
+				} else {
 					$row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];
 				}
 			}
@@ -381,8 +380,7 @@ 
 				$sql_details['pass'],
 				array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
 			);
-		}
-		catch (PDOException $e) {
+		} catch (PDOException $e) {
 			self::fatal(
 				"An error occurred while connecting to the database. ".
 				"The error reported by the server was: ".$e->getMessage()
@@ -424,8 +422,7 @@ 
 		// Execute
 		try {
 			$stmt->execute();
-		}
-		catch (PDOException $e) {
+		} catch (PDOException $e) {
 			self::fatal( "An SQL error occurred: ".$e->getMessage() );
 		}
 
@@ -510,8 +507,7 @@ 
 	{
 		if ( ! $a ) {
 			return '';
-		}
-		else if ( $a && is_array($a) ) {
+		} else if ( $a && is_array($a) ) {
 			return implode( $join, $a );
 		}
 		return $a;

resources/rawassets/components/data-table/examples/server_side/scripts/objects.php

Indentation +23 added lines, -23 removed lines

@@ -15,32 +15,32 @@ 
 // 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);
-		}
-	)
+    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' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -52,6 +52,6 @@ 
 require( 'ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
 );
 

Spacing +10 added lines, -10 removed lines

@@ -15,22 +15,22 @@ 
 // 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' => '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));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 'salary',
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -49,9 +49,9 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( 'ssp.class.php' );
+require('ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
 );
 

resources/rawassets/components/data-table/examples/server_side/scripts/ids-objects.php

Indentation +33 added lines, -33 removed lines

@@ -29,41 +29,41 @@ 
 // parameter represents the DataTables column identifier - in this case object
 // parameter names
 $columns = array(
-	array(
-		'db' => 'id',
-		'dt' => 'DT_RowId',
-		'formatter' => function( $d, $row ) {
-			// Technically a DOM id cannot start with an integer, so we prefix
-			// a string. This can also be useful if you have multiple tables
-			// to ensure that the id is unique with a different prefix
-			return 'row_'.$d;
-		}
-	),
-	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);
-		}
-	)
+    array(
+        'db' => 'id',
+        'dt' => 'DT_RowId',
+        'formatter' => function( $d, $row ) {
+            // Technically a DOM id cannot start with an integer, so we prefix
+            // a string. This can also be useful if you have multiple tables
+            // to ensure that the id is unique with a different prefix
+            return 'row_'.$d;
+        }
+    ),
+    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_details = array(
-	'user' => '',
-	'pass' => '',
-	'db'   => '',
-	'host' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -75,6 +75,6 @@ 
 require( 'ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
 );
 

Spacing +12 added lines, -12 removed lines

@@ -32,29 +32,29 @@ 
 	array(
 		'db' => 'id',
 		'dt' => 'DT_RowId',
-		'formatter' => function( $d, $row ) {
+		'formatter' => function($d, $row) {
 			// Technically a DOM id cannot start with an integer, so we prefix
 			// a string. This can also be useful if you have multiple tables
 			// to ensure that the id is unique with a different prefix
-			return 'row_'.$d;
+			return 'row_' . $d;
 		}
 	),
-	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' => '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));
+		'formatter' => function($d, $row) {
+			return date('jS M y', strtotime($d));
 		}
 	),
 	array(
 		'db'        => 'salary',
 		'dt'        => 'salary',
-		'formatter' => function( $d, $row ) {
-			return '$'.number_format($d);
+		'formatter' => function($d, $row) {
+			return '$' . number_format($d);
 		}
 	)
 );
@@ -72,9 +72,9 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( 'ssp.class.php' );
+require('ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
 );
 

resources/rawassets/components/data-table/examples/resources/examples.php

Indentation +2 added lines, -2 removed lines

@@ -1,10 +1,10 @@
 <?php
 
 if ( isset( $_POST['src'] ) && preg_match( '/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src'] ) !== 0 ) {
-	echo htmlspecialchars( file_get_contents( '../server_side/'.$_POST['src'] ) );
+    echo htmlspecialchars( file_get_contents( '../server_side/'.$_POST['src'] ) );
 }
 else {
-	echo '';
+    echo '';
 }
 
 

Spacing +2 added lines, -2 removed lines

@@ -1,7 +1,7 @@
 <?php
 
-if ( isset( $_POST['src'] ) && preg_match( '/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src'] ) !== 0 ) {
-	echo htmlspecialchars( file_get_contents( '../server_side/'.$_POST['src'] ) );
+if (isset($_POST['src']) && preg_match('/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src']) !== 0) {
+	echo htmlspecialchars(file_get_contents('../server_side/' . $_POST['src']));
 }
 else {
 	echo '';

Braces +1 added lines, -2 removed lines

@@ -2,8 +2,7 @@
 
 if ( isset( $_POST['src'] ) && preg_match( '/scripts\/[a-zA-Z_\-_]+\.php/', $_POST['src'] ) !== 0 ) {
 	echo htmlspecialchars( file_get_contents( '../server_side/'.$_POST['src'] ) );
-}
-else {
+} else {
 	echo '';
 }
 

resources/rawassets/components/data-table/extensions/Scroller/examples/data/ssp.php

Indentation +10 added lines, -10 removed lines

@@ -29,19 +29,19 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'id',         'dt' => 0 ),
-	array( 'db' => 'firstname',  'dt' => 1 ),
-	array( 'db' => 'surname',    'dt' => 2 ),
-	array( 'db' => 'zip',        'dt' => 3 ),
-	array( 'db' => 'country',    'dt' => 4 )
+    array( 'db' => 'id',         'dt' => 0 ),
+    array( 'db' => 'firstname',  'dt' => 1 ),
+    array( 'db' => 'surname',    'dt' => 2 ),
+    array( 'db' => 'zip',        'dt' => 3 ),
+    array( 'db' => 'country',    'dt' => 4 )
 );
 
 // SQL server connection information
 $sql_details = array(
-	'user' => '',
-	'pass' => '',
-	'db'   => '',
-	'host' => ''
+    'user' => '',
+    'pass' => '',
+    'db'   => '',
+    'host' => ''
 );
 
 
@@ -53,6 +53,6 @@ 
 require( '../../../../examples/server_side/scripts/ssp.class.php' );
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
 );
 

Spacing +7 added lines, -7 removed lines

@@ -29,11 +29,11 @@ 
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = array(
-	array( 'db' => 'id',         'dt' => 0 ),
-	array( 'db' => 'firstname',  'dt' => 1 ),
-	array( 'db' => 'surname',    'dt' => 2 ),
-	array( 'db' => 'zip',        'dt' => 3 ),
-	array( 'db' => 'country',    'dt' => 4 )
+	array('db' => 'id', 'dt' => 0),
+	array('db' => 'firstname', 'dt' => 1),
+	array('db' => 'surname', 'dt' => 2),
+	array('db' => 'zip', 'dt' => 3),
+	array('db' => 'country', 'dt' => 4)
 );
 
 // SQL server connection information
@@ -50,9 +50,9 @@ 
  * server-side, there is no need to edit below this line.
  */
 
-require( '../../../../examples/server_side/scripts/ssp.class.php' );
+require('../../../../examples/server_side/scripts/ssp.class.php');
 
 echo json_encode(
-	SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
+	SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns)
 );