Magento 常用技巧与方法

资料来自网络，大部分没有经过验证，仅供参考：

1.属性Attribute

产品属性操作：

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

foreach($product->getAttributes() as $att) {

$group_id = $att->getData('attribute_group_id');

$group = Mage::getModel('eav/entity_attribute_group')->load($group_id);

var_dump($group);

}

$attrSetName = 'my_custom_attribute';

$attributeSetId = Mage::getModel('eav/entity_attribute_set') ->load($attrSetName, 'attribute_set_name') ->getAttributeSetId();

1.1 得到Product的属性id，即catalog_product_entity表的entity_type_id字段

$productAttributeSets = $this->getProductAttributeSets();

1.2 前台页面获取商品属性

$_product->getResource()->getAttribute('cost')->getFrontend()->getValue($_product);

Magento的产品属性，在catalog.xml中已经写进去了。你可以在product view中找到

<block type="catalog/product_view_attributes" name="product.attributes" as="additional" template="catalog/product/view/attributes.phtml">

<action method="addToParentGroup"><group>detailed_info</group></action>

</block>

现在只要在产品详细页（view.phtml）中想要的位置插入

<?php echo $this->getChildHtml('additional') ?>

1.3获取产品属性集

$sets = Mage::getResourceModel('eav/entity_attribute_set_collection') ->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId()) ->load() ->toOptionHash();

1.4 加载某个attribute：

$attributeCode=Mage::getModel('catalog/resource_eav_attribute')

->load($attrbuteId)

->getData("attribute_code");

1.5 获取所有的产品属性的attribute：

$attributes = Mage::getResourceModel ( 'catalog/product_attribute_collection' )

->addFieldToFilter ( "frontend_input", "select" )

->load ();

1.6 获取某个product的所有attribute：

注：如果是在 collection 中获取自定义的attribute，必须加 addAttributeToSelect(), 如下：

$product=Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect("dropdownlistone")

1.7 获取某个种类的所有attribute：

$entityTypeId = Mage::getSingleton('eav/config')

->getEntityType('catalog_product')

->getEntityTypeId();

$items = Mage::getResourceSingleton('catalog/product_attribute_collection')

->setEntityTypeFilter($entityTypeId)

->getItems();

1.8 获取某个attribute的所有option：

$attributeObject=Mage::getModel('eav/config')->getAttribute('catalog_product')->load($attributeId);

$options = $attributeObject->setStoreId(Mage::app()->getStore()->getId())->getSource()->getAllOptions(false);

$table = $attributeObject->getBackend()->getTable();

public function getAttributeOptionsByAttributeCode($entityType, $attributeCode){

$entityType = Mage::getSingleton('eav/config')->getEntityType($entityType);

$attributeObject = Mage::getModel('customer/attribute')->loadByCode($entityType, $attributeCode);

return $attributeObject->setStoreId(Mage::app()->getStore()->getId())->getSource()->getAllOptions(false);

}

或者：

$optionCollection = Mage::getResourceModel('eav/entity_attribute_option_collection')

->setAttributeFilter($attr_model->getId())

->setStoreFilter($storeId, false)

->load();

1.9 获取某个attribute的所有多语言label：

$attributeLabelsArray= Mage::getResourceModel('eav/entity_attribute')

->getStoreLabelsByAttributeId($attrbuteId);

1.10 获取某个attribute_set的所有attribute：

$attributes = Mage::getResourceModel('catalog/product_attribute_collection')

->setAttributeSetFilter($attribute_set_id)

->load();

$attributeSetCollection = Mage::getResourceModel('eav/entity_attribute_set_collection')

->load();

1.11 获取attribute 对象 by attribute code

$muarqspFrom = Mage::getSingleton('eav/config')->getAttribute('catalog_product', ' muarqsp_from');

$attrCollection = Mage::getResourceModel('eav/entity_attribute_collection')

->setCodeFilter($attributeCode)

->load()

1.12 通过attributeName得到 attributeSetId

Mage::getResourceModel('eav/entity_attribute_set_collection')

->addFieldToFilter('attribute_set_name',$attributSetName)

->getFirstItem()->getId();

1.13 通过 attributeSetId得到attributeSetName

Mage::getModel('eav/entity_attribute_set')

->load($id)->getData("attribute_set_name");

2. 产品相关操作

2.1 产品缩略图

$_thumb = Mage::helper('catalog/image')->init($product, 'thumbnail')->resize(50, 50)->setWatermarkSize('30x10');

2.2 product collection

$collection = Mage::getResourceModel('catalog/product_collection')

->addStoreFilter()

->addAttributeToSelect("*")

->addAttributeToFilter('entity_id', array('in' => $products))

->setPageSize(10)

->setCurPage(1);

2.3 删除一个product的所有的images//Get products gallery attribute

$attributes = $product->getTypeInstance()->getSetAttributes();

if (isset($attributes['media_gallery'])) {

$gallery = $attributes['media_gallery'];

//Get the images

$galleryData = $product->getMediaGallery();

foreach($galleryData['images'] as $image){

//If image exists

if ($gallery->getBackend()->getImage($product, $image['file'])) {

$gallery->getBackend()->removeImage($product, $image['file']);

$filename = Mage::getBaseDir('media') . DS . 'catalog'. DS .'product' . $image['file'];

debug('<span style="color: green;">&lt;&lt; unlinked previous image '.$image['file'].' from product '.$product->getSku().'</span>');

if (file_exists($filename) && is_file($filename) && is_writeable($filename)){

@unlink($filename);

debug('<span style="color: green;">(and deleted file '.$filename.')</span>');

}else

debug('<span style="color: red;">(but couldn\'t delete file '.$filename.')</span>');

}

}

}

3. website

获取对象的方法:get_class_methods($object)

返回对象的类名:get_class($object)

3.1得到store id

$store_id=Mage::getModel('core/store')

->getCollection()

->addFieldToFilter ( "code", "france_fr" )

->getFirstItem()->getData('store_id');

or

Mage::getModel('core/store')->load('france_fr')->getId()

3.2 得到website config

//$website can be string or id

$import_type = Mage::getModel('core/website')->load($website)->getConfig('maps/stock_import/stock_limit');

if( $import_type===false ){

//get admin config

$import_type=Mage::getStoreConfig('maps/stock_import/import_type'，0);

}

获取后台的配置

Mage::getStoreConfig("clientnumber/total_config/service_ip",0); //get admin config

3.3 generate skin url

Mage::getDesign()->getSkinUrl('images/our_shops/shop_logo_default.jpg');

3.4 generate select html

$html = $this->getLayout()->createBlock('core/html_select')

->setName($name)

->setId($id)

->setTitle(Mage::helper('directory')->__($title))

->setClass('validate-select')

->setValue($defValue)

->setOptions($options)

->getHtml();

3.5 获取这个网站所代表的国家的代号（如：FR）

Mage::getModel('directory/country')

->load(Mage::getStoreConfig('general/country/default'))->getIso2Code(),

3.6 获取登录的用户信息

Mage::getSingleton('customer/session')->getCustomer()

3.7 session,cookie

1) 获取session

$session = Mage::getSingleton('customer/session');

2) session,cookie设置

(1) Model：

Mage::getModel(‘core/cookie’); Mage::getModel(‘core/session’);

(2)Set Method:

Mage::getSingleton(‘core/cookie’)->set(‘name’,'value’); Mage::getSingleton(‘core/session’)->set(‘name’,'value’);

(3)Get method:

Mage::getSingleton(‘core/cookie’)->get(‘name’); Mage::getSingleton(‘core/session’)->get(‘name’);

3.8 Request对象

Mage::app()->getRequest()

3.9 调用Model对象

Mage::getModel('infinity/model');

3.10 输出配置文件

//header(‘Content-Type: text/xml’);

header(‘Content-Type: text/plain’);

echo $config = Mage::getConfig() ->loadModulesConfiguration(‘system.xml’) ->getNode() ->asXML();

exit;

3.11 得到Magento分类的URL

Mage::getModel('catalog/category')->load(17)->getUrl();

3.12 build your URL with valid keys

Mage::helper("adminhtml")->getUrl("mymodule/adminhtml_mycontroller/myaction/",array("param1"=>1,"param2"=>2));

3.13 create key values

Mage::getSingleton('adminhtml/url')->getSecretKey("adminhtml_mycontroller","myaction");

3.14 disable security feature in the admin panel 在管理面板中禁用安全功能

admin panel -> System -> Configuration -> Admin section: “Add Secret key to Urls”.

3.15 后台模块跳转：

Mage::app()->getResponse()->setRedirect(Mage::helper('adminhtml')->getUrl("adminhtml/promo_quote/index"));

3.16 get a drop down lists options for a mulit-select attribute 多属性选择下拉列表

$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'attribute_id');

foreach ( $attribute->getSource()->getAllOptions(true, true) as $option)

{

$attributeArray[$option['value']] = $option['label'];

}

3.17 获取栏目图片

public function getImageUrl($category) {

return Mage::getModel('catalog/category')->load($category->getId())->getImageUrl();

}

public function getThumbnailUrl($category) {

$image=Mage::getModel('catalog/category')->load($category->getId())->getThumbnail();

if ($image) {

$url = Mage::getBaseUrl('media').'catalog/category/'.$image;

}

return $url;

}

3.18 判断是否首页：$this->getIsHomePage()

Mage::getSingleton('cms/page')->getIdentifier() == 'home' && Mage::app()->getFrontController()->getRequest()->getRouteName() == 'cms' )

3.19 主题颜色

$attributes = $_product->getAttributes();

$themeColor = $attributes['theme_color']->getFrontend()->getValue($_product);

3.20 获取configurable产品simple product

if($_product->getTypeId() == "configurable"):

$ids = $_product->getTypeInstance()->getUsedProductIds();

foreach ($ids as $id) :

$simpleproduct = Mage::getModel('catalog/product')->load($id);

$simpleproduct->getName()." - ".(int)Mage::getModel('cataloginventory/stock_item')->loadByProduct($simpleproduct)->getQty();

$childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null, $product);

endforeach；

endif；

3.21 get the attributes of Configurable Product.

$attributes = $product->getTypeInstance(true)->getConfigurableAttributes($product);

3.22 当前路径

$currentUrl = $this->helper('core/url')->getCurrentUrl();

3.23 通过资源配置方式创建目录

$installer = $this; $installer->startSetup(); // make directory for font cache

try {

$domPdfFontCacheDir = join(DS, array('lib', 'Symmetrics', 'dompdf', 'fonts'));

$domPdfFontCacheDir = Mage::getBaseDir('var') . DS . $domPdfFontCacheDir;

if (!file_exists($domPdfFontCacheDir)) {

mkdir($domPdfFontCacheDir, 0777, true);

}

} catch(Exception $e) {

throw new Exception( 'Directory ' . $domPdfFontCacheDir . ' is not writable or couldn\'t be ' . 'created. Please do it manually.' . $e->getMessage() );

}

$installer->endSetup();

3.24 在controllers 实现跳转

Mage::app()->getFrontController() ->getResponse() ->setRedirect('http://your-url.com');

×××××

$cms_id = Mage::getSingleton('cms/page')->getIdentifier();

$cms_title = Mage::getSingleton('cms/page')->getTitle();

$cms_content = Mage::getSingleton('cms/page')->getContent();

3.25 获取当前站点货币符号

$storeId = (int) $this->getRequest()->getParam('store', 0);

$store=Mage::app()->getStore($storeId);

$currencyCode=$store->getBaseCurrency()->getCode();

$attribute = Mage::getModel('catalog/resource_eav_attribute')->load($attributeId);

$attributeData = $attribute->getData();

$frontEndLabel = $attributeData['frontend_label'];

$attributeOptions = $attribute->getSource()->getAllOptions();

3.26 设置meta信息

$template = Mage::getConfig()->getNode('global/page/layouts/'.Mage::getStoreConfig("featuredproducts/general/layout").'/template');

this->loadLayout(); $this->getLayout()->getBlock('root')->setTemplate($template);

$this->getLayout()->getBlock('head')->setTitle($this->__(Mage::getStoreConfig("featuredproducts/general/meta_title")));

$this->getLayout()->getBlock('head')->setDescription($this->__(Mage::getStoreConfig("featuredproducts/general/meta_description")));

$this->getLayout()->getBlock('head')->setKeywords($this->__(Mage::getStoreConfig("featuredproducts/general/meta_keywords")));

$this->renderLayout();

4.

magento中调用static block(静态块)的几种方法

通常情况下，在magento程序中使用静态块用来创建广告、促销图片及静态的内容等等

以下以在magento中利用静态块来创建首页两侧的广告

在后台创建一个ad1静态块

(1)如果要在.phtml文件中直接调用这个静态块，那可以采用以下方法

<?php

$block = Mage::getModel(‘cms/block’)

->setStoreId(Mage::app()->getStore()->getId()) ->load(‘ad1′);

$content = $block->getContent(); // Block的原始内容已经获得

$processor = Mage::getModel(‘core/email_template_filter’);

echo $html = $processor->filter($content);

?>

Mage::getModel(‘core/email_template_filter’)->filter()是必须的，因为Static Block里可能包含Magento的模板语言（如:{{store url=”"}}），fiter将翻译成实际的值

Magento中调用静态Block主要有两个地方。

是否感觉这代码太长了呢，那你还可以这么写

<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('order_form')->toHtml() ?>

(2)在CMS页面的Content中调用这个静态块呢？你可以采用以下方法

{{block type=”cms/block” name=”cms_ad1_block” block_id=”ad1″ }}

(3)在layout中调用静态块

<reference name=”footer”>

<block type=”cms/block” name=”ad1″ before=”-”>

<action method=”setBlockId”><block_id>ad1</block_id></action>

</block>

</reference>

5. 时间

5.1 获取当前的时间

1) $date = Mage::app()->getLocale()->date(Mage::getSingleton('core/date')->gmtTimestamp(), null, null);

$date = $date->toString('yyyy-MM-dd hh:m:s');

2) Mage::getModel('core/date')->date(); date("Y-m-d", Mage::getModel('core/date')->timestamp(time()));

Magento中默认时区为GMT, 不能直接使用time(), date()等方法，否则会出现时间差。

用下面的方法取当前时间（和后台设置的时区一致）：

date("Y-m-d", Mage::getModel('core/date')->timestamp(time()));

获得UTC时间的方法

$date = Mage::app()->getLocale()->utcDate($store, $value, true, Varien_Date::DATETIME_INTERNAL_FORMAT);

$this->setData(‘date_start’, $date->toString(Varien_Date::DATETIME_INTERNAL_FORMAT));

$date = Mage::app()->getLocale()->date();

$dStr = $date->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);

//$dStr 可以用于存储到数据库的datetime字段.

5.2 格式化时间

Mage::app()->getLocale()->date($creditMemo->getCreatedAt())->toString('YYYY-MM-dd');

或：

$this->_filterDates($data, array('date_expires'));

protected function _filterDates($array, $dateFields)

{

if (empty($dateFields)) {

return $array;

}

$filterInput = new Zend_Filter_LocalizedToNormalized(array(

'date_format' => Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT)

));

$filterInternal = new Zend_Filter_NormalizedToLocalized(array(

'date_format' => Varien_Date::DATE_INTERNAL_FORMAT

));

foreach ($dateFields as $dateField) {

if (array_key_exists($dateField, $array) && !empty($dateField)) {

$array[$dateField] = $filterInput->filter($array[$dateField]);

$array[$dateField] = $filterInternal->filter($array[$dateField]);

}

}

return $array;

}

5.3 加减日期

Mage::app()->getLocale()->date()->sub("3",Zend_Date::DAY)->toString('YYYY-MM-dd HH:mm:ss');

5.4 日期过滤

$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);

$this->_getProductCollection()

->addAttributeToFilter('news_from_date', array('or'=> array(

0 => array('date' => true, 'to' => $todayDate),

1 => array('is' => new Zend_Db_Expr('null')))

), 'left')

->addAttributeToFilter('news_to_date', array('or'=> array(

0 => array('date' => true, 'from' => $todayDate),

1 => array('is' => new Zend_Db_Expr('null')))

), 'left')

->addAttributeToFilter(

array(

array('attribute' => 'news_from_date', 'is'=>new Zend_Db_Expr('not null')),

array('attribute' => 'news_to_date', 'is'=>new Zend_Db_Expr('not null'))

)

)

->addAttributeToFilter('visibility', array('in' => array(2, 4)))

->addAttributeToSort('news_from_date', 'desc')

->setPage(1, 4);

5.5 判断日期是否有效

Mage::app()->getLocale()->isStoreDateInInterval(Mage::app()->getStore(), $special_from_date, $special_to_date)

6. collection

6.1 在Configuation中添加validate

<validate>validate-number</validate>

6.2 获取当前的controller

$moduleName=Mage::app()->getRequest()->getModuleName();

$controllerName=Mage::app()->getRequest()->getControllerName();

$actionName=Mage::app()->getRequest()->getActionName();

$fullActionName=$moduleName."_".$controllerName."_".$actionName;

6.3 controller 中 添加block

$this->getLayout()

->createBlock('clientnumber/inputform', 'checkout.cart.inputclientnumber')

->setTemplate('clientnumber/input.phtml')

->toHtml()

6.5添加breadcrumbs在 controller中(为前端页面添加面包屑,如 Category/product这里的导航 )：

在controller文件中填充面包屑数据，在block的phtml文件中显示

1). 在controller的Action方法中

//判断是否存在名字为breadcrumbs的Block（默认都存在，后面有说明）

if ($breadcrumbsBlock = $this->getLayout()->getBlock('breadcrumbs')) {

// 该条目有目标链接地址

$breadcrumbsBlock->addCrumb('category', array(

'label' => 'Category',

'title' => 'Category Title',

'link' => 'http://www.google.com',

'readonly' => true,

));

// 该条目没有链接地址，一般作为最后一个条目

$breadcrumbsBlock->addCrumb('product', array('label' => Mage::helper('catalog')->__('Product')));

}

2). 在该action对应的Layout文件中添加Block

Xml代码:

<block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>

相应的在你的Block的合适位置输出面包屑

<?php echo $this->getChildHtml('breadcrumbs'); ?>

以上描述的是面包屑的一般原理，Magento实际上已经默认声明了Block

Xml代码:

<block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>

而且默认的几个layout模板文件(page/1column.phtml,page/2columns-left.phtml..等)已经做了

<?php echo $this->getChildHtml('breadcrumbs'); ?>

6.6 filter in collection

$collection = Mage::getModel('sales/order')->getCollection()

->addFieldToFilter('status', array('eq'=>'pending'))

->addFieldToFilter('created_at', array('datetime' => true, 'from'=>"2011-10-10 00:00:00",'to' => Mage::app()->getLocale()->date()->sub("3",Zend_Date::DAY)->toString('YYYY-MM-dd HH:mm:ss')));

6.7 在controllers 实现跳转

Mage::app()->getFrontController() ->getResponse() ->setRedirect('http://your-url.com');

7. 获取quote中的所有的item

$quote=Mage::getSingleton('checkout/session')->getQuote();

foreach ($quote->getAllItems() as $item) {

$proId[]=$item->getProduct()->getId();

}

8. 发送邮件

$mailTransport = new Zend_Mail_Transport_Smtp( '192.168.0.1' );

$mail = new Zend_Mail();

$mail->setBodyText($content);

$mail->setFrom("[e-mail]", 'Webmaster');

$mail->addTo("[e-mail]", '');

$mail->setSubject('Import attribute logs');

$mail->send($mailTransport);

9. block

9.1 用block创建一个template

<?php echo Mage::getBlockSingleton('inseecode/form')->getInseeFormHtml($this->getAddress(), 'customer');?>

public function getInseeFormHtml($address, $type) {

$this->setTemplate('inseecode/form.phtml');

return $this->toHtml();

}

9.2 利用静态block

<?php echo $this->getLayout()->createBlock('clientnumber/widget_name')

->setObject($this->getAddress())

->toHtml()

?>

9.3 调用static block

1) 如果要在.phtml文件中直接调用这个静态块，那可以采用以下方法

<?php $block = Mage::getModel('cms/block')

->setStoreId(Mage::app()->getStore()->getId())

->load('order_form');

$content = $block->getContent(); // Block的原始内容已经获得

$processor = Mage::getModel('core/email_template_filter');

echo $html = $processor->filter($content);

?>
Mage::getModel(‘core/email_template_filter’)->filter()是必须的，

因为Static Block里可能包含Magento的模板语言（如:{{store url=”"}}），fiter将翻译成实际的值

Magento中调用静态Block主要有两个地方。

是否感觉这代码太长了呢，那你还可以这么写

<?php echo $this->getLayout()->createBlock(‘cms/block’)->setBlockId(‘order_form’)->toHtml() ?>

2) magento中的CMS功能,可以让我们很方便的在PHP中嵌入经常要更改的内容,这样我们可以通过在CMS中直接修改文章内容,

而不需要去修改源代码,最经典的就是我们的首页就是写在CMS Static block中的。

如何在CMS页面的Content中调用这个静态块呢？你可以采用以下方法

{{block type=”cms/block” name=”cms_test_block” block_id=”order_form” }}

将里面order_form改成你的静态块对应的block_id则可

3) 怎么样在layout中调用静态块呢？

<reference name=”footer”>

<block type=”cms/block” name=”order_form” before=”-”>

<action method=”setBlockId”><block_id>order_form</block_id></action>

</block>

</reference>

magento中调用CMS静态块(Static Block)教程到此就结束了，你应该能够灵活的运用magento中的静态块了吧！

10. 获取指定level目录

$parent = Mage::app()->getStore()->getRootCategoryId();

$categoryModel = Mage::getModel('catalog/category');

$storeCategories = $categoryModel->getCategories($parent, 2); //获取level 2

11. 数据库

11.1 修改数据库结构

$installer->getConnection()->addColumn(

$installer->getTable('enterprise_giftcardaccount/giftcardaccount'),

'gift_card_type',

"VARCHAR(200) DEFAULT ''");

$installer->getConnection()->addColumn(

$installer->getTable('enterprise_giftcardaccount/giftcardaccount'),

'gift_card_type',

"TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'");

$installer->getConnection()->dropColumn($installer->getTable('eav_attribute'), 'use_in_super_product');

$installer->run("ALTER TABLE `sales_flat_order` CHANGE `is_synced` `is_synced` INT( 4 ) NOT NULL ");

11.2 magento操作数据库

eg.1

$this->getSelect()

->from(array('e' => $this->getEntity()->getFlatTableName()), null)

->columns(array('status' => new Zend_Db_Expr(Mage_Catalog_Model_Product_Status::STATUS_ENABLED)));

$this->addAttributeToSelect(array('entity_id', 'type_id', 'attribute_set_id'));

if ($this->getFlatHelper()->isAddChildData()) {

$this->getSelect() ->where('e.is_child=?', 0);

$this->addAttributeToSelect(array('child_id', 'is_child'));

}

$select=$this->getSelect()->from(array('e'=>$this->getEntity()->getEntityTable()));

$select->joinRight( array('t'=>'test_product'), 'e.entity_id = t.entity_id', array() );

eg.2

$resource = Mage::getSingleton('core/resource');

$read= $resource->getConnection('read');

$tempTable = $resource->getTableName('eav_attribute'); //用其他表也是可以的

$wheres = "`entity_type_id` =4 ";

//SELECT count(*) as num FROM `eav_attribute` WHERE (`entity_type_id` =4 )

//$select = $read->select() ->from($tempTable, array('count(*) as num')) ->where($wheres);

//SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`entity_type_id` =4 )

//$select = $read->select() ->from($tempTable) ->where($wheres);

//SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (`entity_type_id` =4 )

$select = $read->select() ->from($tempTable, array('attribute_code')) ->where($wheres);

$result = $read->fetchAll($select);

eg.3

$resource = Mage::getSingleton('core/resource');

$read= $resource->getConnection('read');

$select = "select * from catalog_product_entity where entity_id =5";

$result = $read->fetchAll($select);

//$result = $read->fetchOne($select);

$instructors = array();

foreach($result as $item){

$instructors[$item['entity_id']] = array('position' => $item['sku']);

}

$dbw = Mage::getSingleton('core/resource')->getConnection('write');

$sql="update catalog_product_entity set sku='sku11' where entity_id=5";

$dbw->query( $sql );

magento--调用数据库的步骤--使用magento机制访问数据库

在后台附加一个属性，譬如品牌.然后，在产品详细页面，把同个品牌的产品都调用出来！下面是程序代码

public function getOtherProduct(){

$_producty = $this->getProduct();

$_biaoshi = $_producty['biaoshi'];

$resource = Mage::getSingleton('core/resource');

$read = $resource->getConnection('catalog_read');

$categoryProductTable = $resource->getTableName('catalog/category_product');

//$productEntityIntTable = $resource->getTableName('catalog/product_entity_int'); // doesn't work

$productEntityIntTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity_int';

$eavAttributeTable = $resource->getTableName('eav/attribute');

$product_attribute_valueTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity_varchar';

//return $product_attribute_valueTable;

// var_dump($productEntityIntTable); exit;

// Query database for featured product

$select = $read->select()

->from(array('cp'=>$categoryProductTable))

// ->join(array('pei'=>$productEntityIntTable),'pei.entity_id=cp.product_id', array())

->join(array('pss'=>$product_attribute_valueTable),'pss.entity_id=cp.product_id',array())

->joinNatural(array('ea'=>$eavAttributeTable))

// ->joinNatural(array('pss'=>$product_attribute_valueTable))

// ->where('cp.category_id=?', $categoryId)

->where('pss.value=?',$_biaoshi)

// ->where('ea.a')

->where('ea.attribute_code="biaoshi"');

$rows = $read->fetchAll($select);

$ids = array();

foreach($rows AS $row) {

$ids[] = $row['product_id'];

}

$ret = implode(',', $ids);

$ids = array_unique($ids);

// return $ids;

$productList = array();

foreach($ids as $idq){

$product = Mage::getModel('catalog/product')->load($idq);

$productList[] = $product;

}

// $product = Mage::getModel('catalog/product')->load($this->getProductId());

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

// $collection->getSelect()->where('e.entity_id in (?)', $ids);

// $collection->addAttributeToSelect('*');

// $productList = $collection->load();

return $productList;

// return $ids;

}

如果你想成为一个magento二次开发程序员，上面的代码，你会感兴趣

12. 打印php调试信息的代码

$array = debug_backtrace();

//print_r($array);//信息很齐全

unset($array[0]);

foreach($array as $row)

{

$html .= $row['file'].':'.$row['line'].'行,调用方法:'.$row['function']."<p>";

}

echo $html;

exit();

13. test code for quote

$quote=Mage::getSingleton('checkout/session')->getQuote();

foreach ($quote->getAllVisibleItems() as $item) {

echo $item->getProductId();

}