Thinkphp6 with的用法详解

预载入查询

##### 表：

- word
- word_remember

对应的Model

- WordRememberModel
- WordModel

## WordModel代码

## WordRememberModel代码
```
<?php
declare (strict_types = 1);

namespace app\common\model;
use think\Model;

class WordRememberModel extends Model
{
    protected $name = 'word_remember';
    protected $pk = 'id';

public function word(){
		return $this->hasOne(WordModel::class, 'id', 'member_id');
	}

}
```
控制器
```
public function myVocabulary(WordRememberModel $obj){
	$list = WordRememberModel::with(['word'])->select()->toArray();
	print_r($list);
	exit;
}
```
正常输出
```
Array ( [0] => Array ( [word_id] => 1 [member_id] => 1 [word] => Array ( [id] => 1 [title] => a ) ) )
```

### 数据库表结构

**lqbcms_word_remember**
```sql
CREATE TABLE `lqbcms_word_remember` (
  `word_id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='例子';
```

**lqbcms_word**
```sql
CREATE TABLE `lqbcms_word` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=103994 DEFAULT CHARSET=utf8mb4 COMMENT='英语单词';
```

官网文档地址：https://www.kancloud.cn/manual/thinkphp6_0/1037600

文章来源：https://liqingbo.com/blog-1780.html

上一篇：ThinkPHP6官方Apache伪静态无效的解决方法

下一篇：ThinkPHP6.0 扩展类库目录（extend）

PHP博客

Thinkphp6 with的用法详解

相关文章

评论

最近发布