laravel 基本数据操作

//查询整张表的数据发送到视图 public function test(){ $test_data=Test::all()->toArray(); //$test_data=DB::table('test')->get()->toArray(); return view('test/form',['data'=>$test_data]); } //添加数据 public function test1(){ $data=Request::all(); $data['username']; $num=DB::table('test')->insert([ ['username'=>$data['username'],'title'=>$data['title'],'content'=>$data['content'],'addtime'=>date('Y-m-d H:i:s',time())] ]); //添加成功 查询发送数据 if($num){ $test_data=Test::all()->toArray(); //$test_data=DB::table('test')->get()->toArray(); return view('test/form',['data'=>$test_data]); } } //删除数据 public function del($id){ //echo $id; $num=DB::table('test')->where('id',$id)->delete(); if($num){ echo "1"; }else{ echo "0"; } } //综合 public function query1(){ //添加 /*$bool=DB::table('test')->insert([ ['username'=>'test1','title'=>'test1234'], ['username'=>'test2','title'=>'test12345'], ['username'=>'test3','title'=>'test12345'], ['username'=>'test4','title'=>'test12345'], ['username'=>'test5','title'=>'test12345'], ]);*/ /*$bool=DB::table('test')->insertGetId(['username'=>'test123','title'=>'test123']);*/ //print_r($bool); //修改 /*$num =DB::table('test') ->where(['id'=>1]) ->update(['username'=>'username']);*/ //自增 自减 //$num = DB::table('test')->where(['id'=>1])->increment('title');//默认是加1 /*$num = DB::table('test') ->where(['id'=>1]) ->decrement('title',12,['username'=>'testtestygbaefj']);//默认是减1 修改*/ //删除 //$num = DB::table('test')->where('id',1)->delete(); //$num = DB::table('test')->where('id','>=',3)->delete(); //$num = DB::table('test')->truncate(); //var_dump($num );die; //查询 //$num = DB::table('test')->where('id','>','2')->orderBy('id','desc')->get();//查询多条数据 //$num =DB::table('test')->where('id','>',2)->first();//查询一条数据 //多条件查询 //$num =DB::table('test')->whereRaw('id >? and username=?',['2','test3'])->get(); //返回结果集中指定的字段pluck list select //$name =DB::table('test')->where('id','4')->pluck('username'); //$name =DB::table('test')->lists('username','id'); //$name =DB::table('test')->limit(3)->select('username','id','title')->get();//多字段查询 //chunk 拆分 /*$name =DB::table('test')->chunk(2,function($stutent){ print_r($stutent);return false; //if(){ //return false;终止 //} });*/ //聚合函数 count max min avg sum //$num =DB::table('test')->count(); //$num =DB::table('test')->max('id'); //$num =DB::table('test')->min('id'); //$num =DB::table('test')->avg('id'); //$num =DB::table('test')->sum('id'); //dd($num); //return "fhasdpofaspofjpa"; } //查询构造器 public function rom(){ //查询 //$test=Test::all();//查询所有记录 //$test =Test::find(1);//查询1条记录 //$test =Test::findOrFail(1);//查询1条记录 //$test=Test::get(); //$test=Test::where('id','>','2')->orderBy('id','desc')->first(); // Test::chunk(2,function($test){dd($test); }); //dd($test); //$num=Test::where('id','>',2)->count(); //$num =Test::where('id','>',2)->max('id'); //添加 $test =new Test(); $test->username='test2'; $test->title='test2'; $test->content='test2'; $data=$test->save(); $test=Test::find(6); $update_at=$test->created_at; echo $update_at; //print_r(date('Y-m-d H:i:s',$test->created_at)); }