Month: August 2018

Posted on

How to get table name with prefix in Magento 2?

You can fetch prefix values from the table name in Magento 2. If your database table has set prefix value for all the tables and wants to fetch that value you can read the next portion.

Let’s say, You have added Prefix value as mage_ for all the tables.

Using getTableName() method, you can get a table with prefix code always,

<?php
namespace Your\PathTo\Model;

use Magento\Framework\App\ResourceConnection;

class PrefixTable
{

    public function __construct(
        ResourceConnection $resource
    ) {
        $this->resource = $resource;
    }

   public function getPrefixTable()
   {
    /* Create Connection */
        $connection  = $this->resource->getConnection();
        $tableName   = $connection->getTableName('sales_order'); // return "prefix_sales_order"

    /* Run Row query */
        $query = "SQL Query";
        $connection->query($query);
    }
}

In the above function, your table will get a prefix value with the table name.
If your table has a prefix as mage_ then your table value will get like, mage_sales_order

Posted on

How to Convert CMS page content to html interpretation in Magento 2?

We can convert CMS page content into HTML specific format using native Magento class.

We need to use, \Magento\Cms\Model\Template\FilterProvider class to filter page content in the template file.
In PHP file,

<?php
public function __construct(
    \Magento\Cms\Model\Template\FilterProvider $filter
) {
    $this->filter = $filter;
}
/*
* Page content $content
*/
public function getContentFromPage($content)
{
    return $this->filter->getPageFilter()->filter($content);
}

Call from template file,

$content = "YOUR_CMS_PAGE_CONTENT";
echo $this->getContentFromPage($content);
Posted on

How to filter CMS Page(Block) content in template file using magento 2?

Sometimes we have defined a native static variable in Static Block in Magento 2 and we need to call that block in template file at that time static variable will not be interpreted,
Like Custom variable {{config path=”web/unsecure/base_url”}} in static block. using below method content will be displayed the dynamic value of static block variables.
We need to use, \Magento\Cms\Model\Template\FilterProvider class to filter static content in Blocks.

<?php
public function __construct(
    \Magento\Cms\Model\Template\FilterProvider $filter
) {
    $this->filter = $filter;
}
/*
* Static block $content
*/
public function getContentFromStaticBlock($content)
{
    return $this->filter->getBlockFilter()->filter($content);
}

Call from the template file,

$content = "YOUR_STATIC_BLOCK_CONTENT";
echo $this->getContentFromStaticBlock($content);

The result will be displayed filterable static variable value with your content.