Tag Archives: Magento

Magento

Site URL Magento

IN PHTML PAGE
==============

SECURE SKIN URL -<?php echo $this->getSkinUrl(‘images/ sampleimage.gif’, array(‘_secure’=>true)) ?>
CRRENT URL – Mage::helper(‘core/url’)->getCurrentUrl();
HOME URL – Mage::helper(‘core/url’)->getHomeUrl();
MEDIA URL – Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
SKIN URL – Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);
STORE URL – Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);
JS URL – Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);
NON SECURE SKIN URL – <?php echo $this->getSkinUrl(‘images/sampleimage.jpg’) ?>

IN STATIC BLOCK
================
BASE URL -{{base url=’yourstore/mypage.html’}}
MEDIA URL – {{media url=’/sampleimage.jpg’}}
SKIN URL – {{skin url=’images/sampleimage.jpg ‘}}
STORE URL – {{store url=’mypage.html’}}

 

Magento

How to write a Custom SQL Query Magento

To select the data

$read = Mage::getSingleton(‘core/resource’)->getConnection(‘core_read’);;
$selectQry = “SELECT * FROM catalog_category_entity”;
$write->query($selectQry);

To add/modify data

$write = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);
$updateQry = “UPDATE catalog_category_entity_varchar SET value=’three_columns’ WHERE attribute_id=’61’ “;
$write->query($updateQry);

Magento

Magento Custom Query

To select the data

$read = Mage::getSingleton(‘core/resource’)->getConnection(‘core_read’);;
$selectQry = “SELECT * FROM catalog_category_entity”;
$write->query($selectQry);

To add/modify data

$write = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);
$updateQry = “UPDATE catalog_category_entity_varchar SET value=’three_columns’ WHERE attribute_id=’61’ “;
$write->query($updateQry);