DB ::更新laravel 5原始查询 [英] DB::update laravel 5 raw query

问题描述

我打算使用等效于sql的laravel db update.

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']);

推荐答案

您应该像这样更新查询:

You should update your query like :

口才查询:

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

流利查询:

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

希望这对您有帮助

这篇关于DB ::更新laravel 5原始查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！