Array is a good way to store many elements, but in some operations you might like to store all of the elements in a array into different field of a table in a MySQL database. To store into different row, we can use a for loop to go through each elements and run a query to insert them 1 by 1 but insert into different fields is another story. Let me show you how in this example: Continue Reading →

To import Excel data into the MySQL database’s table is easy. All you have to do is to save the Excel file as “CSV” Format, and use phpmyadmin to complete the job for you. Here I have create an example to show you how to do so:
Continue Reading →

In some cases such as login system or other company’s stock count system which the records in the MySQL database might update very frequently. There might be a need to create another tables to store monthly of the data from another table in the MySQL database. It is a good idea to copy one table’s field records to another table’s field. 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 →