Direct SQL Queries in Magento

DATABASE CONNECTIONS IN MAGENTO

 /**
 * Get the resource model
 */
 $resource = Mage::getSingleton('core/resource');

 /**
 * Retrieve the read connection
 */
 $readConnection = $resource->getConnection('core_read');

 /**
 * Retrieve the write connection
 */
 $writeConnection = $resource->getConnection('core_write');

/**
* Read Data From Table
*/

$query= 'SELECT * FROM '. $resource->getTableName('catalog/product');

/**
* Execute the query and store the results in $results
*/

$results = $readConnection->fetchAll($query);

/**
* Print out the results
*/

var_dump($results);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s