An expression object that represents a SQL BETWEEN snippet
Cake\Database\ExpressionInterface|array|stringThe field name or expression to be used in the left hand side of the operator
mixedThe first value in the expression
mixedThe second value in the expression
mixedThe data type for the from and to arguments
Do a deep clone of this expression.
Constructor
Registers a value in the placeholder generator and returns the generated placeholder
Conditionally converts the passed value to an ExpressionInterface object if the type class implements the ExpressionTypeInterface. Otherwise, returns the value unmodified.
Returns an array with the types that require values to be casted to expressions, out of the list of type names passed as parameter.
Returns the field name
Sets the field name
Converts the Node into a SQL string fragment.
Iterates over each part of the expression recursively for every level of the expressions tree and executes the $callback callable passing as first parameter the instance of the expression currently being iterated.
__clone(): void
Do a deep clone of this expression.
void__construct(Cake\Database\ExpressionInterface|string $field, mixed $from, mixed $to, string|null $type = null)
Constructor
Cake\Database\ExpressionInterface|string $field The field name to compare for values inbetween the range.
mixed $from The initial value of the range.
mixed $to The ending value in the comparison range.
string|null $type optional The data type name to bind the values with.
_bindValue(mixed $value, Cake\Database\ValueBinder $binder, string $type): string
Registers a value in the placeholder generator and returns the generated placeholder
mixed $value The value to bind
Cake\Database\ValueBinder $binder The value binder to use
string $type The type of $value
string_castToExpression(mixed $value, string|null $type = null): mixed
Conditionally converts the passed value to an ExpressionInterface object if the type class implements the ExpressionTypeInterface. Otherwise, returns the value unmodified.
mixed $value The value to convert to ExpressionInterface
string|null $type optional The type name
mixed_requiresToExpressionCasting(array $types): array
Returns an array with the types that require values to be casted to expressions, out of the list of type names passed as parameter.
array $types List of type names
arraygetField(): Cake\Database\ExpressionInterface|array|string
Returns the field name
Cake\Database\ExpressionInterface|array|stringsetField(Cake\Database\ExpressionInterface|array|string $field): void
Sets the field name
Cake\Database\ExpressionInterface|array|string $field The field to compare with.
voidsql(Cake\Database\ValueBinder $binder): string
Converts the Node into a SQL string fragment.
Cake\Database\ValueBinder $binder stringtraverse(Closure $callback): $this
Iterates over each part of the expression recursively for every level of the expressions tree and executes the $callback callable passing as first parameter the instance of the expression currently being iterated.
Closure $callback $thisThe field name or expression to be used in the left hand side of the operator
Cake\Database\ExpressionInterface|array|stringThe first value in the expression
mixedThe second value in the expression
mixedThe data type for the from and to arguments
mixed
© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.4/class-Cake.Database.Expression.BetweenExpression.html