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 »

Optimize Mysql Table with PHP script

Posted by Shek on November 19, 2012 under MySQL, PHP | Be the First to Comment

In this post, I am going to show how to optimize Mysql Table with PHP script. This could become handy when a Mysql table often has overhead and needs to be optimized.

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 »

SQL – join 2 mysql tables and get data result from them

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

In this post, I am going to talk about how to get data from 2 mysql tables instead of 1 table with a sql.

Here are 2 mysql tables (The field types are ignored in this examples): Read more of this article »

Create multiple HTML tables with PHP for loop

Posted by Shek on June 22, 2010 under PHP | Be the First to Comment

Editor’s note: To create one HTML table is easy, but to create multiple HTML tables, We have to copy and paste the code many times. However we could do the job with a PHP for loop.
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 »

Page 1 of 3123