首页 > 代码库 > magento直接操作数据库

magento直接操作数据库

 
     $write = Mage::getSingleton("core/resource")->getConnection(‘core_write‘);
     $table = Mage::getSingleton(‘core/resource‘)->getTableName(‘abc‘);
     $write->insert($table,array(‘name‘=>‘hello‘));
 
     $write = Mage::getSingleton("core/resource")->getConnection(‘core_write‘);
    $table = Mage::getSingleton(‘core/resource‘)->getTableName(‘abc‘);
    $write->update($table,array(‘name‘=>‘abc‘),array(‘id‘=>3));
 
        $write = Mage::getSingleton("core/resource")->getConnection(‘core_write‘);
    $table = Mage::getSingleton(‘core/resource‘)->getTableName(‘abc‘);
    $write->delete($table,array(‘id‘=>3));
 
     $read = Mage::getSingleton("core/resource")->getConnection(‘core_read‘);
    $table = Mage::getSingleton(‘core/resource‘)->getTableName(‘abc‘);
        $result = $read->select()->from(array(‘main_table‘=>$table))->where(‘main_table.id‘,3)->limit(1);
        $products=$read->fetchAll($result);

magento直接操作数据库