The problem of laravel correlation Model - Codes Helper - Programming Question Answer

The problem of laravel correlation Model

I just started to learn the association model of laravel, and I was so confused that sometimes I really felt that it was not as convenient as writing sql directly.

now there is a problem
role tables admin_roles and admin_permissions tables have a many-to-many relationship.

the intermediate table admin_role_permissions has only two fields
role_id and permission_id. Corresponds to the id of the admin_roles and admin_permissions tables, respectively.

now I want to check the id value of admin_permissions table when id is 1 and 2 in admin_roles table. You can write

in sql.

SELECT
    DISTINCT`admin_role_permissions`.permission_id
FROM
    `admin_permissions`
INNER JOIN `admin_role_permissions` ON `admin_permissions`.`id` = `admin_role_permissions`.`permission_id`
WHERE
    `admin_role_permissions`.`role_id` IN (1, 2)

data obtained

laravel ,
AdminRoleController.php

AdminRole.php

the data is so complex, there are too many levels, and it hasn"t been deduplicated yet. How can we get the data results executed by the top sql? I don"t want to write the native sql
how to find the Permissions=. The value in this form is
how to rewrite it with the model, or how to get it with the collection.

Model laravel

Mar.24,2022

first of all, make sure that model associations are mainly used for business logic.
secondly, it is not necessary to force the use of the association model, let alone the background management.
in addition, you do not provide table structure table data, and no one else can do further testing, which is one of the reasons why your question has not been answered, and the description of the question is not clear enough.
finally, I canceled the stamping on this issue, and I also hope that more people will discuss it. As for why I stepped on it, I have already mentioned it in the comments.

gives you one more choice. Permission control can be done with PHP-Casbin
support Laravel extensions Laravel-Authz : https://github.com/php-casbin.
supports rbac, uri permissions, restful, middleware, cache, etc.

Previous: Https station websocket uses wss to report an error?

Next: The shader parameters in unity are the same. Why are the colors different?

Cannot get its own value in the laravel database association?
public function roles() { return $this->hasOne( App Models Role )->where( type ,$this->type); } $this- > type can t get any value? Why is that? The value of $this- > attributes is also an empty array. Why? ...

Eloquent laravel-model laravel

Mar.23,2021
On the problem of Laravel parsing path
ask a question about Laravel parsing, or Nginx parsing path. first of all, let s talk about the source of the problem. Since we are recently working on a laravel-based directory indexing program, one of the requirements is to show the file at the end o...

Php-laravel laravel-model laravel

Sep.22,2021
Problems associated with laravel model
user table and role table have many-to-many relationship, and the middle table is user_roles. many-to-many relationships are defined in the user model class public function relRole(){ return $this->belongsToMany( App Model Role , ...

Model laravel php

Apr.01,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b32e43-2b5c9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b32e43-2b5c9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?