PHP code snippet – How to pass variable in mysql laravel database?
$data = DB::select(DB::raw("SELECT pur_price FROM productpricing WHERE mst_uid = (SELECT mst_uid FROM master_material WHERE prd_id = :product_id AND mtl_id = :material AND color_id = :color AND mtl_status ='1') AND ($size between pur_sqft1 AND ifnull(pur_sqft2,$size))"), array('product_id' =>$product_id, 'material' =>$material, 'color' =>$color, ));