This Web application is just getting underway. It will be used to handle the administration and data collection for my class enrollment and surveys which are generated by students who have completed on-line Web design training with me.
I have created a MySQL database that has 10 tables, I am using PHP as the server-side programming language and there is a bit of JavaScript being used client-side to validate form fields prior to the information being sent back to the server.
Currently, the Enter People Data screen is pretty good. It checks for duplicate email addresses and the first name and last names are automatically formatted with the first letter of each being capitalized, the other letters are lowercase. The email address is automatically formatted as lowercase. There is PHP code in there to strip out any html chacters from the data prior to it being entered into the database, which can help prevent the entry of any malicious scripts or html code into the database.
So far the tables that contain data are the People, Class, course, Question, and answer table.