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 ...

Get PHP Advanced for the World Wide Web: Visual QuickPro Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.