I am designing a Library website, and I have two table Libarian and Student table so when the Libarian login should have access to all the database(Adding new record, updating and all) but when the student login should only view the database without changing anything, so What I want to know is how do I read from those two tables and see who has logged in so that I can provide him/her with suitable information, I understand that I need to read from both tables everytime a person login then determine if the person is a student or a Librarian then give the person the access s/he deserves in the website
I dont think thats gona work coz this is gona be online website, so I will only have one login page for everyone coz there is gona be no way to determine who clicked the login button now between the librarian(who is responsible for the database and signing in and out the books) and the student who is gona browse thru the database checking if the books s/he needs are available and reserving them if they are not
Last edited by Traicey; Jun 2nd, 2009 at 11:00 am.
Where are you storing the log on details? Just hold all the logon information in on table e.g.
UID
Username
Password
AccessLevel
Create a different access level for librarians and students
and when the user logs in, depending on what their access level is you can allow/deny access to pages and so on.
No, The student can reserve a book which is on loan so to do that the student needs to login, otherwise they can browse for books without logging in, sometimes there are articles or journals which are exclusively for members of the library
if you know what I mean so what I need is a sample code to do that or maybe just a clue on where to start
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
