• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 13. Restricting User Access > Login SQL and Passwords

Login SQL and Passwords

The SQL that you need for a user authentication system is trivial. You can keep your basic user information in one table and store additional information in a separate table, relating the two based on a common user ID. If you follow this structure, you only have to build the user authentication once, and you can use it anywhere you'd like without changes.

What information will you need in your user authentication table? Just a few pieces of information:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint