Mysql Joins command Diagram

Wednesday, 21 August 2019 / Published in MySQL
The following Diagram show the difference between JOINs:

WordPress on multi-environment

Saturday, 02 February 2019 / Published in MySQL, Web developing, Wordpress
Running the same WordPress code with all credentials on multi-environment (like local, staging & live site) is not an easy job. The following code will make it easy. Its added multi config file to WordPress and can save different credential with no conflict. Get started First download the following code and then add it to

Migrate WordPress server from Local to Live

Sunday, 07 February 2016 / Published in General, MySQL, PHP, Web developing, Wordpress
Editing WordPress theme on localhost is very easy and fast, but it's getting tricky if you want to move your site's database from the local environment to live server.Here is 4 step you need to follow...

Remove illigal character in mysql string

Sunday, 13 December 2015 / Published in MySQL, PHP, Web developing
Escapes special characters in string which prepends backslashes to the following characters: \x00 \n \r \ ‘ “ \x1a [crayon-66e77586d0557448060168/]