Using Index Management in Terminal

Reindex Data using linux terminal

Reindex data through admin as

Admin -> System -> Index Management

Navigate to root folder

Using terminal as

cd [magento_root_folder]/shell

Press Enter

[magento_root_folder] - defines magento installed root folder.

List all the files in the folder

cd ls

Press Enter

View status of the all indexes

php indexer.php --status

Press Enter

You find the status of all the avaiable indexes

Reindex the catalog_product_price

php indexer.php --reindex catalog_product_price

Press Enter 

List of terminal execution indexes

By default

Name of indexes        Exceuting code path in terminal

Product Attributes     catalog_product_attribute Product Prices         catalog_product_price
Catalog Url Rewrites   catalog_url
Product Flat Data      catalog_product_flat
Category Flat Data     catalog_category_flat Category Products      catalog_category_product
Catalog Search Index   catalogsearch_fulltext
Stock status           cataloginventory_stock
Tag Summary            tag_summary 

To Indexing all the availabe indexes

php indexer.php --reindexall

Apache service Start, Stop and Restart

To start Apache server

sudo service apache2 start

           ( or )

sudo /etc/init.d/apache2 start

 To stop Apache server

sudo service apache2 stop

           (or)

sudo /etc/init.d/apache2 stop

 To restart Apache server

sudo service apache2 restart

           (or)

sudo /etc/init.d/apache2 restart

MySQL service Start, Stop and Restart

MySQL service

To start MySQL server

sudo service mysql start

           ( or )

sudo /etc/init.d/mysql start

 To stop MySQL server

sudo service mysql stop

           (or)

sudo /etc/init.d/mysql stop

 To restart MySQL server

sudo service mysql restart

           (or)

sudo /etc/init.d/mysql restart

Find the Array key in Nested Array

In nested array find the array key for matched value

function recursive_array_search($needle, $haystack) {
    foreach($haystack as $key=>$value) {
        $current_key = $key;
        if($needle === $value
  || (is_array($value) && recursive_array_search($needle,$value) !== false)) {
            return $current_key;
        }
    }
    return false;
}

Find the key of the matched element in nested array.

$needle

- String which has to find.

$haystack

- Array elements $needle has to search in this array.

PHP MySQL Connection

MySQLI Connection - I for Improved

Connect the database from php throug MySQLI

 
/*hostname - localhost, user - user, password - null, database - test*/

$db = new mysqli('localhost', 'user', '', 'test');

if($db->connect_errno > 0){
    die('Error in connecting database (' . $db->connect_error . ')');
}

Now doing the simple query to get records from employee table

 
/* Do Query */

$sql = "SELECT * FROM `employee`;

if(!$result = $db->query($sql)){
    die('Query error ' . $db->error);
}

Display the output by fethcing the table records

 
/* Fetching records */

while($row = $result->fetch_assoc()){
    echo $row['username'];
}

Magento Display Categories and Subcategories

Display categories and subcategories in Magento page

    /*Display current store categories*/

    $_helper = Mage::helper('catalog/category');
    $_categories = $_helper->getStoreCategories();

    /*Parent categories*/

    foreach($_categories as $_category) {

      if(!$_category->getIsActive()){
        continue;
      }

      echo $_category->getName();
      echo render_child($_category->getId());
    }
    
    /*Render child categories*/

    function render_child($cid) {
 
     $html = '';
     $_subCategory = Mage::getModel('catalog/category')->load($cid);

     $_subCategories = $_subCategory->getChildrenCategories();

     if (count($_subCategories) > 0){

       $html .= '<ul>';

       foreach($_subCategories as $_subCat){

         if(!$_subCat->getIsActive()){
           continue;
         }
    
         $html .= '<li>';
 
         /*Display first level sub categories*/

         $catUrl = Mage::helper('catalog/category')
                            ->getCategoryUrl($_subCat);

         $html .= "<a href='".$catUrl."'>".$_subCat->getName()."</a>";
  
         /*Display first level sub categories*/

         /*If needed display next level sub categories*/

         $html .= render_child($_subCat->getId()); 
  
         /*If needed display next level sub categories*/

         $html .= '</li>';
      }
   
      $html .= '</ul>';
     }  
     return $html;
  }

Displaying the category and subcategories from the current store. After getting the store categories, check the category is active and output the parent category name.

With the help of

 render_child 

function, check the active subcategories then display first level child elements in list format.

Would like to display all subcategories then call

 render_child 

function, with argument as current category id.
    

Magento List Categories and Subcategories which has Include in Navigation Menu as yes

List all categories and subcategories which has Include in Navigation Menu as yes

$collection = Mage::getResourceModel('catalog/category_collection')
    //only active categories
    ->addAttributeToFilter('is_active', 1) 
    //categories included in menu
    ->addAttributeToFilter('include_in_menu', 1) 
    ->addAttributeToSelect('*');

foreach ($collection as $category) {
    //do something with $category

     echo $category->getSku();
}

Magento Debugging Log Files

Create log file

In developing magento module its necessary to know how to log the file.
If you want to log the variables in object, array and strings.

Refer the code below to log the variable.

Mage::log($myVariable, NULL, '[nameOfFile].log');

This log file will create in magento log folder i.e [magento_root_path]/var/log

Magento Template Hints

 

Magento Template and Block Hints

In Magento Admin, look into developer option in left side bottom under System -> Configuration.

Choose the website or store you would like to see the template hints by

Enabling the template hint path and block path

This give the Block class name and corresponding template file which it displays output.

Get a Configurable Products Associated or Related Simple Product

Output the configurable related products.

/* Get all products */

$collection  = Mage::getModel ('catalog/product')
                 ->getCollection(); 

foreach($collection as $product) {
   
   /* If product is not configurable move to next item in loop */

   if($product->getTypeId() != "configurable"):
 continue;
   endif;

   /* Assign configurable related products in collection  */

   $conf = Mage::getModel('catalog/product_type_configurable')
        ->setProduct($product);


   $simpleCollection = $conf->getUsedProductCollection()
    ->addAttributeToSelect('*')    
    ->addFilterByRequiredOptions();

   /* Get all configurable related product ids */

   $simpleIds = $simpleCollection->getAllIds();

   /* Loop all related products and output the product name */

   foreach($simpleCollection as $simpleProduct){
      echo $simpleProduct->getName(). "<br/>";
   }
}