Check:
$read = Mage::getsingleton ("Core/resource")->getconnection (' Core_read '); $sql = "SELECT * from ' abc '"; $result = $read->fetchall ($sql); //fetchrow Find a Add, delete, change $write = Mage::getsingleton ("Core/resource") getconnection (' Core_write '); $sql = "INSERT into ABC (name) VALUES (' Hello ')"; $write->query ($sql); Another way: increase $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)); Delete $write = Mage::getsingleton ("Core/resource")- >getconnection (' Core_write '); $table = Mage::getsingleton (' Core/resource ') Gettablename (' abc '); $write->delete ($table, Array (' id=? ') =>3); check $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); the only difference is that an SQL statement is assembled, and one is written directly.
Magento Direct Operations Database