WordPress – Auto create Post into the MySQL database from Excel data file

Posted by Shek on October 5, 2011 under WordPress | Read the First Comment

In the post, I would like to show you how to create post for wordpress without having to use the wordpress admin console. This will be done by creating the posts into the wordpress MySQL database

Read more of this article »

Insert all array elements into MySQL database table’s different fields

Posted by Shek on December 28, 2008 under PHP | Read the First Comment

Array is a good way to store many elements, in some operations you might like to store all of the array elements into different row 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. This example, I go show you to insert into different fields.
Read more of this article »

Import Excel, CSV file data into MySQL database table

Posted by Shek on August 20, 2008 under MySQL | 4 Comments to Read

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:

Read more of this article »

Copy one table’s field records into another table’s field in MySQL database with PHP

Posted by Shek on May 22, 2008 under PHP | Read the First Comment

Editor’s note:┬áIn some cases such as a login system or other company’s stock count system which the records in the MySQL database might need to update very frequently. There might be a need to create another tables to backup monthly of the data to another table in the MySQL database. It is a good idea to copy one table’s field records to another table’s field.
Read more of this article »

MD5 – insert an encrypted string or password to the MySQL database with HTML form and PHP

Posted by Shek on May 16, 2008 under PHP | 2 Comments to Read

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.

Read more of this article »

Insert values into MySQL database with HTML form and PHP

Posted by Shek on May 12, 2008 under PHP | 2 Comments to Read

Editor’s note: In my past projects, especially those for company use, many of them involved with a login system and have the user name and password stored in a MySQL database. Sometime for administrators, there is a need for them to add more users when there is a new stuff for example, and therefore it is good to design an interface for them to insert the values into the MySQL database.

Read more of this article »