February 28, 2014

Nokia Lumia 620 pros and cons

Posted on February 28, 2014 by Suresh Kamrushi in General

When i thought of purchasing new mobile many friends suggested to have nokia lumia with windows 8.It has good facility with best price in market. Mobile performance is good. Interface, look and feel is better and Windows 8 new mobile is new in market. Some of the good features which i like most:

How to access remote mysql server using local phpmyadmin

Posted on February 28, 2014 by Suresh Kamrushi in Mysql, PHP

It is very tough to connect your remote mysql box especially when you are working with VPN. Initially I used telnet to connect to mysql box than I try to use workbench. Workbench is good and better than using telnet but again it consume more memory and if VPN got disconnected it just hanged. It so irritating. Than I try to integrate my PHPMyAdmin to configure to access remote mysql server and it is really very easy to setup.

Date manipulation with mysql..

Posted on February 10, 2014 by Suresh Kamrushi in PHP

There are various instance when we do date calculation on date / unix datetime fields.Following are some example as how to use inbuilt functions of mysql which will reduce doing calculation in PHP, I hope it will help someone: