Magento 1.9 – How to Get Value from Database

databasemagento-1.9

I have this table in my Magento database:
'manthan_marketplace_vendorproduct':

    entity_id  product_id  user_id
       3          35          2 
       4          36          2

It shows all the products that have been added by each user(seller)
I can access the user_id value in my phtml file in this directory:

app\design\frontend\base\default\template\marketplace\seller\profile.phtml

by this code:

$seller = $this->sellerProfile();
$seller['user_id'];

but $seller which is an array of objects, doesn't have any product_id. So I should use that table to get all product_id into an array
but the Magento framework is unknown for me.

Help me please, thanks!

Best Answer

Try below code to get product IDs for a seller.

$sellerData = Mage::getModel('marketplace/vendorproduct')->getCollection()‌
->addFieldToFilter('user_id',$seller['user_id']) // Filter using seller Id
->getColumnValues('product_id'); // Get Only Product IDs
print_r($sellerData);

Change from

$collection->getSelect()->join(array('volumes' => $volsTable),
    'main_table.volume_id = volumes.entity_id', array('volume_name'));

to

$collection->getSelect()->join(array('volumes' => $volsTable),
    'volIds.volume_id = volumes.entity_id', array('volume_name'));

Magento 1.9 – Fix Call to Undefined Method Collection::getData()

Because your collection should extend Mage_Core_Model_Resource_Db_Collection_Abstract, not Mage_Core_Model_Resource_Db_Abstract.

But be careful with Collection::getData(). I described the pitfalls with this method here: How to correctly select the first item from a filtered collection?

getData() on collections works different from other methods. It does not check if the collection is loaded, instead it checks if the _data property is empty. When you load a collection, _data is not populated, only when you call getData()!

[...]

This results in a second database query as soon as you call getData() and this time, your new filter is applied. But it does not change the _items property, so your previously loaded result is still used for everything else.

By the way, I still did not come across any reasonable use case for this method. It's used internally by load() but probably should not have been public. The core doesn't use it from outside the collection class anywhere as far as I see.

Use getItems() instead to inspect the items of the collection.

Best Answer

Related Solutions

Magento 1.9 – Join Table to Product Collection to Display Custom Column in Catalog Grid

Change from

to

Magento 1.9 – Fix Call to Undefined Method Collection::getData()

Related Topic