Database Design
To begin developing the application, you must first design and create the necessary databases. This application is going to do a lot of things, but primarily it will register users and allow them to log in. For this end, you'll need a database that stores the users' registration information.
For the sake of convenience, and because I know it works well, I'll incorporate the register.php script developed in Chapter 4, Security, as the registration page. The required information was and will be: a username, first name, last name, password, email address, and birthday. You can run through the normalization techniques as established in Chapter 3, Databases, and what you'll get is a table like Table 5.1. On top of the elements listed ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access