N to N relation in items in same table

Question

I am working with Grocery CRUD (PHP library that creates a full functional CRUD) and I have very basic table of users.

id | first_name | last_name

Some of this users are relatives. So I want to have separate relation table that looks like

id | first_users_id | second_user_id | relation_type

How can I add this relation to Grocery CRUD so while I'll be editing user's profile I would select other users that are relatives providing relation type for each of them?

user_1998220 · Answer

Without much to go on you should be able to accomplish it like this: https://www.grocerycrud.com/examples/set_a_relation_n_n

You can also reference the docs here for using the function https://www.grocerycrud.com/documentation/options_functions/set_relation_n_n

$crud->set_table('user_table');
$crud->set_relation_n_n('relatives', 'user_user_table', 'user_table', 'id', 'id', 'id');

N to N relation in items in same table

1 Answers