Registration Form in PHP and MySQL
I was hired to build a custom PHP website from scratch for a member website. Membership is free but you have to register with a username and password.
Geographic statistical analysis will be done on the user data eventually, so country, state and city information is also requested at registration, but not required.
A database was designed to build a relationship between countries, states and cities. City data for all states in the USA was purchased and imported into the database. Ajax country, state, city drop down logic was coded to populate the dropdown list based on the higher region selection.
Google reCAPTCHA was added to prevent form spam.
Data submitted in the registration form was properly validated and then stored in a MySQL database.
Logic was then coded for a login form, logout form and forgot password script