PHP登录-使用SQL语句检测用户类型

Basically what Im trying to do is create a login system where there are two different types of user. Each user has an ID, username, passcode and role. The role determines whether they are a lecturer or student(which overall will determine the view that is given). I have the login working generically where a user can login and reach a page called welcome.php. When a lecturer logs in I need an include file /lecturer.php to open and when a student logs in a file named /student.php to open. Below is my code:Basically what Im trying to do is create a logi