db::search_clause PHP Method

search_clause() static public method

A simplifier to build search clauses
static public search_clause ( string $search, array $fields, string $mode = 'OR' ) : string
$search string The search word
$fields array An array of fields to search
$mode string OR or AND
return string Returns the final where clause
    static function search_clause($search, $fields, $mode = 'OR')
    {
        if (empty($search)) {
            return false;
        }
        $arr = array();
        foreach ($fields as $f) {
            array_push($arr, $f . ' LIKE \'%' . $search . '%\'');
            //array_push($arr, $f . ' REGEXP "[[:<:]]' . db::escape($search) . '[[:>:]]"');
        }
        return '(' . implode(' ' . trim($mode) . ' ', $arr) . ')';
    }