Laravel Fluent Query Builder Update Query

Question

I want to add two columns while using update, like this:

 Update purchase_stock inner join stock on purchase_stock.fkstockid=stock.stockid SET currentavailable=currentavailable+subquantity where fkorderid='1';

Here is the current Fluent code:

 DB::table('purchase_stock')->join('stock','stock.stockid','=','purchase_stock.fkstockid')->where('fkorderid',$orderId)->update(array('currentavailable'=>'currentavailable'+'subquantity'));**

But it throws error as below:

"error":{"type":"Symfony\\Component\\Debug\\Exception\\FatalErrorException","message":"syntax error, unexpected '=>'"

Does any one have solution?

mopo922 · Accepted Answer · 2017-12-05 21:42:42Z

1

You were very close with your fluent attempt, but there were two issues:

The plus sign needs to be inside the quotes, since you want the math done in SQL, not in PHP.
Need a DB::raw() around the value so Laravel doesn't think you're actually trying to set it to the string "currentavailable + subquantity"

So the final product looks like this:

DB::table('purchase_stock')
    ->join('stock', 'stock.stockid', '=', 'purchase_stock.fkstockid')
    ->where('fkorderid', $orderId)
    ->update(['currentavailable' => DB::raw('currentavailable + subquantity')]);

answered Dec 5, 2017 at 21:42

mopo922

6,3813 gold badges30 silver badges31 bronze badges

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

Comments

Fortran · Accepted Answer · 2014-02-11 14:44:42Z

0

Мaybe you need to set these two fields from which tables. Exampl. DB::table('purchase_stock')->join('stock','stock.stockid','=','purchase_stock.fkstockid')->where('fkorderid',$orderId)->update(array('stock.currentavailable'=>'stock.currentavailable'+'stock.subquantity'));

answered Feb 11, 2014 at 14:44

Fortran

5935 silver badges16 bronze badges

Comments

Pratik Shah · Accepted Answer · 2014-02-12 06:03:47Z

0

Ohk!
I already tried this one but it is not working
As of now I am using DB::statement('') and it's working
So I have written whole update query within statement and it's working as somewhere I have read that it will not be helpful to return result set but will work with insert or update.

answered Feb 12, 2014 at 6:03

Pratik Shah

1491 silver badge11 bronze badges

1 Comment

Alex Over a year ago

It's not a best practice

Collectives™ on Stack Overflow

Laravel Fluent Query Builder Update Query

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related