whereBetween()雄辩地返回错误结果 [英] whereBetween() Eloquent returning wrong results

问题描述

我有一个雄辩的查询，并且我正在使用查询范围.我的表中有一个km列，并且我将kmFrom和KmTo值传递为发布数据.现在，当我搜索km时，我正在雄辩地执行whereBetween及其返回错误的结果.

I have a Eloquent query and I am using query scope. I have a km column in my table and I am passing kmFrom and KmTo values as post data. Now I am doing a eloquent whereBetween and its returning wrong results when I search for km.

例如，如果我通过了kmFrom = 1000和kmTo = 2000.它给我的结果不在这两个值之间.

For example if I pass kmFrom = 1000 and kmTo = 2000. Its giving me results which are not in between these two values.

口才:

Product::categoriesCategoryId($categoryId)
            ->km($kmFrom, $kmTo)->get();

公里的查询范围:

 public function scopeKm($query, $kmFrom, $kmTo)
    {   
        if(($kmFrom) && ($kmTo)){
            return $query->whereBetween('km', ["$kmFrom", "$kmTo"]);   
        }
        return $query;
    }

请协助我做错了事.

推荐答案

做同一件事的方法不同

public function scopeKm($query, $kmFrom, $kmTo)
    {   
        if(($kmFrom) && ($kmTo)){
            return $query->where('km','>' ,$kmFrom])->where('km','<',$kmTo);   
        }
        return $query;
    }

这将相同 希望对您有帮助！

this will work same hope this will help you!

这篇关于whereBetween()雄辩地返回错误结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！