1. Hello today we are going to share that how to run hardcode raw sql queries in magento.<\/p>\n
2. For this you have to first create connection object to connect through database, there are two types of object, one for read and one for write.<\/p>\n
3. Following code is to create connection object for read.<\/p>\n
$read = Mage::getSingleton('core\/resource')->getConnection('core_read');<\/pre>\n4. And Below code is for write.<\/p>\n
$write = Mage::getSingleton('core\/resource')->getConnection('core_write');<\/pre>\n5. After that you just nead to fire querie and handle data as follows.<\/p>\n
$result=$read->query(\"SELECT * FROM table_mae WHERE column_name='value'\");\r\n$row = $result->fetch();\r\necho $row['column_name']; \r\n\r\n\/* or to insert values you can do something like this *\/\r\n\r\n$write->query(\"Insert into table_name values('','','','')\");<\/pre>\n6. That is it you can save and run the code Enjoy!!<\/p>\n","protected":false},"excerpt":{"rendered":"