Automated Database Backup Procedure

Published: November 5, 2013

An old coworker and good friend of mine once told me that there are two types of people, those who make backups and those who haven’t lost data yet. I currently provide reseller hosting using HostGator and several of the sites I host have MySQL databases. Here’s the simple automated procedure that I used to do monthly backups of these databases. Read more…

Mac OS X Apache MySQL PHP PhpMyAdmin Set Up

Published: April 2, 2013

I recently started a new job and was given the opportunity to choose my work computer. The rest of the development team was using Mac and as of this writing we’ll be using OS X 10.8 Mountain Lion. The problem for me is that I’ve always used Windows. However, I’ve heard great things about Apple, plus I have an iPhone, so I thought… why not? The rest of this post details how I set up my new MacBook Pro for my development stack including Apache, MySQL, PHP, phpMyAdmin, etc. Read more…

MySQL Field Types And Sizes

Published: January 1, 2013

MySQL supports a number of column types, which may be grouped into three categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the types available. Please refer to the MySQL manual for more details. Read more…

Warning: Expression Result Is Never Used

Published: January 17, 2012

I was recently quality control checking some code and decided to run the code analyzer in my IDE, Zend Studio, as an ancillary step in my review process.  I received a couple of warnings which stated “Expression result is never used”.  Despite the warning the PHP code worked just fine.  After further investigation I discovered why the analyzer was throwing the warning message. Read more…

Warning: Assignment In Condition

Published: January 3, 2012

I was recently writing some simple procedural scripts without using my favorite framework, Zend Framework, and was using the code analyzer in my IDE, Zend Studio, when I got an “Assignment in condition” warning.  Some of the code I had copied directly from php.net.  When I looked further into the warning I discovered the problem. Read more…

Next Page »

Home · About · Domains · Hosting · Development · Portfolio · Blog · Contact · Legal Disclaimer · Privacy Policy

Copyright © 2014 · Lively Web Design