Magento Coding Solutions

get attribute value by attribute Id in magento

 $attributCode=23;
$attrV = Mage::getModel('eav/entity_attribute_option')->
getCollection()->setStoreFilter()->join('attribute','attribute.attribute_id=main_table.attribute_id', 'attribute_code')->addFieldToFilter('main_table.option_id',array('eq'=>$attributCode))->getFirstItem();

            $attDataV=$attrV->getData();
            print_r($attDataV);
            $viewNo=$attDataV['value'];

add custom options in magento admin sales order grid

Stap1: app\code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php

   add custom column  like "Fedback"

    $this->addColumn('Feedback', array(
            'header' => Mage::helper('sales')->__('Feedback'),
            'align' =>'left',
            'index' => 'Feedback',
            'renderer'  => 'Mage_Adminhtml_Block_Sales_Order_renderer_Feedback'
            //’attr’ => ‘value’, // You can use it to pass extra custom value //
            ));


Step 2: Make "Renderer" folder app\code\core\Mage\Adminhtml\Block\Sales\Order\
Step3: make  app\code\core\Mage\Adminhtml\Block\Sales\Order\Renderer\Feedback.php

 <?php

class  Mage_Adminhtml_Block_Sales_Order_Renderer_Feedback extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract{
 public function render(Varien_Object $row)
    {
        $data= $row->getData();
        echo "oderId:".$data['entity_id'];
       $html = '<p>'.$row->getData(entity_id).'</p>';
  
       $html .= '<a  href="'.Mage::getBaseUrl('web').''">DST Design</a></p>';
        return $html;
    }
}
?>

Magento admin login not working in chrome

I think there is the problem with session cookie with the chrome browser. So just go through this directory /app/code/core/Mage/Core/Model/Session/Abstract/Varien.php file and comment out the line from 85 to 92 in magento


// session cookie params
   /* $cookieParams = array(
        'lifetime' => $cookie->getLifetime(),
        'path'     => $cookie->getPath(),
        'domain'   => $cookie->getConfigDomain(),
        'secure'   => $cookie->isSecure(),
        'httponly' => $cookie->getHttponly()
    );
  */

programaticaly Insert and select quary In magento

    
 INSERT QUERY

include('../app/Mage.php');
Mage::app();

$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$sql="INSERT INTO opd_uploads SET extension='$extension', sessionId='$sessionId', ip='$ip', status=1, dateTime=now()";
$write->query($sql);
//lastInserted ID
$imageId = $write->lastInsertId();


SELECT QUERY

$read= Mage::getSingleton('core/resource')->getConnection('core_read');
       
         $value=$read->query("select * from opd_uploads WHERE id='".$imageRowId."'");
         $row = $value->fetch();
         $orgFilExt=$row['extension'];
       

Get store data Magento

Get store data
Mage::app()->getStore();
Store Id
Mage::app()->getStore()->getStoreId();
Store code
Mage::app()->getStore()->getCode();
Website Id
Mage::app()->getStore()->getWebsiteId();
Store Name
Mage::app()->getStore()->getName();
Is Active
Mage::app()->getStore()->getIsActive();
Store Home Url
Mage::app()->getStore()->getHomeUrl();