{"id":1692,"date":"2021-03-30T10:22:56","date_gmt":"2021-03-30T10:22:56","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/update-table-data-in-magento-2\/"},"modified":"2025-07-17T09:31:37","modified_gmt":"2025-07-17T04:01:37","slug":"update-table-data-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/update-table-data-in-magento-2\/","title":{"rendered":"How to Update Table Data in Magento 2"},"content":{"rendered":"\n

We already learned how to delete data from table in Magento 2<\/a>.<\/p>\n\n\n\n

Now, if you want to update table data in Magento 2, do follow the below post.<\/p>\n\n\n\n

Once you add the record to a table, it often requires updating that data due to some reason. In that situation, it is not a good practice to delete that record and add it again. Moreover, that\u2019s time-consuming and frustrating too.<\/p>\n\n\n\n

To overcome this kind of situation, use this method to update table data in\u00a0Magento 2\u00a0store and directly update the record by clicking on the \u2018edit\u2019 button.<\/p>\n\n\n\n

Method to Update Table Data in Magento 2<\/h2>\n\n\n\n

1. Use the below code in the Showdata.php<\/strong> file at app\/code\/Meetanshi\/Extension\/Block<\/strong><\/strong><\/p>\n\n\n\n

<?php\n\nnamespace Meetanshi\\Extension\\Block;\n\nuse Magento\\Framework\\View\\Element\\Template;\nuse Magento\\Backend\\Block\\Template\\Context;\nuse Meetanshi\\Extension\\Model\\ResourceModel\\Extension\\CollectionFactory;\n\nclass Showdata extends Template\n{\n\n    public $collection;\n\n    public function __construct(Context $context, CollectionFactory $collectionFactory, array $data = [])\n    {\n        $this->collection = $collectionFactory;\n        parent::__construct($context, $data);\n    }\n\n    public function getCollection()\n    {\n        return $this->collection->create();\n    }\n\n    public function getDeleteAction()\n    {\n        return $this->getUrl('extension\/index\/delete', ['_secure' => true]);\n    }\n\n    public function getEditAction()\n    {\n        return $this->getUrl('extension\/index\/index', ['_secure' => true]);\n    }\n\n}<\/pre>\n\n\n\n
2. Use the below code in showdata.phtml <\/strong>at app\/code\/Meetanshi\/Extension\/view\/frontend\/templates<\/strong><\/strong><\/p>\n\n\n\n
<?php\n$collection = $block->getCollection();\nif ($collection->count()) {\n    ?>\n    <div class=\"table-wrapper orders-history\">\n        <table class=\"data table table-order-items history\" id=\"my-orders-table\">\n            <caption class=\"table-caption\"><?php echo __('Grid Record') ?><\/caption>\n            <thead>\n            <tr>\n                <th scope=\"col\" class=\"col id\"><?php echo __('ID') ?><\/th>\n                <th scope=\"col\" class=\"col name\"><?php echo __('Name') ?><\/th>\n                <th scope=\"col\" class=\"col email\"><?php echo __('Email') ?><\/th>\n                <th scope=\"col\" class=\"col telephone\"><?php echo __('Telephone') ?><\/th>\n                <th scope=\"col\" class=\"col createat\"><?php echo __('Created At') ?><\/th>\n                <th scope=\"col\" class=\"col action\"><?php echo __('Action') ?><\/th>\n            <\/tr>\n            <\/thead>\n            <tbody>\n            <?php\n            foreach ($collection as $item): ?>\n                <tr>\n                    <td data-th=\"<?= $block->escapeHtml(__('ID')) ?>\" class=\"col id\">\n                        <?php echo $item->getId() ?>\n                    <\/td>\n                    <td data-th=\"<?= $block->escapeHtml(__('Name')) ?>\" class=\"col name\">\n                        <?php echo $item->getName() ?>\n                    <\/td>\n                    <td data-th=\"<?= $block->escapeHtml(__('Email')) ?>\" class=\"col email\">\n                        <?php echo $item->getEmail() ?>\n                    <\/td>\n                    <td data-th=\"<?= $block->escapeHtml(__('Telephone')) ?>\" class=\"col telephone\">\n                        <?php echo $item->getTelephone() ?>\n                    <\/td>\n                    <td data-th=\"<?= $block->escapeHtml(__('Created At')) ?>\"\n                        class=\"col title\"><?php echo date('Y-m-d', strtotime($item->getCreatedAt())); ?>\n                    <\/td>\n                    <td data-th=\"<?= $block->escapeHtml(__('Action')) ?>\" class=\"col delete\">\n                        <a href=\"<?php echo $block->getDeleteAction() . 'id\/' . $item->getId(); ?>\"><?php echo __('Delete') ?><\/a>\n                        <a style=\"margin-left: 9px\"\n                           href=\"<?php echo $block->getEditAction() . 'id\/' . $item->getId(); ?>\"><?php echo __('Edit') ?><\/a>\n                    <\/td>\n                <\/tr>\n            <?php endforeach; ?>\n            <\/tbody>\n        <\/table>\n    <\/div>\n    <?php\n}\n?><\/pre>\n\n\n\n
3. Use the below code in the Index.php <\/strong>file at app\/code\/Meetanshi\/Extension\/Controller\/Index<\/strong><\/strong><\/p>\n\n\n\n
<?php\n\nnamespace Meetanshi\\Extension\\Controller\\Index;\n\nuse Magento\\Framework\\App\\Action\\Action;\nuse Magento\\Framework\\App\\Action\\Context;\nuse Magento\\Framework\\Controller\\ResultFactory;\nuse Magento\\Framework\\UrlInterface;\nuse Magento\\Framework\\View\\Result\\PageFactory;\nuse Meetanshi\\Extension\\Model\\ExtensionFactory;\n\nclass Index extends Action\n{\n    protected $resultPageFactory;\n\n    private $extensionFactory;\n\n    private $url;\n\n    public function __construct(UrlInterface $url, ExtensionFactory $extensionFactory, Context $context, PageFactory $resultPageFactory)\n    {\n        parent::__construct($context);\n        $this->resultPageFactory = $resultPageFactory;\n        $this->extensionFactory = $extensionFactory;\n        $this->url = $url;\n    }\n\n    public function execute()\n    {\n        if ($this->isCorrectData()) {\n            return $this->resultPageFactory->create();\n        } else {\n            $this->messageManager->addErrorMessage(__(\"Record Not Found\"));\n            $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT);\n            $resultRedirect->setUrl($this->url->getUrl('extension\/index\/showdata'));\n            return $resultRedirect;\n        }\n    }\n\n    public function isCorrectData()\n    {\n        if ($id = $this->getRequest()->getParam(\"id\")) {\n            $model = $this->extensionFactory->create();\n            $model->load($id);\n            if ($model->getId()) {\n                return true;\n            } else {\n                return false;\n            }\n        } else {\n            return true;\n        }\n    }\n}<\/pre>\n\n\n\n
4. Paste the below code in the Form.php <\/strong>file at app\/code\/Meetanshi\/Extension\/Block<\/strong><\/strong><\/p>\n\n\n\n
<?php\n\nnamespace Meetanshi\\Extension\\Block;\n\nuse Magento\\Backend\\Block\\Template\\Context;\nuse Magento\\Framework\\View\\Element\\Template;\nuse Meetanshi\\Extension\\Model\\ExtensionFactory;\n\nclass Form extends Template\n{\n    private $extensionFactory;\n\n    public function __construct(ExtensionFactory $extensionFactory, Context $context, array $data = [])\n    {\n        parent::__construct($context, $data);\n        $this->extensionFactory = $extensionFactory;\n    }\n\n    public function getFormAction()\n    {\n        return $this->getUrl('extension\/index\/submit', ['_secure' => true]);\n    }\n\n    public function getAllData()\n    {\n        $id = $this->getRequest()->getParam(\"id\");\n        $model = $this->extensionFactory->create();\n        return $model->load($id);\n    }\n}<\/pre>\n\n\n\n
5. Use the below code in the form.phtml <\/strong>file at app\/code\/Meetanshi\/Extension\/view\/frontend\/templates<\/strong><\/strong><\/p>\n\n\n\n
<?php\n$data = $block->getAllData();\n$name = '';\n$email = '';\n$telephone = '';\nif ($data->getId()) {\n    $name = $data->getName();\n    $email = $data->getEmail();\n    $telephone = $data->getTelephone();\n}\n?>\n<div class=\"row\">\n    <div class=\"col-md-8\">\n        <form name=\"addData\" method=\"post\" id=\"addData\" class=\"form\"\n              action=\"<?php echo $this->getFormAction(); ?>\"\n              data-hasrequired=\"<?= $block->escapeHtmlAttr(__('* Required Fields')) ?>\"\n              data-mage-init='{\"validation\":{}}'>\n            <fieldset class=\"fieldset\">\n                <legend class=\"legend\"><span><?= $block->escapeHtmlAttr(__('Fill Detail')) ?><\/span><\/legend>\n                <fieldset class=\"fieldset row\">\n                    <?php\n                    if ($data->getId()) {\n                        ?>\n                        <input type=\"hidden\" name=\"id\" value=\"<?php echo $data->getId(); ?>\">\n                        <?php\n                    } ?>\n                    <div class=\"fields col-md-6\">\n                        <div class=\"field name required\">\n                            <label class=\"label\" for=\"title\"><span><?= $block->\n                                    escapeHtmlAttr(__('Name')) ?><\/span><\/label>\n                            <div class=\"control\">\n                                <input name=\"name\" id=\"name\" title=\"Name\" value=\"<?php echo $name ?>\" class=\"input-text\"\n                                       type=\"text\"\n                                       data-validate=\"{required:true, 'validate-alphanum-with-spaces':true}\">\n                            <\/div>\n                        <\/div>\n                        <div class=\"field name required\">\n                            <label class=\"label\" for=\"title\"><span><?= $block->\n                                    escapeHtmlAttr(__('Email')) ?><\/span><\/label>\n                            <div class=\"control\">\n                                <input name=\"email\" id=\"email\" title=\"Email\" value=\"<?php echo $email; ?>\"\n                                       class=\"input-text\" type=\"text\"\n                                       data-validate=\"{required:true, 'validate-email':true}\">\n                            <\/div>\n                        <\/div>\n                        <div class=\"field name required\">\n                            <label class=\"label\" for=\"title\"><span><?= $block->escapeHtmlAttr(__('Telephone')) ?><\/span><\/label>\n                            <div class=\"control\">\n                                <input name=\"telephone\" id=\"telephone\" title=\"Telephone\"\n                                       value=\"<?php echo $telephone; ?>\" class=\"input-text\"\n                                       type=\"text\" data-validate=\"{required:true}\">\n                            <\/div>\n                        <\/div>\n                    <\/div>\n                <\/fieldset>\n            <\/fieldset>\n            <div class=\"actions-toolbar\">\n                <div class=\"primary\">\n                    <button type=\"submit\" class=\"action submit primary\" title=\"Save\"><span><?= $block->\n                            escapeHtmlAttr(__('Save')) ?><\/span><\/button>\n                <\/div>\n            <\/div>\n        <\/form>\n    <\/div>\n<\/div><\/pre>\n\n\n\n
6. Use the below code in the Submit.php <\/strong>file at app\/code\/Meetanshi\/Extension\/Controller\/Index<\/strong><\/strong><\/p>\n\n\n\n
<?php\n\nnamespace Meetanshi\\Extension\\Controller\\Index;\n\nuse Magento\\Framework\\App\\Action\\Action;\nuse Magento\\Framework\\App\\Action\\Context;\nuse Magento\\Framework\\Controller\\ResultFactory;\nuse Magento\\Framework\\UrlInterface;\nuse Magento\\Framework\\View\\Result\\PageFactory;\nuse Meetanshi\\Extension\\Model\\ExtensionFactory;\n\nclass Submit extends Action\n{\n    protected $resultPageFactory;\n    protected $extensionFactory;\n    private $url;\n\n    public function __construct(\n        UrlInterface $url,\n        Context $context,\n        PageFactory $resultPageFactory,\n        ExtensionFactory $extensionFactory\n    )\n    {\n        $this->resultPageFactory = $resultPageFactory;\n        $this->extensionFactory = $extensionFactory;\n        $this->url = $url;\n        parent::__construct($context);\n    }\n\n    public function execute()\n    {\n        try {\n            $data = (array)$this->getRequest()->getPost();\n\n            if ($data) {\n                $model = $this->extensionFactory->create();\n                $model->setData($data)->save();\n                $this->messageManager->addSuccessMessage(__(\"Data Saved Successfully.\"));\n            }\n        } catch (\\Exception $e) {\n            $this->messageManager->addErrorMessage($e, __(\"We can\\'t submit your request, Please try again.\"));\n        }\n        $resultRedirect = $this->resultFactory->create(ResultFactory::TYPE_REDIRECT);\n        $resultRedirect->setUrl($this->url->getUrl('extension\/index\/showdata'));\n        return $resultRedirect;\n    }\n}<\/pre>\n\n\n\n
Once you\u2019ve set the above code, the \u2018Edit\u2019 action column will be added to the table as shown below.<\/p>\n\n\n
\n
\"How<\/figure>\n<\/div>\n\n\n
The edit form will be open after clicking on the \u2018Edit\u2019 button.<\/p>\n\n\n\n
\"How<\/figure>\n\n\n\n
Once you update the data, it shows a message that notifies you a message as shown below.<\/p>\n\n\n
\n
\"How<\/figure>\n<\/div>\n\n\n
Done!<\/p>\n\n\n\n
Also read:<\/strong> Alternative to Magento 2 Deprecated Load, Save and Delete Methods<\/a>.<\/p>\n\n\n\n
Do share the solution with Magento Community via social media.<\/p>\n\n\n\n
Thank you.<\/p>\n\n\n\n
Read more:<\/p>\n\n\n\n