How to Insert record in database-table through custom module in magento2

Question

I have create a custom module and database-table using following this steps and i understand the table displaying in customer_side.

Now I Need to Know the Insert operation in customer_side please give me any example or link for insertion process custom module in magento2.

• Prathap Gunasekaran: magento.stackexchange.com/questions/274903/…
• manoji: Thank you for the link
• manoji: Thanks for Help... I Need to Know the Insert and select operation (without use to model) It's Possible or Not?
• Prathap Gunasekaran: Yes possible via sql query in that case you don't model and all just a table to perform actions on it @manoji
• Prathap Gunasekaran: Ask a separate question may myself or someone will answer to that @manoji

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

execute()
{
 // insert
 $model = $this->customTable->create();
 // update
 $model = $this->customTable->create();
 $model->load('id',$id_to_update);
 $model->setField_Name('values to be stored');
 $model->save();
}

In order to get collection

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

Hope this helps.
Copied form Insert, Update values in existing custom table and Select values from that table. Magento2