Magento – Getting Products Count and Products Per Page

ce-1.8.1.0pagination

I'm using this code getting products. And also using some addAttributeToFilter method for filter.

$collection = Mage::getResourceModel('reports/product_collection')
    ->addAttributeToSelect('*')
    ->addStoreFilter()
    ->setOrder('created_at', 'desc')
    ->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds());

Also I'm using $collection->count() code to get products count.

I'm trying to write my own pagination. (My products page is really complicated.)

Then I use this code setPage($pageNumber, $productsPerPage) to paginate.

But if I'm gonna paginate $collection->count() function return $productsPerPage number.

For example:

setPage(1, 6) // 6 product per page
$collection->count() // return 6 (but I have 16 products!)

If I use only $collection->count() code, it return 16!

What I'm missing?

I hope you guys understand me.

Best Answer

$collection->count() loads the collection and returns the number of products matching the select associated to the collection.
I think you are looking for $collection->getSize(). This will get you the total number of products matching the select, but ignores the limit.
Also getSize does not load the collection, so it's faster.

Related Solutions

Magento – Magento count pagination sizes

A pagination is linked to a collection. To get the total number of pages use this:

$collection->getLastPageNumber();

If you have a pagination block in your page you can get the last page number like this:

$block->getLastPageNum();

Magento – Create magento pagination in custom product collection inside phtml file

Your concept is slightly lacking. The query should be at least moved outside of the template into Block class.

Then in the same class you can add something like this to solve your pagination issue:

protected function _beforeToHtml()
{
    $blockName = $this->getToolbarBlockName();
    if (!$blockName) {
        $blockName = 'product_list_toolbar';
        $this->setToolbarBlockName($blockName);
        $this->getLayout()->createBlock(
            $this->_defaultToolbarBlock,
            $blockName,
            array(
                 'show_toolbar' => $this->getData('show_toolbar'),
                 'list_mode' => $this->getData('list_mode'),
                 '_current_limit' => $this->getData('limit')
            ))
            ->setChild(
                $blockName . '_pager',
                $this->getLayout()->createBlock('page/html_pager', $blockName . '_pager')
            );
    }

    return parent::_beforeToHtml();
}

Unless you make fun of reinventing the wheel you can also use this extension to create a listing of all products of your store along with couple of other useful listings:

https://github.com/tim-bezhashvyly/CustomListing

Best Answer

Related Solutions

Magento – Magento count pagination sizes

Magento – Create magento pagination in custom product collection inside phtml file

Related Topic