Is there any way to get the database to check which password was used and where to redirect the user giving them access to their pages only? Since the users will have their own pages can there be something on their page to redirect them if the password they've entered is correct?
I hope i've explained this thoroughly, your help would be much appreciated.
You can do this using PHP. I suggest you look into a few tutorials on creating a database driven authentication system.
Using this method then you would have 1 URL example.com/user.php however they would be served their own profile page based on their login name/session data i.e. the user page would do a lookup in the data base like: SELECT * FROM profiles WHERE username=$currently_loggedin_user;