Please, how we can use sql queries on controller? i am using Magento 2 and this is my controller:
<?php
namespace Demo\Demo\Controller\Demo;
class Demo extends \Magento\Framework\App\Action\Action
{
public function execute()
{
}
}
asked Jun 10, 2016 at 15:23
-
'sql queries' - means? 'select * from ....' this type flat query?– Sohel RanaCommented Jun 10, 2016 at 15:37
-
all sql queries– Samir AFALLAHCommented Jun 10, 2016 at 15:45
-
You should go with ResourceModel.– Sohel RanaCommented Jun 10, 2016 at 16:22
-
follow this link magento.stackexchange.com/questions/112057/… I hope this is useful for you..– Rajkumar .ECommented Jun 11, 2016 at 5:22
Add a comment
|
2 Answers
You can use ResourceConnection Method if you wish to use sql queries in Controller.
$resource = $this->_objectManager->create('\Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection(\Magento\Framework\App\ResourceConnection::DEFAULT_CONNECTION);
$values = $connection->fetchAll('select * from `table` ');
-
7I disagree for two reasons: one should never use the object manager directly and every SQL queries must always be executed from the resource models that's their purpose Commented Jun 11, 2016 at 8:45
You should not do it in controller. ResourceModel Layer is resposible for data persistence
