php laravel 增删查改,Laravel-增删改查

用户Model创建

php artisan make:model User

Laravel-增删改查

1、数据添加

路由/app/http/routes.php

Route::get('/test',function(){

$user=new App\User();

$user->userAdd();

return $user->userRead();

});

/app/User.php Model

public function userAdd()

{

//方法1 字段作为数组形式填充到表

$user_data=['username'=>'yuan','age'=>22];

$this->fill($user_data);

//方法2 单个字段变量保存到表

$this->username='caoyuan';

$this->age=18;

$this->save();

}

2、关闭时间戮

/app/User.php

public $timestamps=false; 默认为 true，False关闭

3、get或or默认返回所有的

public function userTest()

{

return $this->all();

｝

4、数据修改

路由/app/http/routes.php

Route::get('/test',function(){

$user=new App\User();

//$user->userAdd();

$user->userUpdate();

return $user->userRead();

});

单个数据修改

/app/User.php

public function userUpdate(){

$user=$this->find(8);

$user->username="laobai";

$user->age=80;

$user->save();

}

批量修改数据

public function userUpdate(){

$users=$this->where('user_id','

$users->update(['username'=>'dabai','age'=>60]);

//update返回的是集合数据自带保存数据

// $users->save();

}

5、删除数据

路由/app/http/routes.php

Route::get('/test',function(){

$user=new App\User();

$user->userDelete();

return $user->userRead();

});

/app/User.php

public function userDelete()

{

$user=$this->find(8);

$user->delete();

}