Displaying Database Table Values in Magento 2 Frontend – Guide

magento-2.0.7magento-2.1magento2-dev-beta

In Magento 1.9 i used this code to get the database table values.

$model = Mage::getModel('task_creation/details');

   $collections = $model->getCollection();

foreach($collections as $collection)
{
  print_r($collection->getdata(''));
}

Now I am using Magento 2.1, what's the code I need to use for it. I am new to Magento 2.

Best Answer

For that you first create the Model So in my case Module name is News

app/code/FME/News/Model/News.php

<?php
namespace FME\News\Model;

class News extends \Magento\Framework\Model\AbstractModel implements NewsInterface, \Magento\Framework\DataObject\IdentityInterface
{
    const CACHE_TAG = 'id';
    const ENABLED = 1;
    const DISABLED = 0;
    const COMPLETE = 0;
    const LEFT = 1;
    const RIGHT = 2;


    protected function _construct()
    {
        $this->_init('FME\News\Model\ResourceModel\News');
    }

    public function getIdentities()
    {
        return [self::CACHE_TAG . '_' . $this->getId()];
    }



}

Then create interface for model app/code/FME/News/Model/NewsInterface.php

<?php
namespace FME\News\Model;
interface NewsInterface 
{

}

then create resource model

app/code/FME/News/Model/ResourceModel/News.php

 <?php
namespace FME\News\Model\ResourceModel;

class News extends \Magento\Framework\Model\ResourceModel\Db\AbstractDb
{
    protected function _construct()
    {
        $this->_init('fme_news','id');
    }

}

Then create collection app/code/FME/News/Model/ResourceModel/News/Collection.php

<?php
namespace FME\News\Model\ResourceModel\News;
class Collection extends \Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection
{
    protected $_idFieldName = 'id';
    protected function _construct()
    {
        $this->_init('FME\News\Model\News','FME\News\Model\ResourceModel\News');
    }
}

Now get the collection

protected $newscollectionFactory;
    public function __construct(....
\FME\News\Model\ResourceModel\News\CollectionFactory $newscollectionFactory
    ....)
    {
        ....
        $this->newscollectionFactory = $newscollectionFactory;
            .....
    }
    public function getNews()
    {


        $newsCollection = $this->newscollectionFactory->create();
        return $newsCollection;
    }

Related Solutions

Magento – Module created gives Error filtering template: {Classname} does not implement BlockInterface

The problem is caused by the fact that your block does not extend a Magento native block.

You need to update your block code like this:

<?php

namespace {Company}\GetProductCollection\Block;

class CeloGetProductCollection extends \Magento\Framework\View\Element\Template
{

  protected $categoryFactory;

  public function __construct(
      \Magento\Framework\View\Element\Template\Context $context,
      \Magento\Catalog\Model\CategoryFactory $categoryFactory,
      array $data = []
  ){
      $this->categoryFactory = $categoryFactory;
      parent::__construct($context, $data);
  }

  public function getCategory()
  {
    $categoryId = $this->getCategoryId();
    $category = $this->categoryFactory->create()->load($categoryId);
    return $category;
  }

  public function getProductCollection()
  {
    return $this->getCategory()->getProductCollection()->addAttributeToSelect('*');
  }

}

On top of that you made a typo getCagetory instead of getCategory

Magento – Magento 2 : How to send data from controller to block and display on front end

For sending data from controller to block, you can use registry

Controller

protected $_coreRegistry = null;

public function __construct(
      ....

        \Magento\Framework\Registry $_coreRegistry
    ) {
       .....
        $this->_coreRegistry = $_coreRegistry;
        ....
    }
   public function execute()
    {

        $postModel = $this->_modelPostFactory->create();

        // Load the item with ID is 1
        $item = $postModel->load(1);
      //  var_dump($item->getData());

        // Get news collection
        $postCollection = $postModel->getCollection();
        // Load all data of collection
         var_dump($postCollection->getData());
       $this->_coreRegistry->register('data_test', $postCollection);

    }

Block

 protected $_coreRegistry = null;


public function __construct(
      ....

        \Magento\Framework\Registry $_coreRegistry
    ) {
       .....
        $this->_coreRegistry = $_coreRegistry;
        ....
    }
   public function test()
    {
        $postCollection = $this->_coreRegistry->registry('data_test');
    }

Best Answer

Related Solutions

Magento – Module created gives Error filtering template: {Classname} does not implement BlockInterface

Magento – Magento 2 : How to send data from controller to block and display on front end

Related Topic