How can i Insert, Update values in existing custom table and Select values with Magento methods not sql requests ?

1 Answer 1


If you have model for your custom table then you do all these stuffs in the below way

Try this,

Di method :

Inject your model in your constructor

 protected function __construct(
 \Vendor\ModuleName\Model\ModelName $customTable,
   $this->customTable = $customTable;

then on your execute function from controller

  // insert
  $model = $this->customTable->create();
  // update
  $model = $this->customTable->create();

  $model->setField_Name('values to be stored');

In order to get collection

$model = $this->customTable->create()->getCollection();
foreach($model as $item){
    echo $item->getFiledName();      

For more information Get custom table information

Save values into custom table

Hope this helps.

  • 1
    Yes! Prathap Gunasekaran thank you for good information!
    – Robinio
    May 16, 2019 at 14:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.