tp5模型笔记---一对一

来源：互联网发布：平板淘宝怎么开店编辑：程序博客网时间：2024/06/05 20:53

关联模型

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

步骤：

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

第五：测试

User.phpnamespace app\index\model;use think\Model;class Users extends Model{//用户和轿车的一对一关联模型public function car(){return $this->hasOne('Car','uid','user_id');}}Car.phpnamespace app\index\model;use think\Modelclass 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}}

阅读全文

0 0