Magento 2 offers to fetch the data from the default database table.<\/p>\n\n\n\n
However, to get data from custom database table in Magento 2, one will need to implement the solution below.<\/p>\n\n\n\n
You can use this code to get data for a custom module you developed or any custom feature for which you\u2019ll need data from a custom database table.<\/p>\n\n\n\n
Also, if you want to display any custom data on the frontend, for example, show customers\u2019 mobile number on the cart page or My Account, you\u2019ll have to fetch the data for implementing the same. If you are a developer.<\/p>\n\n\n\n
Create Data.php<\/strong><\/em> in app\/code\/[Vendor]\/[Module]\/Helper<\/strong><\/p>\n\n\n\n Now, you can use a helper function to get the custom table model collection as per your requirement.<\/p>\n\n\n\n That\u2019s it.<\/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 Related Post<\/strong><\/p>\n\n\n\n Magento 2 offers to fetch the data from the default database table. However, to get data from custom database table in Magento 2, one will need…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1008","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1008"}],"version-history":[{"count":4,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1008\/revisions"}],"predecessor-version":[{"id":14907,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1008\/revisions\/14907"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<?php\nnamespace [Vendor]\\[Module]\\Helper;\n\nuse [Vendor]\\[Module]\\Model\\CustomModelFactory;\nclass Data extends \\Magento\\Framework\\App\\Helper\\AbstractHelper\n{\n protected $customModelFactory;\n public function __construct(\n Context $context,\n CustomModelFactory $customModelFactory,\n array $data = array()\n ) {\n $this->customModelFactory = $customModelFactory;\n parent::__construct($context, $data);\n }\n public function getCollection()\n {\n return $this->customModelFactory->create()->getCollection();\n }\n}<\/pre>\n\n\n\n\n