Development, Programming & DevOps

All about software development, including development operations, methodologies, programming, continuous integration etc.

MySQL / MariaDB & MongoDB

Everything about MySQL / MariaDB and MongoDB

How to do Everything in MySQL/MariaDB

Useful Tricks Convert a Column to Uppercase UPDATE table_name SET column_name = UPPER( column_n...

Setup for Remote Access

Grant Privileges GRANT ALL ON <database>.* TO <user>@'%' IDENTIFIED BY '<pa...

Basic MongoDB Operations

Queries and Indexes Display query stats db.<collection>.find({<query conditions>})....

PHP, Javascript & HTML

All about PHP, JS and HTML including its frameworks

Useful PHP Codes

Increment a Date by Month, Day or Year Increment by month $time = strtotime("2014-12-11")...

Standard PHP/JS/HTML Procedures

Updating PHPUnit to Version 3.7 sudo mv /opt/lampp/lib/php/PHPUnit /opt/lampp/lib/php/PHPUnit.ba...

How to do Everything in CakePHP 2.x

Writing Test Case for AuthComponent's login() Function with CakePHP's Mocking $this->controll...

How to do Everything in AngularJS

Prevent Route Change Add target="_self" to all elements Create new directive to prevent the de...

How to do Everything in Javascript (Pure JS)

Mobile user-agent detection var isMobile = { Android: function() { return navigator.userAgen...

How to do Everything in Metro UI CSS

Metro UI CSS with isLoading jQuery plugin IsLoading jQuery plugin: /* jQuery Plugin */$.isLoadi...

ReactJS REDUX Summary

Using stores and reducers A simple example import {createStore} from 'redux'var reducer_1 = (st...

Standard ReactJS Procedures

Initialize ReactJS Project Enter npm init Enter npm install --save-dev babel-core babel-loader...

Git and SVN

All about Git and SVN

Patching with Git

Creating a Patch Patch for Working Copy (Not Committed) git diff > patch.diff Patch from on...

Solving Cryptic SVN Errors

SVN File already exists error svn update path/ --accept=mine-full

CSS

Everything about CSS

CSS Utilities

Media Queries min-width and max-width @media only screen and (min-width: 330px) {...}: If [dev...

Everything About APIs

Solutions and tricks for all types of APIs including Facebook and Google

Facebook APIs

Generating Graph Access Token that Never Expire Make sure you are the admin of the FB page you ...

Common Parse API Operations

Get schema curl -X GET \ -H "X-Parse-Application-Id: ${APPLICATION_ID}" \ -H "X-Parse-Master-K...

CMS/E-Commerce

All content management system and E-Commerce platform related stuff such as Joomla!, Drupal and W...

How to do Everything in Joomla!

Changing Read More Text In your Joomla admin go to Extensions > Language Manager > Overri...

Magento Development

Magento Controllers Code Pools Magento code pools are stored in app/code/ directory, it consist...

Clearing Magento 2.x Orders

Script SET FOREIGN_KEY_CHECKS=0; # Clean order history TRUNCATE TABLE `sales_bestsellers_agg...

Refreshing Magento 2.x Static Contents

Remove static and var contents rm -rf pub/static/* var/cache/* var/composer_home/* var/generati...