magento join
$collection = Mage::getModel('catalog/product')->getCollection()->setStoreId($storeId) ->addAttributeToSelect("*"); $collection->getSelect()->join(array('cat_index'=>'catalog_category_product_index'),"cat_index.product_id=e.entity_id and cat_index.store_id='$storeId' AND cat_index.category_id in ($catsString)",array('*')); more details :http://stackoverflow.com/questions/3949470/how-to-select-specific-......
SQL 数据类型
Microsoft Access、MySQL 以及 SQL Server 所使用的数据类型和范围。 Microsoft Access 数据类型 数据类型 描述 存储 Text 用于文本或文本与数字的组合。最多 255 个字符。 Memo Memo 用于更大数量的文本。最多存储 65,536 个字符。 注释:无法对 memo 字段进行排序。不过它们是可搜索的。 Byte 允许 0 到 255 的数字。 1 字节 Integer 允许介于 ......
Magento folder structure
Here’s short overview: / app - is where the application resides / app / etc - is global configuration den / app / code - is where modules have installed their models and controllers / app / code / core - are core team developed or certified modules / app / code / community - are community contributed modules / app / code / local - are local customizations / app / code / core / Mage - magento default namespace / app / code / core / Mage / {Module} - module root / app / code / core / Mage / {Module} / etc - module configuration / app / code / cor......
Magento Architecture
Page request flow Preliminary core modules dependency diagram ......
Basic Magento Directory Overview
Important Paths / -Directory Root /app - This is where all the php code for the application resides /lib - The external code library. /skin - This is where css and other images reside Thats the quick overview. /app /code - Where all modules reside /design - Contains both layout xml files and template .phtml files /etc - Global configuration Mage.php - Static class Mage, where everything is held together. Before I move on to the other two directories (/lib, /skin) I’ll explain the directories......
magento wiki
from : http://www.magentocommerce.com/wiki/index/categories Wiki Articles 1 - Installation And Configuration 2 - Magento Concepts And Architecture 3 - Store Setup And Management 4 - Themes And Template Customization 5 - Modules And Development 6 - Magento Mobile 7 - Magento Connect 7 - Modules And Development Bienvenido A La Guia De Usuario De Magento Doc Groups How-to How To How To Restore Admin Access For Failed Tls Import-export A......
Magento添加中国省份列表
第一步:找到Directory模块,在sql下创建新的升级脚本,版本号只要比之前的大就好,例如我的是mysql4-upgrade-0.8.10-0.8.11.php。 文件内容: < ?php /** * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web,......
Magento作为内容管理系统(cms)或开发框架使用
Magento框架设计的魅力实在是另我钦佩,所以把Magento其他模块都禁用掉了仅留下了Core和Cms模块,作为我的开发框架使用。试用了下,完美! 作为CMS可能Magento不是最好的,我们也不去争论它,只是我认为这样做更适合我的需求,或者说是适合作为我的开发框架使 用。同时我要说的是这样禁用掉很多模块,后台留下的一些目录进去后会报错,这个要依照你自己的使用去修改。我相信能对我这篇文章感兴趣的人一定有很深的技 术基础,所以请尽情发挥吧......
Magento深入理解-Grid报错clause is ambiguous问题
我记得之前没少讲过Grid,今天在写Grid遇到这样一个错误,将解决办法分享下。 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'increment_id' in where clause is ambiguous 这个错误怎么来的呢,关键是clause is ambiguous。 使用Grid必须要设置一个Collection,往往这个Grid需要联表查询,就是写join语句。请看下面例子: protected function _getCollectionClass() { return 'sales/order_shipment_grid_collection'; } protected function _prepareCollection() ......
- Page:44/146 1460 Blogs
周日 | 周一 | 周二 | 周三 | 周四 | 周五 | 周六 |
文章分类
- 默认(760)
- 日志(47)
- 感悟(15)
- testIT(4)
- PHP_XML(5)
- PHP(78)
- 明星(1)
- 笑话(31)
- 毕业论文(2)
- 生活(60)
- HTML(11)
- CSS(6)
- 考研(3)
- JS(21)
- 简历(6)
- svn(3)
- 音乐(1)
- 学习(7)
- jQuery(9)
- 英语口语(9)
- 书籍(2)
- magento(258)
- apache(12)
- 创意(4)
- 设计(4)
- 休闲(1)
- IT咨询(11)
- 工作(23)
- ubuntu(21)
- bysoft(1)
- zend(1)
- web(2)
- software(1)
- sql(5)
- 娱乐(5)
- photoshop(3)
- zend framework(2)
- nginx(3)
- 小说(1)
- 名言(1)
- 牛人(1)
- Mysql(6)
- vim(2)
- wordpress(8)
- drupal(1)