How can get all products of magento

How can get all products details in magento

<?php

$res = Mage::getSingleton('core/resource');

$eav = Mage::getModel('eav/config');

$nameattr = $eav->getAttribute('catalog_category', 'name');

$nametable = $res->getTableName('catalog/category') . '_' . $nameattr->getBackendType();

$nameattrid = $nameattr->getAttributeId();

 

//you could add here to select only the attributes you need but I'm lazy and I added all of them (*)

$collection = Mage::getModel('catalog/product')

            ->getCollection()->addAttributeToSelect('*');

$collection->joinTable('catalog/category_product',

    'product_id=entity_id', array('single_category_id' => 'category_id', 'position_in_category'=>'position'),

    null, 'left');

$collection->joinTable(

    $nametable,

    'entity_id=single_category_id',

    array('single_category_name' => 'value'),

    "attribute_id=$nameattrid",

    'left'

);

$collection->groupByAttribute('entity_id');

$collection->getSelect()

    ->columns(array('category_ids_values' => new Zend_Db_Expr("IFNULL(GROUP_CONCAT(`catalog_category_product`.`category_id` SEPARATOR ','), '')")))

    ->columns(array('position_values' => new Zend_Db_Expr("IFNULL(GROUP_CONCAT(`catalog_category_product`.`position` SEPARATOR ','), '')")))

    ->columns(array('category_names' => new Zend_Db_Expr("IFNULL(GROUP_CONCAT(`{$nametable}`.`value` SEPARATOR ','), '')")));

echo $collection->getSelect();

$final['prodCat_list'] = array();

$i = 0;

foreach ($collection as $product){

    $item = array();

    $item['sku']= $product->getSku();

    $item['product_id']= $product->getId();

    $item['name']= $product->getName();

    $item['image']=$product->getThumbnailUrl();

    $item['description']=$product->getDescription();

    $item['short_description']=$product->getShortDescription();

    $item['weight']=$product->getWeight();

    $item['created_at']=$product->getCreatedAt();

    $item['updated_at']=$product->getUpdatedAt();

    $item['price']=$product->getPrice();

    $item['special_price']=$product->getSpecialPrice();

    $item['tax_class_id']=$product->getTaxClassId();

    //this can be retrieved directly with $product->getCategoryIds, but they might be in a different order.

    $item['cat_id'] = $product->getCategoryIdsValues();

    $item['positions'] = $product->getPositionValues();

    $item['category_names'] = $product->getCategoryNames();

    $final['prodCat_list'][] = $item;

echo "<pre>";

print_r($product);

echo "<h1>".$item['price']."</h1>";

}

?>