magento sql query

modules-> Modulecontroller-> Controllermodel-> ModelMagento is the most powerful shopping cart online platform on the planet. Of course, you should have no doubt about it. However, you may not yet know that Magento is also an object-oriented PHP

Magento and magento functions. Magento common functions: magento common functions 1. how to specify a custom data source for source in the Magentoeav_attribute table if the referenced class name is yebihai_usermanage_model_entity_school your magento

Magento commonly used functions, Magento common functions 1.Magento eav_attribute table in how source specifies a custom data sourceIf you refer to the class name Yebihai_usermanage_model_entity_school you must give the address completely, not

principle:The Magento is based on the Zend framework, so the underlying is still Zend Zend DBTrace the following function to the file app/code/core/mage/catalog/model/resource/eav/mysql4/config.php getattributesusedinlisting ()/** * Retrieve

In any fast iteration of the project, how to ensure the development and production (current network) database synchronization is a very headache. Magento provides a system to create a resource migration version that can help us deal with the

1.Magento eav_attribute table in how source specifies a custom data sourceIf you refer to the class name Yebihai_usermanage_model_entity_school you must give the address completely, not usermanage/entity_school, so the default is to find under

How to batch Delete products in magento background How does magento batch Delete products? Anyone who has used magento knows that it is very slow to delete products in batches in the magento background. 30 products cannot be deleted in one minute.

I. Creating table structures and test dataCREATE table rooms (ID int not NULL auto_increment, name varchar (+), primary key (ID));INSERT into rooms VALUES (1, ' Royal ');INSERT into rooms VALUES (2, "standard");II. Create

Here is I do magento development commonly used methods, now summed up, the follow-up will be more useful methods summed up.1. Direct operation of the databaseCheck:$read = Mage::getsingleton ("Core/resource")->getconnection (' Core_read '); $sql =

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"