I have created a custom module and created a database table using install schema like below:
id color price_component
1 white 0
2 red 4
3 green 8
4 black 12
How can I display this table in my .phtml file?
I'm new to Magento. If someone can explain this step by step that would be really helpful.
You can used this for getting table in phtml file
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('your_table_name');
//Select Data from table
$sql = "Select * FROM " . $tableName;
$result = $connection->fetchAll($sql);
You need to create block, template and layout files for this. Create a new file app\code\Your_ExtensionName\Your_ModuleName\Block\Post.php
<?php
namespace Your_ExtensionName\Your_ModuleName\Block;
use Magento\Framework\View\Element\Template;
class Post extends Template
{
protected $mymodulemodelFactory;
public function __construct(
Template\Context $context,
\Your_ExtensionName\Your_ModuleName\Model\ResourceModel\Post\CollectionFactory $mymodulemodelFactory,
array $data = []
) {
parent::__construct($context, $data);
$this->mymodulemodelFactory = $mymodulemodelFactory;
$this->_isScopePrivate = true;
}
public function getPosts(){
$collection = $this->mymodulemodelFactory->create();
return $collection;
}
}
Now create layout file app\code\Your_ExtensionName\Your_ModuleName\view\frontend\layout\Your_ModuleName_index_index.xml
<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="1column" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
<body>
<referenceContainer name="content">
<block class="Your_ExtensionName\Your_ModuleName\Block\Post" name="posts" template="Your_ExtensionName_Your_ModuleName::post.phtml">
</block>
</referenceContainer>
</body>
</page>
Now create app\code\Your_ExtensionName\Your_ModuleName\view\frontend\templates\post.phtml
<?php $collection = $this->getPosts(); ?>
<div class="yourtable">
<?php foreach ($collection as $item){ ?>
<div class="yourtable">
<?php
// Display your data
?>
</div>
<?php } ?>
</div>
