How to catch url change in Component Router?

Question

PHP

The "routerOnActivate" event only fires for one child component. If to hang up on parent that happens nothing.

Answer 1

1) (More preferred) You can use the join command in the query. The link is given above, you can still search, there is a lot of information on this subject.
2) You can link tables forcibly, for example:
There is a set of 3 tables: users, roles (for example, various regalia), users_roles (the ratio of users and roles).
`users`
id_user|user_login|user_password
`roles`
id_role|role_name
`users_roles`
id_user_role|id_user|id_role The
request with which we will take all the roles of a specific user if his login and password match:
"select r.* from `users` u, `roles` r, `users_roles` ur where ((u.user_login='$login') and (u.user_password='$passrod')) and (ur.id_user= u.id_user) and (r.id_role=ur.id_role)"