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 »

Facebook – solve the problem of getting the wrong image when sharing a web page in facebook

Posted by Shek on September 5, 2013 under Misc | Be the First to Comment

Social networking has became very popular and facebook is among the leader of them. Users use facebook to share web pages and very often the wrong image will show up in the facebook post.  Here is a solution for the web developers to solve this issue which is using facebook open graph meta tag.

Read more of this article »

Excel – using VLOOKUP to remove rows based on matching data from another column

Posted by Shek on December 10, 2012 under Misc | Be the First to Comment

In this post, I will demonstrate how to remove rows which are not matching the records in the other column of Excel with VLOOKUP. Although I am using Excel 2010 for the demonstration but this method should work with Excel 2003 as well.

Read more of this article »

Find and replace text for multiple files with notepad++

Posted by Shek on December 2, 2012 under Misc | Be the First to Comment

Being a web programmer, there are many times which I have to move files between the production and development environment and many setting parameters within the files has to be changed. Notepad++ has such a feature to find and replace text for multiple files

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 »

Variable variables – Get parameters of HTML elements which generated with a PHP for loop

Posted by Shek on November 30, 2011 under PHP | 3 Comments to Read

This post is the continuation of the post “Create a HTML form with PHP for loop and table”. It mainly focus on how to catch the HTML elements’ data generated from a PHP of a HTML form, it also talks about PHP Variable variables.

Read more of this article »

Page 1 of 1812345...10...Last »