Multiple word search

[andrejflorjancic]

Try this version of function filterglobal

$searchinput = $this->input('search')['value'];
$allcolumns = $this->input('columns');

if ($searchinput == '')
{
return null;
}

$search = [];
$searchinput = preg_replace("/\W+/", " ", $searchinput);
foreach (explode(' ',$searchinput) as $word) {
$lookfor = [];
foreach ($this->columns as $key => $column) {
if ($allcolumns[$key]['searchable'] == 'true') {
$lookfor[] = $column . " LIKE " . $this->db->escape($word) . "";
}
}
$search[] = "(".implode(" OR ", $lookfor) . ")";
}

return implode(" AND ", $search);

Searches for all the words in a row.