DB::update laravel 5 raw query

Question

I intend to use laravel db update which equivalent to sql.

update users set username = "admin", status = "active" where user_id = 1

This is the query I test to run. Any wrong?

$username = "admin";
$status = "active";

DB::update('update users set username = '  .$username. ',
status = '.$status.'  where user_id = ?' ,['1']);

Answer 1

You should update your query like :

Eloquent Query:

User::where('user_id',1)->update(array(
                         'username'=>$username,
));

Fluent Query:

DB::table('users')->where('user_id',1)->update(array(
                                 'username'=>$username,
));

Hope this helps you

Answer 2

The correct query would be

DB::update('update users set username = ? , status = ? where user_id = ?', ["admin" , "active" , 1]);

OR

User::where('user_id', 1)->update( array('username'=>'admin', 'status'=>'active') );

Where "User" is the model name of "users" table.