Set limit on Magento Collections


<?php
$limit = 5;
$starting_from = 2;
$product_collection = Mage::getModel('catalog/product')->getCollection()->setOrder('name', 'asc'); //getting the product collection, results are ordered by product name
$product_collection->getSelect()->limit($limit,$starting_from);   //where $limit will be the number of results we want, $starting_from will be the index of the result set to be considered as starting point (note 0 is the index of first row)
//this will ouptput 5 records starting from 3rd record
foreach($product_collection as $_product)
{
    echo $_product->getName().'<br/>';
}
?>

Comments

Post a Comment

Popular posts from this blog

Sort Products by popularity count in Magento

Advance shorting option for category/list page in magento Note: Please Make  folder structure app/code/local  and place all files in same structure in this folder ,If you make changes in core files its your risk.please make proper backup for core files if you modify that . Step -1. For Advance shorting option you have to create new collection by overriding Collection class. Overrride the collection class(/app/code/core/Mage/Catalog/Model/Resource/Product/collection.php and create a new function <?php   public function sortByReview ( $dir ){ $table = $this -> getTable ( 'review/review' ); $entity_code_id = Mage :: getModel ( 'review/review' ) -> getEntityIdByCode (Mage_Rating_Model_Rating :: ENTITY_PRODUCT_CODE );    $cond = $this -> getConnection () -> quoteInto ( 't2.entity_pk_value = e.entity_id and ' , '' ) . $this -> getConnection () -> quoteInto ( 't2.entity_id = ? ' , $entity_code_id );    $this -
Read more

Safe name of a file by php

 function filename_safe($filename) {     $temp = $filename;      // Lower case     $temp = strtolower($temp);         // Replace spaces with a "_"     $temp = str_replace(" ", "_", $temp);         // Loop through string     $result = "";     for ($i=0; $i<strlen($temp); $i++) {     if (preg_match("([0-9]|[a-z]|_)", $temp[$i])) {     $result = $result . $temp[$i];     }     }     // Return filename     return $result;     }         function safe_filename ($filename) {     $search = array(     // Definition of German Umlauts START     "/ß/",     "/ä/","/Ä/",     "/ö/","/Ö/",     "/ü/","/Ü/",     // Definition of German Umlauts ENDE     "([^[:alnum:]_])" // Disallow: Not alphanumeric, dot or underscore     );     $replace = array(     "ss",     "ae","Ae",     "oe","Oe",    
Read more

Get width height of image using Varien-image class in Magento

You can get width height of image using Varien_Image (lib/Varien/Image.php) class object. In this example, I assume that your image is present inside media directory of your magento installation. $imagePath = YOUR_IMAGE_PATH_LINK; // like http://example.com/media/myfolder/myimage.jpg // changing url link of image into directory link $dirImg = Mage::getBaseDir().str_replace("/",DS,strstr($imagePath,'/media')); // getting image width and height if (file_exists($dirImg)) { $imageObj = new Varien_Image($dirImg); $width = $imageObj->getOriginalWidth(); $height = $imageObj->getOriginalHeight(); echo $width." x ".$height; } else { echo "File doesn't exist."; } Resize Image <?php echo $this ->helper( 'catalog/image' )->init( $_product , 'image' ) ->constrainOnly(TRUE) ->keepAspectRatio(TRUE) ->keepFrame(FALSE) ->resize(600,null) ?> Fixed h
Read more