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 »

Change mysql date type into another date format with mysql’s date_format function

Posted by Shek on April 12, 2011 under MySQL | Be the First to Comment

MySQL’s date field type default is in yyyy-mm-dd format, and it is not practical in some cases when we want to use another formating representation such as dd/mm/yyyy. Of course we could use PHP to convert it but the best way I find is to convert it through SQL before any php operation, here is an example which I which like to show you:
Read more of this article »

Adminer – an alternative mysql database management tool to phpMyAdmin

Posted by Shek on March 17, 2011 under Misc, MySQL | Be the First to Comment

If you are a PHP programmer, phpMyAdmin should be a familiar tool for you. But to deploy phpMyAdmin takes a lot of steps and setting. Therefore I recommend Adminer as an alternative to phpMyAdmin.
Read more of this article »

Use PHP to change MySQL field size

Posted by Shek on June 15, 2009 under PHP | Be the First to Comment

In this example, I am going to show you how to use PHP to change a MySQL database’s field size.

Read more of this article »

Change the MySQL database table encoding to UTF8 with PHP

Posted by Shek on June 10, 2009 under PHP | Be the First to Comment

Editor’s note: In some cases, when you have forgotten to preset the MySQL database table encoding to UTF8 after the creation of the database but later you need to insert some UTF8 text such as Chinese or other Asian languages, here is how you could do with PHP to change the encoding of the MySQL database table.

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 »

Page 1 of 512345