## 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(); ~~~