Magento – Magento 2 Insert Data into custom table using Collection Factory

magento2

I am following tutorials at http://alanstorm.com/magento_2_crud_models_for_database_access/ for creating my extension but theres one key part of that tutorial that appears to be out of date.

This Part :

$todo = $this->toDoFactory->create();
$todo->setData('item_text','Finish my Magento article')
->save();

SetData and Save no longer work this way.

So how can I use a Collection Factory to create a new item in my table?

Best Answer

Nevermind, I figured it out.

First you would do $this->toDoFactory->create()->getNewEmptyItem(); And then continue on with setting data and saving.

Related Solutions

Magento 2 Filter Product Collection by Store ID – How to Guide

You can do this with the method addStoreFilter(), see Magento\Catalog\Model\ResourceModel\Product\Collection#addStoreFilter()

the addStoreFilter() function will accept store ID or Store object as a parameter.

EG, to get all products for the current store:

public function getProducts(){
    return $this->collection->addStoreFilter($this->_storeManager->getStore()); 
}

Hopefully, this helps.

Magento2 Database – How to Insert Data into Custom Table in Model File

If you wants to insert data you can try below way,

Insert Custom Query.

$this->_resources = \Magento\Framework\App\ObjectManager::getInstance()
->get('Magento\Framework\App\ResourceConnection');
$connection= $this->_resources->getConnection();

$themeTable = $this->_resources->getTableName('yourtablename');
$sql = "INSERT INTO " . $themeTable . "(field1, field2) VALUES ('1', 'NameABC')";
$connection->query($sql);

Best Answer

Related Solutions

Magento 2 Filter Product Collection by Store ID – How to Guide

Magento2 Database – How to Insert Data into Custom Table in Model File

Related Topic