批改狀態(tài):合格
老師批語:完成的很好, 圖文結(jié)合, 繼續(xù)
WHERE查詢
<?php namespace App\Http\Controllers; use Illuminate\Support\Facades\DB; use Illuminate\Http\Request; class Dbtest extends Controller { public function index(){ /*{ $res = DB::table('admin')->get()->all(); foreach ($res as $item){ echo $item->id.'-'.$item->email.'<br>'; } echo '<pre>'; print_r($res);*/ // 更新 // $res = DB::update('update admin set email="無縫1" where id=?',[1]); // 添加 // $res = DB::insert('insert admin(`email`,`psword`)values("xiaomao@qq.com","12345")'); // 刪除 // $res = DB::delete('delete from admin where id=:uid',['uid'=>2]); // 查詢 // $res = DB::select('select * from admin'); $res = DB::table('director')->where('tid','=',1)->first(); print_r($res); } } ?>
點(diǎn)擊 "運(yùn)行實(shí)例" 按鈕查看在線實(shí)例
分頁
<?php namespace App\Http\Controllers; use Illuminate\Support\Facades\DB; use Illuminate\Http\Request; class Dbtest extends Controller { public function index(){ /*{ $res = DB::table('admin')->get()->all(); foreach ($res as $item){ echo $item->id.'-'.$item->email.'<br>'; } echo '<pre>'; print_r($res);*/ // 分頁 $res = DB::table('director')->paginate(5); print_r($res); } } ?>
點(diǎn)擊 "運(yùn)行實(shí)例" 按鈕查看在線實(shí)例
微信掃碼
關(guān)注PHP中文網(wǎng)服務(wù)號(hào)
QQ掃碼
加入技術(shù)交流群
Copyright 2014-2025 http://ipnx.cn/ All Rights Reserved | php.cn | 湘ICP備2023035733號(hào)