I would like to be able to redirect a user to a different page based on their login name. At the moment, the code below redirects all users to the same page (role.php) no matter what their login is. I have two users: student and tutor. Both of these users are redirected to role.php.
However, I would like to redirect student user to role.php and tutor user to record.php. I thought about doing a couple of if statements if member_id is 1, then redirect to role.php and if member_id is 2, then redirect to record.php. But was unable to do so.

Table structure for members table from where login credentials are checked is as follows: