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 »

PHP and oracle database 10g Enterprise Edition Part 2

Posted by Shek on May 1, 2011 under Oracle, PHP | Be the First to Comment

In this post, I will continue my recording on PHP and oracle database 10g Enterprise Edition

Read more of this article »

PHP and oracle database 10g Enterprise Edition Part 1

Posted by Shek on under Oracle, PHP | Be the First to Comment

In this post, I recorded the operations which I have used in my past web project which involving PHP and the oracle database 10g Enterprise Edition.

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 »

Page 1 of 512345