SQL Query syntax in Laravel Controller

Question

The following code is trying to update a column itself by multiplying by an input variable:

$multiplier = $request->input("disc");

DB::statement('SET entries UPDATE dp = dp * :multiplier', array('multiplier' => $multiplier));

When I run this I get an error regarding my syntax.

Not an sql expert, but have you tried without SET entries? What is this supposed to do? — user8034901
– user8034901, Commented Jun 1, 2020 at 14:51
"I get an error" - which is? Please always include full quotes of errors in your questions. — underscore_d
– underscore_d, Commented Jun 1, 2020 at 14:55

Ersoy · Accepted Answer · 2020-06-01 14:53:42Z

1

The query syntax is wrong, please check for the correct (assuming it is mysql) one

$multiplier = $request->input("disc");

DB::statement('UPDATE entries SET dp = dp * :multiplier', ['multiplier' => $multiplier]);

answered Jun 1, 2020 at 14:53

Ersoy

9,8046 gold badges40 silver badges54 bronze badges

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

1 Answer 1