tp5模型笔记---一对一

关联模型


一对一：HAS_ONE  以及对应的BELONEGS_TO
一对多：HAS_MANY 以及相对的BELONGS_TO
多对多：BELONGS_TO_MANY




步骤：


第一：创建Users模型
第二：创建Comment模型
第三：在Users模型添加方法
第四：在comment模型添加方法

第五：测试

User.php

namespace app\index\model;
use think\Model;
class Users extends Model{
	//用户和轿车的一对一关联模型
	public function car(){
		return $this->hasOne('Car','uid','user_id');
	}
}


Car.php

namespace app\index\model;
use think\Model
class Car extends Model{
     
}


namespace app\index\Controller;  
use think\Controller;  
use think\Db;  
use app\index\model\Users;  
use app\index\model\Common;  
class Index extends Controller{  
	public function test20(){
		$user=new Users;
		$user=User:;get(1);
		echo "车品牌:".$user->car->brand."车牌号：".$user->car->plate_number;
	}
	//一对一关联插入
	public function insert(){
		$user=new Users;
		$user=User:;get(1);
		$user->email='hello@1234.com';
		$user->nickname='TPshop';
		$user->password='123456789';
		if($user->save()){
			$car['brand']='奔驰';
			$car['plate_number']='北A458E1';
			$user->car()->save($car);
			return '用户['.$user->nickname.']新增成功';
		}else{
			return $user->getError();
		}
		//insert into tp_users('email','nickname','password') values('hello@1234.com','TPshop','123456789')
		insert into tp_car('brand','plate_number','uid') values('奔驰','北A458E1','2601')
	}
	public function select(){
		$user=User::get(2601);
		echo $user->email.'<br/>';
		echo $user->nickname.'<br/>';
		echo $user->car->brand.'<br/>';
		echo $user->car->plate_number.'<br/>';
	}
	public function select2(){
		$user=User::get(2601,'car');
		echo $user->email.'<br/>';
		echo $user->nickname.'<br/>';
		echo $user->car->brand.'<br/>';
		echo $user->car->plate_number.'<br/>';
		//select users.user_id,users.email,users.password,users.sex,users.birthday,users.user_money,users.frozen_money,users.distribut_money,users.pay_points,users.address_id,users.reg_time,users.last_login,users.last_ip,users.qq,users.mobile,users.openid,users.head_pic,users.province,users.city,users.district,users.em   and as car_brand,car.plate_number as car_plate_number,car.uid as car_uid from tp_users users 
inner join tp_car car on users.user_id=car.uid where users.user_id=2601 limit 1
	}
	//关联更新
	public function update2(){
		$user=Users::get(1);
		$user->email='TPshop@qq.com';
		if($user->save()){
			$user->car->plate_number='北B453E3';
			$user->car->save();
			return '用户[ '.$user->email.' ]更新成功';
		}else{
			return $user->getError();
		}
	//select * from tp_users where user_id=2601 limit 1
	//update tp_users set email='TPshop@qq.com' where user_id=2601
	//select * from tp_car where uid=2601 limit 1
	//update tp_car set plate_number='北B453E3' where id=4
	}
	//管理删除
	public function del(){
		$user=Users::get(2601);
		if($user->delete()){
			$user->car->delete();
			return '用户['.$user->email.' ]删除成功';
		}else{
			return $user->getError();
		}
	//select * from tp_users where user_id=2601 limit 1
	//delete from tp_users where user_id=2601
	//select * from tp_car where uid=2601 limit 1
	//delete from tp_car where id=4	
	}
}