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

It is very easy to select, insert, delete and update therecord in magento site. following functions are helpful in magento site fordatabase queries. You can also use this function outside magento environmentwith the help pf include “Mage.php” file form “app” folder like.
This is very simple to get data from database of magento site to frontend ofmagento site or another sites.

翻 译:这是很容易的选择，插入，删除和更新记录在Magento网站。以下功能有助于Magento网站数据库查询。您还可以使用此功能的帮助PF Magento的环境外，包括“Mage.php”文件的形式“应用程序”文件夹像。这是很简单，从Magento网站数据库的数据Magento网站或 其他网站的前端。

１.查询(select)语句

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

->getConnection('core_read');

$select = $connection->select()

->from('tablename', array('*')) // select * fromtablename or use array('id','name') selected values

->where('id=?',1)               //where id =1

->group('name');         // group by name

$rowsArray = $connection->fetchAll($select); // return allrows

$rowArray =$connection->fetchRow($select);   //return row

 

２.插入(insert)语句

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