1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    If I have around 5000 registered users, when a user wants to log in, what is the best way to handle authorization -1. take username and password input and compare in the user table in mysql or 2. use the good old way .htaccess?
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I don't know if there is a best way

    I PREFER to create users and groups to access certain areas of a site with .htaccess. Then I let php scripting include the login for the mySQL databases. This limits the users in the databse. I have not had a security problem doing it this way (yet).
  4. #3
  5. No Profile Picture
    rod k
    Devshed Newbie (0 - 499 posts)
    The only thing to be aware of when using .htaccess for name/password protection:

    Apache is NOT very efficient at searching for the name/pw combination. With very large groups you'd probably be better using a form based login and a RDB like MySQL for access verification.

    At 5000 users you're probably ok with .htaccess but much more than that...

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  3. Replies: 4
    Last Post: May 27th, 2003, 11:06 AM
  4. Help with Mysql Insert required
    By blissdev in forum PHP Development
    Replies: 10
    Last Post: June 3rd, 2002, 03:41 PM

IMN logo majestic logo threadwatch logo seochat tools logo