Accessing data from database in magento

Question

The code to fetch data from columns is:

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

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

    /**
     * Retrieve our table name
     */
    $table = $resource->getTableName('catalog/product');

    /**
     * Execute the query and store the results in $results
     */
    $sku = $readConnection->fetchCol('SELECT sku FROM ' . $table . ');

    /**
     * Print out the results
     */
     var_dump($results);

So what is the code for fetching data from a row? Is it like this?

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

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

    /**
     * Retrieve our table name
     */
    $table = $resource->getTableName('catalog/product');

    /**
     * Execute the query and store the results in $results
     */
    $sku = $readConnection->fetchRow('Random Query');

    /**
     * Print out the results
     */
     var_dump($results);

Or is there any special procedure for it?

TBI Infotech · Accepted Answer · 2014-07-14 11:08:00Z

1

//get the parameter from the request
    $param = $this->getRequest()->getParam('manufacturer');

    //instantiate the brand/brand model, and use 
    //its `getCollection` method to return a collection
    //object
    $collection = Mage::getModel('brands/brands')->getCollection();

    //add the paramater as a filter
    $collection->addFieldToFilter('attributelabelid', $param);

    //get the first item of the collection (load will be called automatically)
    $extrabrand = $collection->getFirstItem();

    //look at the data in the first item
    var_dump($extrabrand->getData());

Or you can use different attribute sets to make filtration on the row data entity you need.

 $table = $resource->getTableName('catalog/product');

you can use a number of addtofilter or attribute type search

$collection = Mage::getModel('module/model_name')->getCollection()
    ->addAttributeToSort('order', 'ASC')
    ->addAttributeToSort('last_name', 'ASC')
    ->addAttributeToSort('first_name', 'ASC')

This is the way by which we can use the attribute label to sort.

edited Jul 14, 2014 at 11:08

answered Jul 14, 2014 at 10:58

TBI Infotech

4,7861 gold badge15 silver badges30 bronze badges

attributelabeid? Is it attribute_id or attribute_code?

brainReader
– brainReader

2014-07-14 11:03:12 +00:00
Commented Jul 14, 2014 at 11:03
I am going to modify my answer

TBI Infotech
– TBI Infotech

2014-07-14 11:06:51 +00:00
Commented Jul 14, 2014 at 11:06
That makes code more complex. Please check this link: magento.stackexchange.com/questions/28644/…. I need to access stldowloader part from database.

brainReader
– brainReader

2014-07-14 11:08:51 +00:00
Commented Jul 14, 2014 at 11:08
And check this link also: magento.stackexchange.com/questions/28820/…

brainReader
– brainReader

2014-07-14 11:25:25 +00:00
Commented Jul 14, 2014 at 11:25

Add a comment |

Stack Exchange Network

Accessing data from database in magento

1 Answer 1

Your Answer

Linked

Hot Network Questions

Accessing data from database in magento

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions