## Eloquent ORM * Laravel 的數據庫操作 [TOC] >[info] #### find(id) 返回一行數據,即一維結果 ~~~ model::find(1) model::findOrFail(1)未找到則報錯 ~~~ >[info] #### first() 返回一行數據,即一維結果 ~~~ model::where()->first() ~~~ >[info] #### value 獲取單個數據 ~~~ model::where()->value(字段名) ~~~ >[info] #### lists(字段) 獲取一列數據,返回單列數據,一維組 ~~~ model::where()->lists(字段,鍵(可選)) laravel 5.3版本后改名了pluck model::where()->pluck(字段,鍵(可選)) ~~~ >[info] #### get 獲取所有數據 返回二維數組 ~~~ model::where()->get() model::all()獲取所有表的數據 ~~~ >[info] #### updateOrCreate ~~~ model::updateOrCreate([條件], [值]); ~~~ >[info] #### firstOrCreate() ~~~ model::firstOrCreate([條件], [值]); ~~~ >[info] #### firstOrNew() ~~~ $obj = model::firstOrNew([條件], [值]) $obj->save()必須使用save才會創建新的數據 ~~~ >[info] #### create ~~~ model::create([字段=>值]) ~~~ >[info] #### save, update 修改數據 ~~~ 1.通過模型修改數據 $obj=model::find(1) $obj->字段=新值$obj->save()保存 2.model::where()->update([需要修改的數據]) ~~~ >[info] #### destory, delete 刪除數據 ~~~ 1.通過主鍵刪除:model::destory(主鍵ID,可多個值) 2.通過模型刪除:$obj = model::find(1)$obj->delete() ~~~ >[info] #### 轉換成數組 ~~~ 只需要跟上->toArray()即可 ~~~ >[info] #### paginate分頁 * 自帶分頁 ~~~ $users = DB::table('users')->paginate(15); $users = DB::table('users')->simplePaginate(15); ~~~ ~~~ <div class="container"> @foreach ($users as $user) {{ $user->name }} @endforeach </div> {!! $users->links() !!} ~~~ ~~~ $results->count() $results->currentPage() $results->firstItem() $results->hasMorePages() $results->lastItem() $results->lastPage() (使用simplePaginate時無效) $results->nextPageUrl() $results->perPage() $results->previousPageUrl() $results->total() (使用simplePaginate時無效) $results->url($page) ~~~ >[info] #### 自定義分頁 ~~~ $page_size = $this->config['page_size']; $page = empty($request->get('p')) ? 0 : $request->get('p'); $offset = $page_size * ($page - 1); $data = PiUrl::offset($offset) ->whereRaw($createWhere) ->limit($page_size) ->orderBy('updated_at', 'desc') ->get() ->toArray(); $total = PiUrl::whereRaw($createWhere)->count(); ~~~