magento上插入、编辑、删除、查询语法 简便方法

翻译:这是很容易的选择，插入，删除和更新记录在Magento网站

。以下功能有助于Magento网站数据库查询。您还可以使用此功能的帮助PF Magento的环境外，

包括“Mage.php”文件的形式“应用程序”文件夹像。这是很简单，从Magento网站数据库的数据Magento网站或其他网站的前端。

查询(select)语句connection = Mage::getSingleton('core/resource')->getConnection('core_read');$select = $connection->select()->from('tablename', array('*')) // select * from tablename or use array('id','name') selected values->where('id=?',1)               // where id =1->group('name');         // group by name$rowsArray = $connection->fetchAll($select); // return all rows$rowArray =$connection->fetchRow($select);   //return row插入(insert)语句?View Code PHP$connection = Mage::getSingleton('core/resource')->getConnection('core_write');$connection->beginTransaction();$fields = array();$fields['name']= 'test';$fields['age']='25';$connection->insert('tablename', $fields);$connection->commit();更新(update)语句$connection = Mage::getSingleton('core/resource')->getConnection('core_write');$connection->beginTransaction();$fields = array();$fields['name'] = 'jony';$where = $connection->quoteInto('id =?', '1');$connection->update('tablename', $fields, $where);$connection->commit();删除(delete)语句$condition = array($connection->quoteInto('id=?', '1'));$connection->delete('tablename', $condition);