第三章 laravel中的模型关联查询

最新推荐文章于 2024-09-01 10:05:05 发布
最新推荐文章于 2024-09-01 10:05:05 发布
阅读量2.5k 收藏 2
点赞数 1
分类专栏： # laravel框架
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/DarkAngel1228/article/details/81297717
版权

一.准备

1.SQL

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `phone`;
CREATE TABLE `phone`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

INSERT INTO `phone` VALUES (1, 'www.baidu.com1', 1);
INSERT INTO `phone` VALUES (2, 'www.baidu.com2', 1);
INSERT INTO `phone` VALUES (3, 'www.baidu.com3', 2);
INSERT INTO `phone` VALUES (4, 'www.baidu.com4', 2);
INSERT INTO `phone` VALUES (5, 'www.baidu.com5', 3);
INSERT INTO `phone` VALUES (6, 'www.baidu.com6', 4);
INSERT INTO `phone` VALUES (7, 'www.baidu.com7', 5);
INSERT INTO `phone` VALUES (8, 'www.baidu.com8', 3);
INSERT INTO `phone` VALUES (9, 'www.baidu.com9', 4);
INSERT INTO `phone` VALUES (10, 'www.baidu.com10', 5);
INSERT INTO `phone` VALUES (11, 'www.baidu.com11', 6);

SET FOREIGN_KEY_CHECKS = 1;


SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'Freddy Stokes DDS', 'jeffrey38@gmail.com', 'LG1yn\"', '6bca2488-cb0f-315b-8cea-09b1e76aea3c', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (2, 'Stefanie Lang', 'kellen49@hotmail.com', 'aO9+|gvmx3A', 'd7ee4f80-35b4-3424-bbdc-afce5138f41c', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (3, 'Mr. Janick Lubowitz', 'gnienow@gmail.com', '6Q#\'.[;XeG]l_', '2d213e3c-bc4c-30bd-ac8f-96059f12064b', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (4, 'Gardner Langosh', 'beer.barrett@gmail.com', '[lmO_oE_oXGAe2', 'fa2b8fe9-e509-340b-8eb6-5e92621bcfa6', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (5, 'Kennedi Torp', 'xkilback@hotmail.com', 'q$!9K,*G-E-C#>v', '978cb679-c5f3-3d03-a8fe-f410fcb4d2c7', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (6, 'Dr. Amari Sauer', 'buddy.jakubowski@rath.com', 'OdH#%P', 'c6a5b8ba-148d-30f0-8fc1-f92e9537f3ac', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (7, 'Dr. Kathlyn Watsica', 'wilfredo64@bartoletti.net', ')<bdWYr:;^YI&s\'', '2d5262f6-7743-30c9-b210-c4ad9e93d288', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (8, 'Elnora Gaylord', 'ufahey@hotmail.com', '*%[J`O', '9d05dc9b-c482-3b9b-978c-dade643d5f5e', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (9, 'Jessyca Klocko DDS', 'dianna.kerluke@runte.com', '%`okm%^tYj^', '9a135dee-981f-35d7-95a2-810175f81014', '2018-07-26 02:57:50', '2018-07-26 02:57:50');
INSERT INTO `users` VALUES (10, 'Mrs. Kaylee Beer', 'yhackett@yahoo.com', 'FR\'=KEPu\\X`y;!gLL', '251f997f-16a5-34dd-a112-1519d1550b55', '2018-07-26 02:57:50', '2018-07-26 02:57:50');

SET FOREIGN_KEY_CHECKS = 1;

2.模型

// UserModel模型
class UserModel extends Model
{
    protected $table = 'users';
}
// PhoneModel模型
class PhoneModel extends Model
{
    protected $table = 'phone';
}

二.一对一

1.正向关联

// UserModel模型
class UserModel extends Model
{
    protected $table = 'users';

    public function phone()
    {
        return $this->hasOne('App\PhoneModel');
        // 报错
        // SQL: select * from `phone` where `phone`.`user_model_id` = 1 and `phone`.`user_model_id` is not null limit 1
    }


    public function phone()
    {
        # 它会自动假设 Phone 模型拥有 user_id 外键。
        # 如果你想要重写这个约定，则可以传入第二个参数到 hasOne 方法里。
        return $this->hasOne('App\PhoneModel', 'user_id');
    }

    public function phone()
    {
        # Eloquent 假设外键会和上层模型的 id 字段（或者自定义的 $primaryKey）的值相匹配。
        # 否则，请
        return $this->hasOne('App\PhoneModel', 'user_id', 'id');
    }
}

// 控制器调用
DB::connection()->enableQueryLog(); //打印SQL

$user = UserModel::find(1);
$user->phone;
echo '<pre />';print_r(DB::getQueryLog());
dd($user->toArray());

// 结果
Array
(
    [0] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1008
        )

    [1] => Array
        (
            [query] => select * from `phone` where `phone`.`user_id` = ? and `phone`.`user_id` is not null limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 2
        )

)
array:8 [
  "id" => 1
  "name" => "Freddy Stokes DDS"
  "email" => "jeffrey38@gmail.com"
  "password" => "LG1yn""
  "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
  "created_at" => "2018-07-26 02:57:50"
  "updated_at" => "2018-07-26 02:57:50"
  "phone" => array:3 [
    "id" => 1
    "url" => "www.baidu.com1"
    "user_id" => 1
  ]
]

2.反向关联

# class Phone extends Model 
public function user() {
    return $this->belongsTo('App\User', 'user_id');
    // return $this->belongsTo('App\User', 'foreign_key');
    // return $this->belongsTo('App\User', 'foreign_key', 'other_key');
}
Array
(
    [0] => Array
        (
            [query] => select * from `phone` where `phone`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1021
        )

    [1] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 2
        )

)
array:4 [
  "id" => 1
  "url" => "www.baidu.com1"
  "user_id" => 1
  "user" => array:7 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
  ]
]

三.一对多

1.正向关联

class UserModel extends Model
{

    protected $table = 'users';

    public function phone()
    {
        return $this->hasMany('App\PhoneModel', 'user_id');
    }
}
// 打印
Array
(
    [0] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1013
        )

    [1] => Array
        (
            [query] => select * from `phone` where `phone`.`user_id` = ? and `phone`.`user_id` is not null
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 3
        )

)
array:8 [
  "id" => 1
  "name" => "Freddy Stokes DDS"
  "email" => "jeffrey38@gmail.com"
  "password" => "LG1yn""
  "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
  "created_at" => "2018-07-26 02:57:50"
  "updated_at" => "2018-07-26 02:57:50"
  "phone" => array:2 [
    0 => array:3 [
      "id" => 1
      "url" => "www.baidu.com1"
      "user_id" => 1
    ]
    1 => array:3 [
      "id" => 2
      "url" => "www.baidu.com2"
      "user_id" => 1
    ]
  ]
]

2.反向关联

Array
(
    [0] => Array
        (
            [query] => select * from `phone` where `phone`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1031
        )

    [1] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 2
        )

)
array:4 [
  "id" => 1
  "url" => "www.baidu.com1"
  "user_id" => 1
  "user" => array:7 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
  ]
]

四.多对多

1.SQL

DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `role_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of role_user
-- ----------------------------
INSERT INTO `role_user` VALUES (1, 1, 1);
INSERT INTO `role_user` VALUES (2, 1, 2);
INSERT INTO `role_user` VALUES (3, 2, 1);
INSERT INTO `role_user` VALUES (4, 2, 2);


DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'guanliyuan');
INSERT INTO `roles` VALUES (2, 'yonghu');
INSERT INTO `roles` VALUES (3, 'huiyuan');

2.模型和调用

// 模型
class UserModel extends Model
{

    protected $table = 'users';

    public function role()
    {
        return $this->belongsToMany('App\RoleModel', 'role_user', 'user_id', 'role_id');
    }
}

// 调用
DB::connection()->enableQueryLog();

$user = UserModel::find(1)->role;

echo '<pre />';print_r(DB::getQueryLog());
dd($user->toArray());
// 打印
Array
(
    [0] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1011
        )

    [1] => Array
        (
            [query] => select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ?
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 2
        )

)
array:2 [
  0 => array:3 [
    "id" => 1
    "role_name" => "guanliyuan"
    "pivot" => array:2 [
      "user_id" => 1
      "role_id" => 1
    ]
  ]
  1 => array:3 [
    "id" => 2
    "role_name" => "yonghu"
    "pivot" => array:2 [
      "user_id" => 1
      "role_id" => 2
    ]
  ]
]

3.反向关联

<?php
# class Role extends Model 
public function users() {
    return $this->belongsToMany('App\User'); 
}

4.操作中间表

我们取出的每个 Role 模型对象，都会被自动赋予 pivot 属性。

  • 获取中间表字段
# 默认情况下，pivot 对象只提供模型的键。如果你的 pivot 数据表包含了其它的属性，则可以在定义关联方法时指定那些字段：
return $this->belongsToMany('App\Role')->withPivot('id');
Array
(
    [0] => Array
        (
            [query] => select * from `users` where `users`.`id` = ? limit 1
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 1016
        )

    [1] => Array
        (
            [query] => select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id`, `role_user`.`id` as `pivot_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = ?
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 4
        )

)
array:2 [
  0 => array:3 [
    "id" => 1
    "role_name" => "guanliyuan"
    "pivot" => array:3 [
      "user_id" => 1
      "role_id" => 1
      "id" => 1
    ]
  ]
  1 => array:3 [
    "id" => 2
    "role_name" => "yonghu"
    "pivot" => array:3 [
      "user_id" => 1
      "role_id" => 2
      "id" => 3
    ]
  ]
]
# 如果你想要中间表自动维护 created_at 和 updated_at 时间戳，可在定义关联方法时加上  withTimestamps 方法：

return $this->belongsToMany('App\Role')->withTimestamps();
  • 使用中间表来过滤关联数据
# 你可以使用 wherePivot 和 wherePivotIn 来增加中间件表过滤条件：

return $this->belongsToMany('App\Role')->wherePivot('id', 1);

return $this->belongsToMany('App\Role')->wherePivotIn('id', [1, 2]);
  • 重命名 pivot
# 你可以使用 wherePivot 和 wherePivotIn 来增加中间件表过滤条件：
return $this->belongsToMany('App\Podcast')
                ->as('subscription')
                ->withTimestamps();

// 使用
$users = User::with('podcasts')->get();
foreach ($users->flatMap->podcasts as $podcast) {
    echo $podcast->subscription->created_at;
}

五.关联查询

1.查找关联是否存在

// 获取那些至少拥有一个手机号的人
$user = UserModel::has('phone')->get();
#select * from `users` where exists (select * from `phone` where `users`.`id` = `phone`.`user_id`)

// 获取没有手机号的人
$user = UserModel::doesntHave('phone')->get();
#select * from `users` where not exists (select * from `phone` where `users`.`id` = `phone`.`user_id`)

// 获取所有至少有2个手机号的人
$user = UserModel::has('phone', '>=', 2)->get();
#select * from `users` where (select count(*) from `phone` where `users`.`id` = `phone`.`user_id`) >= 2

# 如果你想要更高级的用法，则可以使用 whereHas 和 orWhereHas 方法
# 在 has 查找里设置「where」条件。
# 此方法可以让你增加自定义条件至关联条件中，例如对评论内容进行检查

$user = UserModel::whereHas('phone', function ($query) {
    $query->where('url', 'like', '%2%');
})->get();

$user = UserModel::whereDoesntHave('phone', function ($query) {
    $query->where('url', 'like', '%2%');
})->get();

2.关联数据计数

# 如果你想对关联数据进行计数,请使用 withCount 方法，
# 此方法会在你的结果集中增加一个 {relation}_count 字段

$user = UserModel::withCount('phone')->get();

Array
(
    [0] => Array
        (
            [query] => select `users`.*, (select count(*) from `phone` where `users`.`id` = `phone`.`user_id`) as `phone_count` from `users`
            [bindings] => Array
                (
                )

            [time] => 1014
        )

)
array:10 [
  0 => array:8 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "phone_count" => 2
  ]
]

3.预加载 ——- 这个重点

  • with
$user = UserModel::with('role')->get();
Array
(
    [0] => Array
        (
            [query] => select * from `users`
            [bindings] => Array
                (
                )

            [time] => 1004
        )

    [1] => Array
        (
            [query] => select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` in (?)
            [bindings] => Array
                (
                    [0] => 1
                )

            [time] => 0
        )

)
array:10 [
  0 => array:8 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => array:2 [
      0 => array:3 [
        "id" => 1
        "role_name" => "guanliyuan"
        "pivot" => array:2 [
          "user_id" => 1
          "role_id" => 1
        ]
      ]
      1 => array:3 [
        "id" => 2
        "role_name" => "yonghu"
        "pivot" => array:2 [
          "user_id" => 1
          "role_id" => 2
        ]
      ]
    ]
  ]
]
  • 预加载条件限制
$user = UserModel::with(['role'=>function($query){
    $query->where('role_name', 'like', '%guanliyuan%');
}])->get();
$user = UserModel::with(['role' => function ($query) {
    $query->orderBy('id', 'desc');
}])->get();
Array
(
    [0] => Array
        (
            [query] => select * from `users`
            [bindings] => Array
                (
                )

            [time] => 1011
        )

    [1] => Array
        (
            [query] => select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `role_name` like ?
            [bindings] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                    [4] => 5
                    [5] => 6
                    [6] => 7
                    [7] => 8
                    [8] => 9
                    [9] => 10
                    [10] => %guanliyuan%
                )

            [time] => 4
        )

)
array:10 [
  0 => array:8 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => array:1 [
      0 => array:3 [
        "id" => 1
        "role_name" => "guanliyuan"
        "pivot" => array:2 [
          "user_id" => 1
          "role_id" => 1
        ]
      ]
    ]
  ]
  1 => array:8 [
    "id" => 2
    "name" => "Stefanie Lang"
    "email" => "kellen49@hotmail.com"
    "password" => "aO9+|gvmx3A"
    "remember_token" => "d7ee4f80-35b4-3424-bbdc-afce5138f41c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => array:1 [
      0 => array:3 [
        "id" => 1
        "role_name" => "guanliyuan"
        "pivot" => array:2 [
          "user_id" => 2
          "role_id" => 1
        ]
      ]
    ]
  ]
  2 => array:8 [
    "id" => 3
    "name" => "Mr. Janick Lubowitz"
    "email" => "gnienow@gmail.com"
    "password" => "6Q#'.[;XeG]l_"
    "remember_token" => "2d213e3c-bc4c-30bd-ac8f-96059f12064b"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => []
  ]
  3 => array:8 [
    "id" => 4
    "name" => "Gardner Langosh"
    "email" => "beer.barrett@gmail.com"
    "password" => "[lmO_oE_oXGAe2"
    "remember_token" => "fa2b8fe9-e509-340b-8eb6-5e92621bcfa6"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => []
  ]
]
  • 延迟预加载
    有时你可能需要在上层模型被获取后才预加载关联。
// 调用
$users = UserModel::all();
$users->load('role');

Array
(
    [0] => Array
        (
            [query] => select * from `users`
            [bindings] => Array
                (
                )

            [time] => 1030
        )

    [1] => Array
        (
            [query] => select `roles`.*, `role_user`.`user_id` as `pivot_user_id`, `role_user`.`role_id` as `pivot_role_id` from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            [bindings] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                    [4] => 5
                    [5] => 6
                    [6] => 7
                    [7] => 8
                    [8] => 9
                    [9] => 10
                )

            [time] => 2
        )

)
array:10 [
  0 => array:8 [
    "id" => 1
    "name" => "Freddy Stokes DDS"
    "email" => "jeffrey38@gmail.com"
    "password" => "LG1yn""
    "remember_token" => "6bca2488-cb0f-315b-8cea-09b1e76aea3c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => array:2 [
      0 => array:3 [
        "id" => 1
        "role_name" => "guanliyuan"
        "pivot" => array:2 [
          "user_id" => 1
          "role_id" => 1
        ]
      ]
      1 => array:3 [
        "id" => 2
        "role_name" => "yonghu"
        "pivot" => array:2 [
          "user_id" => 1
          "role_id" => 2
        ]
      ]
    ]
  ]
  1 => array:8 [
    "id" => 2
    "name" => "Stefanie Lang"
    "email" => "kellen49@hotmail.com"
    "password" => "aO9+|gvmx3A"
    "remember_token" => "d7ee4f80-35b4-3424-bbdc-afce5138f41c"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => array:2 [
      0 => array:3 [
        "id" => 1
        "role_name" => "guanliyuan"
        "pivot" => array:2 [
          "user_id" => 2
          "role_id" => 1
        ]
      ]
      1 => array:3 [
        "id" => 2
        "role_name" => "yonghu"
        "pivot" => array:2 [
          "user_id" => 2
          "role_id" => 2
        ]
      ]
    ]
  ]
  2 => array:8 [
    "id" => 3
    "name" => "Mr. Janick Lubowitz"
    "email" => "gnienow@gmail.com"
    "password" => "6Q#'.[;XeG]l_"
    "remember_token" => "2d213e3c-bc4c-30bd-ac8f-96059f12064b"
    "created_at" => "2018-07-26 02:57:50"
    "updated_at" => "2018-07-26 02:57:50"
    "role" => []
  ]

六.插入 & 更新关联模型

DarkAngel1228
关注
专栏目录
laravel模型关联
mofeng24的博客
07-01 2415
laravel模型关联 模型关联 PS：主表主键设为 id，关联主键默认就是 id，可以默认不写； PS：附表的外键设置为 user_id，即：主表名_主键，吻合可默认不写 一对一 //正相关联 User.php，一对一关联Profile表 namespace App\Http\Models; use Illuminate\Database\Eloquent\Model; class User extends Model { public function profile(){ //参数1
mysql多态关联_Laravel 多态关联中利用关联表相关字段进行排序的问题
weixin_35063099的博客
02-08 771
1 目标1.1 在 Laravel 项目的开发中，多态的需求很常见，按多态关联进行排序的需求也是必须的。1.2 请想像，我们有一个需求，荣誉栏目多态关联一个档案模型，要求在荣誉中按档案的推荐时间进行排序，以获取最近推荐内容的前5条。2 测试2.1 Honournamespace App;use App\Traits\HasArchive;use Illuminate\Database\Eloque...
laravel 关联模型
weixin_30545285的博客
05-22 271
官方文档5.5：https://laravelacademy.org/post/8203.html 一对一 hasone (用户-手机号) 一对多 hasmany（文章-评论） 一对多反向 belongsto （评论-文章） 多对多belongstomany （用户-角色） 远层一对多hasmanythrough （国家-作者-文章） 多态关联 morphmany...
Laravel框架模型关联应用教程
最新发布
BOBO博客
09-01 1231
Laravel框架的Eloquent ORM提供了丰富的模型关联功能，使得处理数据库表之间的关系变得简单而高效
Laravel 模型引入以及关联模型查询
qq_59717525的博客
09-15 406
引入模型 第一种 useApp\Model\home\User; $data=User::get(); 第二种 $data=\App\Model\home\User::get();
Laravel 模型关联建立与查询
青及笄经验分享
11-10 3760
hasone hasmany,belongsTo,belongsTomany,with,whereHas等关系，以及with，whereHas的使用
【Laravel笔记】10. 模型的关联查询
拾年之璐
02-06 9294
本文主要内容： 10.1 关联概念 10.2 一对一关联 10.3 一对多关联 10.4 多对多关联 10.5 关联查询 10.1 关联概念 关联模型，即：两张或以上的表进行一定规则的绑定关联。 比如： 一个学生(学生表)对应一张个人信息卡(信息表)，这种就是一对一； 一篇博文(帖子表)对应多个评论(评论表)，这种就是一对多； 一个用户(用户表)对应多个职位(权限表)，而一个职位又可以有多个用户；那么，这种就是多对多关联； 当然，还有更多更复杂的关联，都是基于此的。
Laravel5.1 框架关联模型之后操作实例分析
10-15
'sub_title' => 'Laravel 模型关联的使用', 'content' => 'content...' ], ['expires' => true]); ``` ### 2. 更新关联关系 #### 2.1 更新一个关系（除多对多） 更新关联关系通常涉及到已存在的关联模型。例如...
Laravel5.1 框架模型多态关联用法实例分析
10-15
`morphTo`方法默认关联名为`morphs_type`的字段，除非你显式地指定了第三个参数为其他字段名。 3. 实际操作时，可以通过访问`Article`或`Video`模型的`comments`属性来获取其关联的评论集合，例如： ```php $video...
laravel 模型查询按照whereIn排序的示例
10-16
本篇知识点将详细介绍如何在Laravel模型查询中使用`whereIn`方法进行数据筛选，并按照特定的数组顺序对结果集进行排序。 首先，`whereIn`是Eloquent提供的一个方法，用于从数据库中选取某个字段在指定数组中的数据...
Laravel Model模型关联
m0_58027884的博客
04-24 1255
定义关联关系 数据库表通常相互关联。 例如，一篇博客文章可能有许多评论，或者一个订单对应一个下单用户。Eloquent 让这些关联的管理和使用变得简单，并支持多种类型的关联：常见的为前三种，在此我们也只讲解前三种关联 一对一 一对多 多对多 远程一对多 远程一对一 一对一（多态关联） 一对多（多态关联） 多对多 建立模型关联 一对一 两个数据表：guest 用户表和guestinfo用户信息 其中guest表中的主键id字段对应着guestinfo中的外键user_id字段 首先创建两个model文件：
laravel中的模型关联
云别
04-25 587
Laravel中常用的模型关联 一对一 hasOne 用户-手机号 一对多 hasMany 文章-评论 一对多反向 belongTo 评论-文章 多对多 belongsToMany 用户-角色 远层一对多 hasManyThrough 国家-作者-文章 多态关联 morphMany 文章/视频-评论 多态多对多 morphToMany 文章/视频-标签...
laravel 模型关联
KobeHoo的博客
12-27 698
一对一  hasOne (用户-&gt;手机号)   -&gt;withDefault();  返回指定默认对象 public function phone() { return $this-&gt;hasOne('App\Phone', 'user_id', 'id'); } public function user(){ return $this...
laravel 关联模型
weixin_41565755的博客
10-29 1663
一、模型 1、文章模型 class Article extends Model { /* id 文章id（关联键） article_name 文章name author_id 作者id */ protected $table = 'article'; public $timestamps = false; protected $fillable = [self::ARTI
Laravel Eloquent 模型关联速查表
PqjoPuppet的博客
09-17 394
本文介绍了一对一关联、一对多关联、多对多关联和多态关联，并提供了相应的源代码示例。其中，模型关联是Eloquent的一个核心功能，它允许我们在不同的数据库表之间建立关系，并轻松地进行查询操作。一个用户可以有多个角色，一个角色也可以被多个用户拥有，因此User表和Role表之间存在多对多关联。本文将介绍Laravel Eloquent模型关联的常见类型，包括一对一关联、一对多关联、多对多关联以及多态关联，并提供相应的源代码示例。在Laravel中，我们可以使用belongsToMany方法来建立多对多关联。
二十八、PHP框架Laravel学习笔记——模型的关联查询
zep
06-01 544
二．关联查询 前几篇博文，了解了三种基础的关联模型，并简单的进行查询； 本节课，我们详细的了解更多的查询方案； //下面两种查询是一样的； $books = User::find(19)->book; $books = User::find(19)->book()->get(); //可以采用 where 筛选或闭包 $books = User::find(19)->book() ->where('id', 1)->orWhere('id', 11)->
Laravel关系模型指定条件查询
qq_32450471的博客
09-30 581
}
laravel的连表查询
m0_53408962的博客
12-09 323
注意：在写关联模型的时候要分析出谁关联谁。■、执行生成数据表的迁移文件。需要将关联的代码写在主模型中。当前例子主模型是文章模型。数据表外键的定义方法。
Laravel教程：Eloquent关联模型详解
5. 多态关联 (Polymorphic Relations)：一个模型可以与多种类型的其他模型关联，如一个评论可以属于文章或视频。多态关联分为多态一对一和多态多对多，分别使用 `morphOne`, `morphMany`, `morphTo`, `morphToMany` ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值