Illuminate\Database\Query\Builder::whereBetween PHP Method

whereBetween() public method

Add a where between statement to the query.
public whereBetween ( string $column, array $values, string $boolean = 'and', boolean $not = false )
$column string
$values array
$boolean string
$not boolean
    public function whereBetween($column, array $values, $boolean = 'and', $not = false)
    {
        $type = 'between';
        $this->wheres[] = compact('column', 'type', 'boolean', 'not');
        $this->addBinding($values, 'where');
        return $this;
    }

Usage Example

Example #1
1
 /**
  * between, 两端开区间
  * @param $attribute
  * @param null $min
  * @param null $max
  * @return static
  */
 public function whereBetween($attribute, $min, $max)
 {
     if ($min > $max) {
         return $this->whereEquals(0, 1);
     }
     $this->original->whereBetween($attribute, [$min, $max]);
     return $this;
 }
All Usage Examples Of Illuminate\Database\Query\Builder::whereBetween