$value = str_replace('_', '\\_', $value);
$value = explode(' ', $value);
$filters = [];
foreach ($value as $term) {
$filters[] = ['Referee.firstname', 'LIKE ', '%' . $term . '%'];
$filters[] = ['Referee.lastname', 'LIKE ', '%' . $term . '%'];
}
$sel->filter($filters);
break;
}
}
if ($sort) {
if ($sortOrder === '') {
$sel->order($sortColumn, 'DESC');
} else {
$sel->order($sortColumn, $sortOrder);
}
}
$sel->limit(0, 10);
$result = $database->select($sel);
$this->result = $database->resultToReferees($result);
}
public function template()
{
echo json_encode($this->result);
}
}
$database = new Database();
$controller = new Handler();
$controller->GET(null);
$controller->template();
