tp6对于model-＞curd

sql:


model:

<?php
namespace app\model;
use think\Model;
class Aaa extends Model
{

}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
 

controller:

<?php
namespace app\index\controller;

use app\BaseController;
use think\facade\Db;
use app\model\Aaa;
class Index extends BaseController
{
    public function hello()
    {
   		$user=new Aaa();
   		$data=['name'=>"vvvv"];
   		$user->allowField(['name'])->save($data);//只能name插入数据

    }
}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
 

修改：

<?php
namespace app\index\controller;

use app\BaseController;
use think\facade\Db;
use app\model\Aaa;
class Index extends BaseController
{
    public function hello()
    {
   		$user=Aaa::where('name',"vvvv")->find();//找到name为vvvv的字段
   		$user->name="liwen";//修改其name值
   		$user->save();

    }
}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
 

修改的第二种方式：

<?php
namespace app\index\controller;

use app\BaseController;
use think\facade\Db;
use app\model\Aaa;
class Index extends BaseController
{
    public function hello()
    {
   		Aaa::update(['name'=>"fff",'id'=>3]);
    }
}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
 

删除：

<?php
namespace app\index\controller;

use app\BaseController;
use think\facade\Db;
use app\model\Aaa;
class Index extends BaseController
{
    public function hello()
    {
   		$user=Aaa::find(2);
   		$user->delete();
    }
}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
 

查询：

<?php
namespace app\index\controller;

use app\BaseController;
use think\facade\Db;
use app\model\Aaa;
class Index extends BaseController
{
    public function hello()
    {
   		$aaa=Aaa::select([3,4]);
   		halt($aaa);

    }
}

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
 

文章来源: blog.csdn.net，作者：贵哥的编程之路(热爱分享)，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/qq_37805832/article/details/124806244