Hello Magento Friends,
Today’s topic is How to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2? Do have a look at our recently published blog, How to Get User Information Inside of Controller in Magento 2.
While dealing with a database, the developer needs to check whether a particular column is available in a database table or not. This is usually required while applying some logic to the database. Follow the steps to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2.
Contents
Step 1: Navigate to the below path
app\code\Vendor\Extension\Setup\Recurring.php
And add the below code
namespace Vendor\Extension\Setup use Magento\Framework\DB\Ddl\Table; use Magento\Framework\Setup\ModuleContextInterface; use Magento\Framework\Setup\SchemaSetupInterface; Class Recurring implements \Magento\Framework\Setup\InstallSchemaInterface { public function install(SchemaSetupInterface $setup, ModuleContextInterface $context) { $isExist = $setup->getConnection()->tableColumnExists( $setup->getTable(‘Table_Name’), ‘Column_Name’ ); } }
Hence, this way you can Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2. If you have any doubts, ask me in the comment box without hesitation. Do share the solution with your friends and stay updated with us.
Happy Coding!
E-commerce has transformed the way consumers shop for products and services and interact with businesses.…
The e-commerce world is constantly in flux. New tech and strategies emerge daily to help…
Hello Magento Friends, In today’s blog, we will discuss adding a header and footer to…
Hello React Native Friends, Building a visually appealing and responsive mobile app is crucial in…
We're thrilled to announce the release of Hyvä Themes 1.3.6 and 1.3.7! These latest updates…
Your e-commerce platform is surging - orders are rolling in, traffic spikes are becoming the…