To create a HTML form with just a few text fields and other HTML form elements is easy, but sometimes in a stock control system or price input system for example, there might be a need for many text fields and other different HTML form elements repeatedly appear in the HTML form and they might be more than 100. 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. Continue Reading →

Sometimes you might like 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. involving a HTML form is a good idea for the user. Continue Reading →

In a login system, there are user names and passwords stored in the MySQL database. The passwords are normally stored as strings and are stored as they are 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 in the database, therefore only the password owner knows what the password is.

Continue Reading →

To delete a table from MySQL database sounds easy, all you have to do is to run a query and there you go. 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 sounds a good idea. And here I have created an example to show how to delete table from MySQL database with HTML form and PHP. Continue Reading →