How To Create And Insert Data Into The Table In Magento 2

But InstallSchema could only be used once time as running with the module installation. If you want to change and modify the mandatory you should use UpgradeSchema. We’ll show you how to add columns by using UpgradeSchema table:

Create file UpgradeSchema.php in app/code/Bss/Schema/Setup/UpgradeSchema.php

<?php 
namespace Bss\Schema\Setup;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\DB\Ddl\Table;
class UpgradeSchema implements \Magento\Framework\Setup\UpgradeSchemaInterface{
 
	public function upgrade(SchemaSetupInterface $setup,ModuleContextInterface $context){
        $setup->startSetup();
        if (version_compare($context->getVersion(), '1.0.1', '<')) {
            $this->addStatus($setup);
        }
        $setup->endSetup();
	}
	
    /**
     * @param SchemaSetupInterface $setup
     * @return void
     */
    private function addStatus(SchemaSetupInterface $setup)
    {
        $setup->getConnection()->addColumn(
            $setup->getTable('data_example'),
            'status',
            [
                'type' => \Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
                'nullable' => true,
                'default' => 1,
                'comment' => 'Status'
            ]
        );
    }
}
?>

In which:

• version_compare($context->getVersion(), ‘1.0.1’, ‘<‘) is modified version of module
• addStatus () is function adding status column to table data_xample

Modify the module version in the module.xml file in Bss / Schema / etc / module.xml to run the UpgradeSchema.

<?xml version="1.0" ?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
	<module name="Bss_Schema" setup_version="1.0.1"/>
</config>

To add new column status to the table we run the following command:

php bin/magento setup:upgrade

Finally, check the database and see the status column added to the data_example table.

Magento 2 Insert Data into Table: Add The First Record

Step 1: Set up Model, create DataExample.php file in Bss/Schema/Model/DataExample.php.

<?php 
namespace Bss\Schema\Model;
class DataExample extends \Magento\Framework\Model\AbstractModel{
	public function _construct(){
		$this->_init("Bss\Schema\Model\ResourceModel\DataExample");
	}
}
 ?>

Step 2: Set up the ResourceModel, create the DataExample.php file in the Bss/Schema/Model/ResourceModel/DataExample.php.

<?php 
namespace Bss\Schema\Model\ResourceModel;
class DataExample extends \Magento\Framework\Model\ResourceModel\Db\AbstractDb{
 public function _construct(){
 $this->_init("data_example","id");
 }
}
 ?>

Step 3: Set up Collection, create Collection.php file in Bss/Schema/Model/ResourceModel/Collection.php.

<?php 
namespace Bss\Schema\Model\ResourceModel\DataExample;
class Collection extends \Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection{
	public function _construct(){
		$this->_init("Bss\Schema\Model\DataExample","Bss\Schema\Model\ResourceModel\DataExample");
	}
}
 ?>

Step 4: Set up Controller, create Index.php file in Bss/Schema/Controller/Index/Index.php.

<?php 
namespace Bss\Schema\Controller\Index;
use Bss\Schema\Model\DataExampleFactory;
use Magento\Framework\Controller\ResultFactory;
use Magento\Framework\App\Action\Context;
class Index extends \Magento\Framework\App\Action\Action{
    protected $_dataExample;
    protected $resultRedirect;
    public function __construct(\Magento\Framework\App\Action\Context $context,
        \Bss\Schema\Model\DataExampleFactory  $dataExample,
    \Magento\Framework\Controller\ResultFactory $result){
        parent::__construct($context);
        $this->_dataExample = $dataExample;
        $this->resultRedirect = $result;
    }
	public function execute(){
        $resultRedirect = $this->resultRedirect->create(ResultFactory::TYPE_REDIRECT);
        $resultRedirect->setUrl($this->_redirect->getRefererUrl());
		$model = $this->_dataExample->create();
		$model->addData([
			"title" => 'Title 01',
			"content" => 'Content 01',
			"status" => true,
			"sort_order" => 1
			]);
        $saveData = $model->save();
        if($saveData){
            $this->messageManager->addSuccess( __('Insert Record Successfully !') );
        }
		return $resultRedirect;
	}
}
 ?>

In which:

• $model: the model initialization variables.
• addData (): containing the key, column, and column values of the data passed.

Step 5: Configure route for the controller, create routes.xml in Bss/Schema file /etc/frontend/routes.xml.

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:App/etc/routes.xsd">
	<router id="standard">
		<route id="schema" frontName="schema">
			<module name="Bss_Schema" />
		</route>
	</router>
</config>

Run the schema controller to add the data to the table. Open link http://localhost/magento219/schema/.

Finally, checking in the database, you will see the data added to the data_example table like the below picture

Conclusion: Magento 2 Insert Data Into Custom Table

Magento 2 insert data into table is a crucial skill for managing your store’s database effectively. Whether you’re adding product information, customer details, or custom records, understanding the process allows for more control over your store’s backend. By following the steps and best practices outlined in this guide, you can ensure that your data insertion is smooth, secure, and efficient.

BSS Commerce is one of the leading Magento 2 extension providers and Magento 2 development services in the world. With experienced and certified Magento developers, we commit to bringing high-quality products and services to optimize your business effectively. Furthermore, we offer FREE Installation – FREE 1-year Support and FREE Lifetime Update for every Magento extension.

CONTACT NOW to let us know your problems. We are willing to support you every time.