Accessing data from another table


#1

Hello everyone, i’m doing an Information system for fun and im still new with the framework. I want to access a data from another table in the database. Im doing this for privilege reasons.

In the photo is my ERD, i want to access the position_id from the position table in my users table.

echo $this->Auth->User(‘position_id’) doesnt work apparently.

PS: Disregard the naming conventions, i promise that the naming conventions in my database is correct. :slight_smile:


#2

Check cakephp ORM Cakephp3 ORM . You can get some idea to do that.