我是 laravel 的新手，我不想浪費(fèi)我的時(shí)間來尋找雄辯的腳本來運(yùn)行我的復(fù)雜查詢腳本，有沒有適合我的方法。只需將我擁有的查詢腳本（選擇、插入、更新、刪除）寫入 laravel 項(xiàng)目，一切都按我想要的那樣工作？這是我選擇數(shù)據(jù)的示例代碼，我想用純查詢腳本替換雄辯的function getClaim(){ $data_claim = \App\ClaimModel::all(); return response()->json( [ "message" => $data_claim ] ); }
3 回答
幕布斯6054654
TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超7個(gè)贊
做這個(gè)
插入查詢
$insert = DB::insert("insert into some_table (col1, col2, col3) values ('value1', 'value2', 'value3')");選擇查詢
$results = DB::select("select * from some_table where some_col = 'some_value'");更新查詢
$update = DB::update("update some_table set col1 = ? , col2 = ? where col3 = ?", ['value1' , 'value2', 'value3']);刪除查詢
$delete = DB::delete('delete from some_table where col = ?',['value']);您也可以一次刪除多行。喜歡
$delete = DB::delete('delete from users where id = ?',[1, 2, 3]);
慕的地6264312
TA貢獻(xiàn)1817條經(jīng)驗(yàn) 獲得超6個(gè)贊
$users = DB::select('select * from users where active = ?', [1]);
return view('user.index', ['users' => $users]);
慕沐林林
TA貢獻(xiàn)2016條經(jīng)驗(yàn) 獲得超9個(gè)贊
你可以這樣做
對(duì)于選擇查詢
$users = DB::select('select * from users where active = ?', [1]);對(duì)于更新查詢
$affected = DB::update('update users set votes = 100 where name = ?', ['John']);對(duì)于刪除查詢
$deleted = DB::delete('delete from users');對(duì)于插入查詢
DB::insert('insert into users (id, name) values (?, ?)', [1, 'Dayle']);- 3 回答
- 0 關(guān)注
- 175 瀏覽
添加回答
舉報(bào)
0/150
提交
取消