Thinkphp5 联合(关联)查询

最新推荐文章于 2024-07-12 23:32:51 发布

tww85

最新推荐文章于 2024-07-12 23:32:51 发布

阅读量1.2w

点赞数

分类专栏： ThinkPHP

本文链接：https://blog.csdn.net/tww85/article/details/52884964

版权

ThinkPHP 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

按照官方手册http://www.kancloud.cn/manual/thinkphp5/142357 折腾了很久还是无法实现，可能还是我理解的不对，最后使用了如下方式：

1. 项目表

DROP TABLE IF EXISTS `darling_project`;
CREATE TABLE `darling_project` (
`project_id` int(32) NOT NULL AUTO_INCREMENT,
`project_name` varchar(20) NOT NULL,
`create_time` int(32) NOT NULL,
PRIMARY KEY (`project_id`),
UNIQUE KEY `project_id` (`project_id`),
UNIQUE KEY `project_name` (`project_name`)
);

2. 版本号表
DROP TABLE IF EXISTS `darling_version`;
CREATE TABLE `darling_version` (
`version_id` int(32) NOT NULL AUTO_INCREMENT,
`project_id` int(32) NOT NULL,
`version_name` varchar(128) NOT NULL,
`create_time` int(32) NOT NULL,
PRIMARY KEY (version_id),
UNIQUE KEY `version_id` (`version_id`)
);

3. 联合查询

                $where=array(
                    "version_id"=>$_POST['version_id']
                );               
                $Project_version = model('Project')->join("darling_version","darling_version.project_id = darling_project.project_id")->where($where)->find();