Laravel 5.2 wherebetween之间不起作用 [英] Laravel 5.2 whereBetween not working
本文介绍了Laravel 5.2 wherebetween之间不起作用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用laravel 5.2框架,但是在此WhereBetween中不起作用.我正在使用价格范围,价格从500到4000开始.当我执行查询时,获取空记录,但是当我删除WhereBetween()
时,则获取所有记录.请建议我如何解决此问题.
I am using laravel 5.2 framework but in this WhereBetween not working. I am using price range where price starts form 500 to 4000. When I execute the query get empty records but when I remove WhereBetween()
then get all records. Please suggest me how to solved this.
$query = Property::query();
$query->select('properties.property_id', 'properties.property_title', 'properties.description', 'properties.latitude', 'properties.longitude', 'properties.city_name', 'properties.state_name');
$query->leftjoin('properties_base_season_price_transactions', 'properties_base_season_price_transactions.parent_id', '=', 'properties.property_id');
$query->leftjoin('properties_availability', 'properties_availability.property_id', '=', 'properties.property_id');
$query->where('properties.property_category_id', $post_data['categoryid']);
$query->where('properties.property_sub_category_id', $post_data['subcategoryid']);
$query->where('properties.city_name', 'LIKE' , '%'.$post_data['city'].'%');
$query->whereBetween('properties_base_season_price_transactions.price', [500, 4444]);
$query_output = $query->get()->toArray();
推荐答案
whereBetween
尝试
->whereRaw("properties_base_season_price_transactions.price BETWEEN 500 AND 4444");
这篇关于Laravel 5.2 wherebetween之间不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文