I want to insert a value into my custom database table in magento.. how do i do it with Magnento ORM without using direct query?

I want to insert a value into my custom database table in magento.. how do i do it with Magnento ORM without using direct query?

September 3, 2026 · Illustrated author avatarBy Stefan Bogdanescu
I want to insert a value into my custom database table in magento.. how do i do it with Magnento ORM without using direct query?

Inserting Data into Custom Tables Using Magento ORM

Hello! I’m excited to help you navigate through this common scenario of inserting data into custom database tables using Magento’s Object-Relational Mapping (ORM) system without resorting to raw SQL queries.

Understanding Magento ORM

Magento’s ORM is a powerful tool that bridges the gap between your application logic and the underlying MySQL database. It provides an object-oriented interface for interacting with your database, making it easier to write clean, maintainable code.

Creating Your Custom Table and Model

Let’s assume you have created a custom table called custom_table in your Magento installation’s database. The table schema might look something like this:

CREATE TABLE `custom_table` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
);

Next, you would create a corresponding model class in your Magento module. For example, if your module’s namespace is “Vendor_Custom”, the model would be located at app/code/Vendor/Custom/Model/CustomTable.php:

<?php

namespace Vendor\Custom\Model;

class CustomTable extends \Magento\Framework\Model\AbstractModel
{
    protected function _construct()
    {
        $this->_init('Vendor\Custom\Model\ResourceModel\CustomTable');
    }
}

Inserting Data Using Magento ORM

Now, let’s create a resource model and use it to insert data into our custom table:

<?php

namespace Vendor\Custom\Model\ResourceModel;

class CustomTable extends \Magento\Framework\Model\ResourceModel\Db\AbstractDb
{
    protected function _construct()
    {
        $this->_init('custom_table', 'id');
    }

    public function save(\Vendor\Custom\Model\CustomTable $object)
    {
        $data = $object->getData();
        $this->_beforeSave($object);
        $this->_save($object);
        return $this;
    }
}

To insert data, you would typically perform the following steps:

  1. Create an instance of your model.
  2. Populate the data using the setData() method.
  3. Call the save() method on the resource model.

Here’s a simple example of how to use these components in a controller:

<?php

namespace Vendor\Custom\Controller\Index;

use Magento\Framework\App\Action\Context;
use Vendor\Custom\Model\CustomTableFactory;

class Index extends \Magento\Framework\App\Action\Action
{
    private $customTableFactory;

    public function __construct(Context $context, CustomTableFactory $customTableFactory)
    {
        $this->customTableFactory = $customTableFactory;
        parent::__construct($context);
    }

    public function execute()
    {
        $customTable = $this->customTableFactory->create();
        $customTable->setData([
            'name' => 'Example Data',
        ]);
        $resourceModel = $customTable->getResource();
        $resourceModel->save($customTable);

        // Proceed with other actions or return a response
    }
}

Conclusion

In this post, we’ve explored how to insert data into custom tables using Magento’s ORM. By leveraging the built-in resource models and following the object-oriented approach, you can keep your code clean and maintainable.

Remember that while direct SQL queries offer fine-grained control, they don’t benefit from the safety nets provided by Magento’s ORM—such as automatic field validation and data type checking. It pays to work with the framework when possible.

I hope this helps! Let me know if you have any other questions or need further clarification. Happy coding!

You can explore more advanced techniques at LaravelCompany.com.

Database Extensions

Our network