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','<','8'); //user_id小于8的
   $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();
}