Magento: Direct SQL Queries

To start with, Magento uses data models which provide a great way to access and modify data. Varien uses aptly named methods and clever abstraction to hides away the complex SQL, which is needed when performing data operations. While this makes learning models easier, it often impacts the operation speed and therefore, the responsiveness of…

Magento: Display Products on Home Page with Pagination

If you want to display products on home page of your Magento Store with pagination then follow these simple steps to add such functionality in your Magento Store: Go to CMS > Manage Pages and click on the ‘Home page’. Under the ‘Design’ tab, insert the following code in the ‘Update Layout XML’ field: 3…

Magento : Get Base Url , Skin Url , Media Url , Js Url , Store Url and Current Url

Get Url in phtml files 1. Get Base Url : Mage::getBaseUrl(); 2. Get Skin Url : Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN); (a) Unsecure Skin Url : $this->getSkinUrl(‘images/imagename.jpg’); (b) Secure Skin Url : $this->getSkinUrl(‘images/imagename.gif’, array(‘_secure’=>true)); 3. Get Media Url : Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA); 4. Get Js Url : Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS); 5. Get Store Url : Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB); 6. Get Current Url Mage::helper(‘core/url’)->getCurrentUrl(); Get Url…