Blog : 66

How to change primary key values in MySQL?

Apr 16, 2015 By Webtraffic Exchange Databases 0 Last Modified on 2024-01-16

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?

Apr 12, 2015 By Webtraffic Exchange Databases 0 Last Modified on 2024-01-16

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.

Getting started with composer (composer.phar)

Mar 26, 2015 By Webtraffic Exchange Programming 0 Last Modified on 2024-01-16

I am kicking off a new PHP project with the Zend Framework 2 (ZF2) and chose to use Doctrine as the persistence layer with ORM capabilities. Knowing that I need two Zend modules for Doctrine support, I've cloned the two modules (DoctrineModule and DoctrineORMModule) from GitHub to enable doctrine support in my ZF2 project. Oops, just installing those two Zend modules from GitHub do not make doctrine work! What am I doing wrong? Do I need a core Doctrine library from doctrine-project.org installed in addition to those two modules in order to make this work in ZF2? After a careful review of documentation, the preferred installation method was using "composer" not "git clone".

How to exclude certain folders from Eclipse Search.

Mar 16, 2015 By Webtraffic Exchange Development 0 Last Modified on 2024-01-16

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 install Zend Framework 2 skeleton application?

Mar 16, 2015 By Webtraffic Exchange Framework 0 Last Modified on 2024-01-16

For anyone getting started with Zend Framework 2 (or ZF2), the best way to get up and running quickly is by installing the Zend Skeleton Application available on GitHub. Here is the quick and easy way to get the skeleton application installed on a Linux machine. You'll install the skeleton application first, and then we'll install ZF2.

ZF2: Configure a layout for each module with EdpModuleLayouts

Mar 06, 2015 By Webtraffic Exchange Framework 0 Last Modified on 2024-01-16

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.

CSS Specificity - Which CSS Rule to apply?

Feb 16, 2015 By Webtraffic Exchange Development 0 Last Modified on 2024-01-16

Each CSS selector has a specificity value and the more specific the selector is the higher precedence it has. If multiple selectors apply to a single element, the highest specificity CSS rule applies to the element. Have you had an experience where you define a CSS rule for an element, and it doesn't work? You probably have a CSS rule that has a higher specificity value which causes your newly created CSS rule to not apply.

ZF2: ZF1 like URL Routing

Feb 16, 2015 By Webtraffic Exchange Framework 0 Last Modified on 2024-01-16

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:

Netsuite invoke Saved Search in PHP - Example

Feb 16, 2015 By Webtraffic Exchange Programming , CMS, CRM and ERP Systems 0 Last Modified on 2024-01-16

I've created a fair amount of PHP code to create custom searches on the Netsuite Platform. With the introduction of 2012.2 endpoints late last year, my examples have to be rewritten using the 2012.2 PHP Tool Kit API.

Android ROM explained

Jan 29, 2015 By Webtraffic Exchange Development 0 Last Modified on 2024-01-16

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.