MySQL Character Set and Collation
MySQL documentation states the following with respect to the "character set" and "collation" of the data storage in the database.
jQuery anonymous and callback function declarations
JavaScript enables you to create anonymous functions to be executed immediately or when the document is ready, and also allows you to freely pass functions around to be executed at a later time. The default short-hand notation for jQuery wrapper is $, and unless your webpage has a conflict with other javascript libraries you may freely use $ to wrap any jQuery scripts. Since there are many variations of anonymous function calls, they are worth mentioning here.
How to change primary key values in MySQL?
To change values of existing integer field (`table` is the table name, and "id" is the column name), you may use the following update SQL command:
How to change MySQL user and root password?
We have been using the DirectAdmin control panel for a number of years, and each time we set up a server it is necessary to change the root password. By default, Direct Admin creates a MySql superuser called "da_admin" with a preassigned password, but we do not know what the root password is. Since we use both DirectAdmin and command-line to manage our server, it is essential that we have a proper MySQL root password assigned.
Android ROM explained
There has been a lot of talk about Android ROM and how to flash it with a custom ROM to bring new features to your smartphone. People are also talking about rooting an Android OS and installing aftermarket firmware on it. In the world of Android, the word ROM which stands for Read-Only Memory is being misused. A better term would be "firmware" where the binary image of Android OS is installed. Let's start out by defining a few terms used in the Android world.
How to exclude certain folders from Eclipse Search.
One of the time-saving settings you can add to your Eclipse preferences is to limit your file searches to your source code and exclude 3rd-party folders. Such folders may include .git, .svn, cache, or templates_c folder from Smarty. There are a few different ways to accomplish this.
How to configure Eclipse to use spaces instead of tabs?
When writing maintainable code, indentation plays an important role. This may be one reason Python requires proper indentation as the programming syntax. A traditional tab indents 8 spaces, and we all know 8 spaces are just too much for coding indentation. We all opt to use 4 spaces for programming indentation, but how do you accomplish this? We can configure a TAB to indent only 4 whitespaces, or use 4 physical spaces? There are tradeoffs, and it's a matter of personal taste. I used to prefer TABS over SPACES, but if you're working in a team the lines may not line up correctly if developers mix and match TABS and SPACES. So, to make the indentation consistent, a coding guideline must be placed among multiple developers.
ZF2: Configure a layout for each module with EdpModuleLayouts
I am newly acquainted with ZF2 and played with EdpModuleLayouts to configure different layouts for each module. For someone with very limited exposure to ZF2, the instruction provided in EdpModuleLayouts is not quite enough. I've spent about an hour making this simple thing work and sharing my experience with others who may run into similar challenges.
ZF2: ZF1 like URL Routing
ZF2 introduces a new routing for the framework which is similar to ZF1 but has slightly different semantics. The skeleton application ships with a default Application level router which takes a matching controller/action to /application/controller/action URI. If you wish to keep it backward compatible with the ZF1 type of matching, you may want to make the following changes to the module/Application/config/module.config.php file as below:
Zend Framework 1 Overview
Developing a PHP application requires domain knowledge, software engineering, discipline, and time. We rarely write applications from scratch as there are freely available application frameworks that we can take advantage of. For the PHP programming language, there are more than a dozen "popular" frameworks to choose from, and picking the right framework for your application is not a mundane task. I have been working as an IT consultant for many years, and Zend Framework is the one being discussed frequently. As a new PHP developer coming on board with a Zend Framework, I would like to use this forum to describe the learning process.