Adding a number from a database to an existing variable to perform a query

Question

I am not sure if this is possible to do without doing a query first.

I have something like this:

$item_weight

This item goes into a box, which has its own row $box->weight and has a max weight $box->max_weight.

I want a list of boxes that I could put my item into.

I know I can do this by doing a query first and then calculating with a foreach but I wonder if there is a cleaner way to do this.

Something like this:

$boxes= Boxes::where('max_weight','>',$item_weight + $box->weight)
                ->orderBy('max_weight','asc')
                ->get();

Alex Blex · Accepted Answer · 2017-06-30 12:18:39Z

2

You can use whereRaw and shift calculation to db side:

$boxes= Boxes::whereRaw('boxes.max_weight - boxes.weight > ?', [$item_weight])
    ->orderBy('max_weight','asc')
    ->get();

answered Jun 30, 2017 at 12:18

Alex Blex

37.3k7 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1