Today I need to generate ERD for my Database. If you search on net you will get number of people suggest Workbench for it but as i am using PHPMyAdmin as an GUI for my Mysql database I just don’t want to install workbench only for generating ERD. And above all when PHPMyAdmin support it ...Read more..
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:Read more..
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 ...Read more..
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:Read more..
The maximum row size constrains the number of columns because the total width of all columns cannot exceed this size. For example, utf8 characters require up to three bytes per character, so for a CHAR(255) CHARACTER SET utf8 column,Read more..
Mysql introduce Event scheduler which we can use alternative to Cronjob. There are many advantages over cronjob like: 1) It is directly written on Mysql Server. 2) This is platform independent. Your application might be written in any language it does not matters. You just need to know mysql.Read more..
PHP has numbers of datetime related functions which we can use to get Business day between two dates. Even if we have list of holidays we can also consider that for calculating. Here is a simple example how you will get Business day in a particular period:Read more..
Now a days i am conducting PHP / Mysql interview for my organisation. And came across many of resumes with 3-4 years of experience in web development. But couple of developer given me the correct answer to this question. That is what i think i should share this.Read more..
Earlier, say 1.5 years back I have created a project in cakephp and my experience is good with CakePHP.Now when i try to create another project with cakePHP version 1.2 i am unable to do that. I unable to generate files from console it is giving me error regarding PHP that some of the functions ...Read more..
Only three steps are require to remove index.php from url in Codeigniter in WAMP environment. 1) Create .htacess file in parallel to application holder and just copy past the following code:Read more..