Hjdcti

i have created event and observer checkout_onepage_controller_success_action
now I want to save data in the custom table of order success when order is placed
event.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
<event name="checkout_onepage_controller_success_action">
 <observer name="checkout_controller_success_action" 
 instance="MagnetoHometryonObserverAfterPlaceOrder" />
</event>
</config>

AfterPlaceOrder.php

<?php
namespace MagnetoHometryonObserver;

use MagentoFrameworkEventObserverInterface;
use MagentoFrameworkAppRequestDataPersistorInterface;
use MagentoFrameworkAppObjectManager;

class AfterPlaceOrder implements ObserverInterface

protected $_order;
public function __construct(
 MagentoSalesApiDataOrderInterface $order
) 
 $this->_order = $order; 


/**
 *
 * @param MagentoFrameworkEventObserver $observer
 * @return void
 */
public function execute(MagentoFrameworkEventObserver $observer)

 $orderids = $observer->getEvent()->getOrderIds();

 foreach($orderids as $orderid)
 $order = $this->_order->load($orderid);
 

now on order success, I have to save entry in custom table

Try this,

Your observer file should be like this,

Inject your model in your constructor then create factory object of that and insert data into it like below

<?php
namespace MagnetoHometryonObserver;
use MagentoFrameworkEventObserverInterface;
use MagentoFrameworkAppRequestDataPersistorInterface;
use MagentoFrameworkAppObjectManager;
class AfterPlaceOrder implements ObserverInterface

protected $_order;
protected $_dataFactory;
public function __construct(
 MagentoSalesApiDataOrderInterface $order,
 VendorModuleNameModelDataFactory $dataFactory // this should be your model file
) 
 $this->_dataFactory = $dataFactory;
 $this->_order = $order; 


/**
 *
 * @param MagentoFrameworkEventObserver $observer
 * @return void
*/
public function execute(MagentoFrameworkEventObserver $observer)

 $order_ids = $observer->getEvent()->getOrderIds()[0];
 $order = $this->_order->get($order_ids); 
 $order_id = $order->getIncrementId();

 $saveData = $this->_dataFactory->create();
 $model->addData([
 "column_name" => $order_id,
 "column_name" => 'Content 01',
 "column_name" => true
 ]);
 $saveData = $model->save();
 if($saveData)
 $this->messageManager->addSuccess( __('Insert Record Successfully !') );
 

EDIT :

In similar way you can set order data into your custom table and get data like this

 $order_ids = $observer->getEvent()->getOrderIds()[0];
 $order = $this->_order->get($order_ids); 
 $order_id = $order->getIncrementId(); 
 $customer_email = $order->getCustomerEmail();
 foreach ($order->getAllVisibleItems() as $item)
 
 $item->getName();
 $item->getSku();
 

Hope this helps.