How to use custom query mysql in magento2

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager $resource = $objectManager->get('Magento\Framework\App\ResourceConnection'); $connection = $resource->getConnection(); $tableName = $resource->getTableName('employee'); //gives table name with prefix //Select Data from table $sql = "Select *…

Update Custom Field value woocommerce

$product = wc_get_product( $product_id ); //echo $csvpro.''; exit; $product->update_meta_data( 'ean',sanitize_text_field( $csvpro )); $product->update_meta_data( 'grossweight', sanitize_text_field( $progrossweight ) ); $product->update_meta_data( 'expectedinweek', sanitize_text_field( $proexpectedinweek ) ); $product->update_meta_data( 'demostock', sanitize_text_field( $prodemostock ) );…