magento insert and update and delet and all querys
It is very easy to select, insert, delete and update the record in
magento site. following functions are helpful in magento site for
database queries. You can also use this function outside magento
environment with 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 of magento site or another sites
magento site. following functions are helpful in magento site for
database queries. You can also use this function outside magento
environment with 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 of magento site or another sites
-
require_once ‘../../app/Mage.php’;
-
Mage::app(‘default’);
Select query to get the value form table
-
$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 query
-
$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 query
-
$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 query
-
$condition = array($connection->quoteInto(‘id=?’, ‘1’));
-
$connection->delete(‘tablename’, $condition);
Puneet Kumar Magento Developer
Leave a Reply
Want to join the discussion?Feel free to contribute!