PMA\libraries\controllers\table\TableSearchController::_getEnumWhereClause PHP Method

_getEnumWhereClause() private method

Return the where clause in case column's type is ENUM.
private _getEnumWhereClause ( mixed $criteriaValues, string $func_type ) : string
$criteriaValues mixed Search criteria input
$func_type string Search function/operator
return string part of where clause.
    private function _getEnumWhereClause($criteriaValues, $func_type)
    {
        if (!is_array($criteriaValues)) {
            $criteriaValues = explode(',', $criteriaValues);
        }
        $enum_selected_count = count($criteriaValues);
        if ($func_type == '=' && $enum_selected_count > 1) {
            $func_type = 'IN';
            $parens_open = '(';
            $parens_close = ')';
        } elseif ($func_type == '!=' && $enum_selected_count > 1) {
            $func_type = 'NOT IN';
            $parens_open = '(';
            $parens_close = ')';
        } else {
            $parens_open = '';
            $parens_close = '';
        }
        $enum_where = '\'' . $GLOBALS['dbi']->escapeString($criteriaValues[0]) . '\'';
        for ($e = 1; $e < $enum_selected_count; $e++) {
            $enum_where .= ', \'' . $GLOBALS['dbi']->escapeString($criteriaValues[$e]) . '\'';
        }
        return ' ' . $func_type . ' ' . $parens_open . $enum_where . $parens_close;
    }