-
Notifications
You must be signed in to change notification settings - Fork 333
Open
Description
Hi, I've a projet where i must use smart search on datatable (many word on many column).
If anybody have the same problem, i've change the code to this (line 327)
if($sSearch != '')
{
$sSearch_explode = explode(" ",$sSearch);
foreach ($sSearch_explode as $sSearch)
{
$sWhere .= '(';
for($i = 0; $i < count($mColArray); $i++)
{
if ($mColArray[$i]['searchable'] == 'true' && !array_key_exists($mColArray[$i]['data'], $this->add_columns))
{
if($this->check_cType())
{
$sWhere .= $this->select[$mColArray[$i]['data']] . " LIKE '%" . $sSearch . "%' OR ";
}
else
{
$sWhere .= $this->select[$this->columns[$i]] . " LIKE '%" . $sSearch . "%' OR ";
}
}
}
$sWhere = substr_replace($sWhere, '', -3);
$sWhere .= ') AND ';
}
}
$sWhere = substr_replace($sWhere, '', -4);
Metadata
Metadata
Assignees
Labels
No labels