Hi, so I have a database with 2 Tables. 1 table is called Users and 2nd is called Perms.
Inside table 1, I have ID, Username, Email, Password etc etc.
Inside table 2, I have isStaff, isAdmin, isMod, etc etc.
Im trying to connect the user in table 1 to the permissions they have in table 2.
ID 1 of Users table Should connect to ID 1 of Perms table.
How do I do this in phpmyadmin?
After that is done, how would I check if the user has a permission.
My Idea is to place on the page a if statement that does something like check if the user viewing the page has permission and if true echo the page, and if not, redirect them to another page.