Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Original Code:
- 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;
- }
- }
- }
- Changed Code:
- 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' )
- $strArray = explode(' ',$str);
- foreach ($strArray as $str)
- {
- $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );
- $globalSearch[] = "`".$column['db']."` LIKE ".$binding;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement