Magento – How to show the total number of pages in the pagination bar

The problem is that the LIMIT is calculated based on "page size" and "current page" immediately before the collection is loaded. See Mage_Eav_Model_Entity_Collection_Abstract::_loadEntities():

public function _loadEntities($printQuery = false, $logQuery = false)
{
    if ($this->_pageSize) {
        $this->getSelect()->limitPage($this->getCurPage(), $this->_pageSize);
    }

You can prevent this by setting _pageSize to 0:

$productCollection->setPageSize(0);
$productCollection->getSelect()->limit(20,22);

Besides that, resetting the already loaded collection to load it again is not a good idea.

You can write an observer for catalog_product_collection_load_before to manipulate the limit right before the collection is loaded:

public function setProductPaging(Varien_Event_Observer $observer) 
{
    $collection = $observer->getCollection();
    if ($collection->getCurPage() == 1) {
        $collection->setPageSize(22);
    } else {
        $productCollection->setPageSize(0);
        $productCollection->getSelect()->limit(20, 22 + 20 * ($collection->getCurPage() - 2));
    }
}

You can get the current page number form url of that page.

Try below code

<?php Mage::app()->getRequest()->getParam('p')?>

For eg :

http://localhost/magento/index.php/shop.html?p=4

here get parameter "p" is the current page number of the pagination