type = constant("Constraint::$type"); } public function setValues(...$values) { $this->values = array_map("db::escape", $values); return $this; } public function getConstraintString() { $value_1 = $this->values[0] ?? 0; $value_2 = $this->values[1] ?? 0; switch($this->type) { case self::TYPE_LESS_THAN: return " < '$value_1'"; case self::TYPE_LESS_THAN_OR_EQUAL: return " <= '$value_1'"; case self::TYPE_EQUALS: return " = '$value_1'"; case self::TYPE_MORE_THAN_OR_EQUAL: return " >= '$value_1'"; case self::TYPE_MORE_THAN: return " > '$value_1'"; case self::TYPE_BETWEEN: return " BETWEEN '$value_1' AND '$value_2'"; case self::TYPE_BEGINS_WITH: return " LIKE '$value_1%'"; case self::TYPE_CONTAINS: return " LIKE '%$value_1%'"; case self::TYPE_ENDS_WITH: return " LIKE '%$value_1'"; case self::TYPE_NOT_EQUALS: return " != '$value_1'"; case self::TYPE_IS_NULL: return " IS NULL"; case self::TYPE_IS_NOT_NULL: return " IS NOT NULL"; } return false; } } ?>