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 »

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 »

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 »

Include PHP variable in a MySQL query

Posted by Shek on October 4, 2009 under MySQL, PHP | Be the First to Comment

Editor’s note: In cases, we have to include PHP variables within a MySQL query, here is how it is done:

Read more of this article »

Page 1 of 212