Optimize All Mysql Tables in one Database with PHP mysqli (MySQL Improved Extension)

Posted by Shek on September 30, 2013 under MySQL, PHP | Be the First to Comment

In this post, I am going to talk about how to optimize all mysql tables in database in one go with php mysqli (MySQL Improved Extension)

Read more of this article »

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 »

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 »

Get MySQL database records as HTML form text field’s value

Posted by Shek on May 19, 2008 under PHP | Be the First to Comment

In my past post on explaining how to set the default values of the text field. Now to use the same concept, we could get the records from the MySQL database and place it into the text field as default text. Here I have created an example to show you how to do so. Read more of this article »