advanced login

cash_php

Dear all, i met a problem with a login script.
In my login script,
i have 4 different parties can enter my database. each of them have different priority in the database such as edit, delete or view only.
In order to login, the login script should check their ID and Password based on the 4 different tables.
1. Admin1's password is start with S..........
2. Admin2's password is start with H..........
3. Admin3's password is start with L..........
4. admin4's password is start with E..........

i try to search some login script from the Internet. Unfortunately, most of the login script just check the id n password inside 1 table only.

therefore, i can't solve this problem. i hope can get some opinion from all of you. i very appreciate if u willing to help me!
thank you.

singboy

seem to be quite complete, let me figure out for you.

Mordecai

Just put a conditional statement in a login script you have. You just need to check what the first letter is. You can also use a switch, which is what I'd recommend:

switch(substr($string,0,1)) {
  case "S":
    $database = "admin1";
  break;
  case "H":
    $database = "admin2";
  break;
  ...
}

Then do your database query. To know what database, you'll just need to put in $database. You can also put a default in the switch, which means none of the cases were matched.

Weedpacket

Generally speaking, one would use a single login table; access priorities would be stored as additional fields in the user/login table. Why do you use several tables?

Xoid

I would personally store all usernames / passwords / access rights in the same table, alot faster for the database to access.

you could always research Mcrypt so you can encrypt your details within the database.

cash_php

to:Xoid,Weedpacket,Mordecai
after received reply from u all, i now more understand how really my login/logout scripts to work.thank you for all and i really appreciate ur help.

batman

I would use weedpackets idea and use only one table then go from there. Much much easier. Just give each person that signs up a default level of 0 (being the lowest), then you can go and update their records to what you want. Then just check to see what their level is, then redirect them to different pages accordingly. 🙂 This will give you the full control over everybody in your db, even the other admins (if there are any).

Anyways...that's how I would do it myself. 😃

cash_php

i already solve the login problem.thanks everybody.
Can the password distinguish capital letter and lower letter? this is bcoz if my password is H100, no matter i type H100 or h100,it also can login.do any script can differentiate?
thanks again.

singboy

great!