ThinkPHP模型怎么定义_ThinkPHP模型定义关联及数据操作方法指南

namespace app\index\model;

use think\Model;

class User extends Model
{
    // 可以在这里设置表名、字段等信息
    protected $table = 'user'; // 非必须，若类名与表名一致可省略
}

// 1. 一对一：User hasOne Profile
public function profile()
{
    return $this->hasOne('Profile', 'user_id', 'id');
}

// 2. 一对多：User hasMany Article
public function articles()
{
    return $this->hasMany('Article', 'user_id', 'id');
}

// 3. 多对多：User belongsToMany Role
public function roles()
{
    return $this->belongsToMany('Role', 'user_role', 'role_id', 'user_id');
}

// 4. 属于：Article belongsTo User
public function user()
{
    return $this->belongsTo('User', 'user_id', 'id');
}

$user = User::with('articles')->find(1);
echo $user->articles[0]->title;

// 查询单条
$user = User::get(1);
$user = User::where('name', '张三')->find();

// 查询多条
$list = User::all();
$list = User::where('status', 1)->select();

$user = new User;
$user->name = '李四';
$user->email = 'lisi@example.com';
$user->save();

// 或使用静态方法
User::create([
    'name' => '王五',
    'email' => 'wangwu@example.com'
]);

$user = User::get(1);
$user->name = '新名字';
$user->save();

// 批量更新
User::update(['status' => 0], ['status' => 1]);

$user = User::get(1);
$user->delete();

// 或通过主键删除
User::destroy(1);
User::destroy([1, 2, 3]);

// 条件删除
User::where('status', 0)->delete();

class User extends Model
{
    protected $autoWriteTimestamp = true;
    // 若字段名为非标准名称，可指定
    // protected $createTime = 'create_time';
    // protected $updateTime = 'update_time';
}

public function getStatusAttr($value)
{
    $status = [0 => '禁用', 1 => '启用'];
    return $status[$value];
}

public function setNameAttr($value)
{
    return strtolower($value);
}

protected $validate = 'UserValidate';

// 或直接调用
$validate = validate('User');
if (!$validate->check($data)) {
    echo $validate->getError();
}