Disable autoformat in IntelliJ / PHPStorm

When using IntelliJ or PHPStorm as IDE, I use the autoformat for code (Code -> Reformat Code or Ctrl+Alt+L). It works great. But in some cases I need to disable autoformat for some parts of the code. This is how you can disable autoformat in your code: // @formatter:off echo ‘HERE COMES A LOT’ . ‘ […]

Get constant value by generated name

Today a colleague of mine ask me if it is possible to call a class constant inside of another class by generating the constant name on the fly. The reason was, that he had multiple constants in one class that had patterned / generic names like that: <?php class IAM_A_CLASS{ const IAM_A_CONSTANT_1 = 1; const […]

Save typing effort for complex MySQL queries with custom variables or procedures

To save time and because it’s not that smart to repeatedly retype the same things multiple times, you can user custom variables in MySQL like that: SET @store := 1, @name_id := 71, @short_desc_id := 72, @desc_id := 73; SELECT CPE.sku AS sku, CPEVN.value AS name, CPEVSD.value AS short_description, CPEVD.value AS description FROM catalog_product_entity AS […]

Get skin base path

For the URL we have: Mage::getSkinUrl() But what about the file system path to the current theme? Therefor you can use: Mage::getDesign()->getSkinBaseDir();