I've these tables users
,tasks
,roles
,permissions
& a pivot table permissions_roles
.
roles:
role_id
: auto_increamentrole_name
: admin/standard
permissions:
permission_id
: auto_increamentpermission_name
: create/edit/delete
Pivot table: permissions_roles
p_id(FOREIGN KEY (r_id) REFERENCES roles(role_id))
r_id(FOREIGN KEY (p_id) REFERENCES permissions(permission_id))
But when I'm trying to insert values into the pivot table, by writing this code:
function roles($role_name){
mysqli_query($this->connect,"INSERT INTO roles ( role_name ) VALUES ('$role_name')");
SET @r_id = LAST_INSERT_ID();
}
Then I'm getting this error:
Parse error:
syntax error, unexpected '@' in /home/directory/project_folder/users.php
I need to assign multiple permissions for each roles. Please help.