abstract:<?php namespace App\Http\Controllers\home; use Illuminate\Http\Request; use App\Http\Controllers\Controller; use Illuminate\Support\Facades\DB; class StuController
<?php namespace App\Http\Controllers\home; use Illuminate\Http\Request; use App\Http\Controllers\Controller; use Illuminate\Support\Facades\DB; class StuController extends Controller { // 主函數(shù)調(diào)用 public function main() { // 查詢操作 $res = $this->select(); dump($res); // 寫入操作 $res = $this->insert(); dump($res); // 更新操作 $res = $this->update(); dump($res); //刪除操作 $res = $this->del(); dump($res); } // 查詢操作 private function select() { // 獲取指定ID的一條數(shù)據(jù) $res = DB::table('stu')->find(1); // 獲取隨機(jī)的一條記錄 $res = DB::table('stu')->inRandomOrder()->first(); // 獲取所有數(shù)據(jù) $res = DB::table('stu')->get(); //dump($res); return $res; } // 寫入操作 private function insert() { // 寫入并返回自增ID $res = DB::table('stu')->insertGetId([ 'name'=>'杰森斯坦森', 'age' =>33, 'salary'=>6768, 'create_time'=>time(), 'update_time'=>time() ]); //dump($res); return $res; } // 更新操作 private function update($id=7) { $res = DB::table('stu')->where('id',$id)->update([ 'salary'=>8867 ]); return $res; } // 刪除操作 private function del($id=7) { $res = DB::table('stu')->where('id',$id)->delete(); return $res; } }
Correcting teacher:天蓬老師Correction time:2019-05-15 13:33:12
Teacher's summary:laravel 框架是眾多常用框架之祖, 它的一些思想, 被廣泛采用