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);