Editor’s note: To create a HTML form with just a few text fields and a few HTML form elements is easy, but in a stock control system or price input system for example, there might be a need for many text fields and different HTML form elements repeatedly appear in the HTML form. To type in the codes of all of them will take too much time. Therefore a PHP for loop and a table is good for this task.

Editor’s note: In some cases which the user might need to empty a table in the MySQL database. Instead of deleting every record in the MySQL database, you could run a query “truncate table ‘tablename’” to do the job.

Sometimes, you might like to have the HTML looks neat and tidy. A table to hold all of the HTML elements in it would do the job. Here I have created an example to show you a good way to do it.

Editor’s note: In a login system, there are user names and passwords stored in the MySQL database. The passwords are normally stored as strings inside the database. To have a more security way to store the passwords in the database, it is better to store an encrypted version of the password, therefore only the password creator knows what the password is.

MD5 is the encryption technology I like to use because it is very easy to implement and it encrypts a string into a 32-character strings, for reference what MD5 really is, please check Wikipedia-MD5.

Editor’s note: To delete a table from the MySQL database is easy, all you have to do is to run a query to get it done. But in a content management system, you might like to build an user interface for the user to delete a table. Again a HTML form is a good idea for this. Here I have created an example to show how to delete table from MySQL database with HTML form and PHP.

Editor’s note: In some cases such as a company’s login system for example, the login names and passwords are stored in the MySQL database. But if a staff leaves the company and so his account has to be removed from the database. Therefore it is good to design a HTML form for the administrator to remove the record from the database. And here is the example.