use views for login and enable register end-point

[mevdschee]

Is it possible to use views for login and also enable register end-point? I've successfully used views to login active users but the register endpoint is now throwing error.

<b>Fatal error</b>: Uncaught PDOException: SQLSTATE[HY000]: General error: 1471 The target table active_users of the INSERT is not insertable-into in ...

My view contains a join between the users table and roles table

select id, username, password,is_active, role_id 
from users left join roles on roles.id = users.role_id 
where is_active = 1
and role_id <> 0

Originally posted by @dswdcares in https://github.com/mevdschee/php-crud-api/issues/892#issuecomment-1240183237

[mevdschee]

@dswdcares If your view is insertable-into you can. If not, then you can't. In your case your view is not insertable-into.

[mevdschee]

closing due to inactivity