Read More
Read More
Menu Close

    Add More Than One Connection With Multiple Database in Magento2

    Add More Than One Connection With Multiple Database in Magento2.

    Today I am going to explain that how you can add multiple connections with multiple databases in magento 2 in this article. Suppose you have to display some data from another database instead of magento’s default database so this blog will be very helpful for you.

    At first you will need to edit app/etc/env.php, to give connection configuration for another database, like below:

     

     'db' =>
      array (
        'table_prefix' => '',
        'connection' =>
        array (
          'default' =>
          array (
            'host' => 'localhost',
            'dbname' => 'magento2',
            'username' => 'magento2_username',
            'password' => 'magento2_password',
            'active' => '1',
          ), // this array is from magento default
          'custom' =>
          array (
            'host' => 'localhost', //your custom db host
            'dbname' => 'customdb', //your custom db name
            'username' => 'cuatom_username', //your custom db username
            'password' => 'custom_password', //your custom db password
            'active' => '1', // 1 is for active database 
          ), // this array is added by me
        ),
      ),
      'resource' =>
      array (
        'default_setup' =>
        array (
          'connection' => 'default', 
        ), //this is magento default array
        'custom' =>
        array (
          'connection' => 'custom',
        ), //this resource is given by me
      ),

     

    Searching for an experienced
    Magento 2 Company ?
    Read More

    Now, you have a controller file in which you want data from custom database, then below is the code for that:

     

    <?php
    namespace Company\Module\Controller\Index;
    
    use Magento\Framework\App\Action\Action;
    use Magento\Framework\App\Action\Context;
    
    class Index extends Action
    {
         private $connection;
    
        /**
         * @param Context                               $context
         */
        public function __construct(
            Context $context,
            \Magento\Framework\App\ResourceConnection $resourceConnection
        ) {
            $this->connection = $resourceConnection->getConnection('custom'); // "custom" is your database connection name which is given in env.php
            parent::__construct($context);
        }
    
        public function execute()
        {
            try {
                $select = $this->connection->select()->from(['student_info']); //student_info is a table in customdb, this query is to select table
                $data = $this->connection->fetchAll($select); //here fetching all rows from student_info table
                echo "<pre>";
                print_r($data); //print that data in array
            } catch (\Exception $e) {
            }
        }
    }
    

     

    Now when you hit above controller output will be as follows :

    data in table

    data when you print

     

    Hope this blog will help you to develop custom functionality in your module in a better way. Try this and if you have any query then just comment below 🙂

    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    1 comments

  • Aqbal
    How to geet 4 tabel data using model get value
  • Back to Top